This is a sample file of the output generated when you perform a data scan to generate a schema configuration with attribute to attribute (A2A) associations.
See Scan the data and generate a schema (option 1).
Information noteThis is not generated when you use the management console to scan the data and create an index.
-
The ”associations” section defines the field mapping between tables for A2A creation.
Each “data” sub-section defines an association of a pair of fields from two different tables.
-
The ”tables” section defines the table/field structure of the dataset.
Example:
{
"associations": [
{
"data": [
{
"field": "c_nation_key",
"table_name": "customer"
},
{
"field": "n_nation_key",
"table_name": "nation"
}
],
"op": "add"
},
{
"data": [
{
"field": "c_cust_key",
"table_name": "customer"
},
{
"field": "o_cust_key",
"table_name": "order"
}
],
"op": "add"
},
{
"data": [
{
"field": "l_order_key",
"table_name": "lineitem"
},
{
"field": "o_order_key",
"table_name": "order"
}
],
"op": "add"
},
{
"data": [
{
"field": "l_part_key",
"table_name": "lineitem"
},
{
"field": "ps_part_key",
"table_name": "partsupp"
}
],
"op": "add"
},
{
"data": [
{
"field": "l_supp_key",
"table_name": "lineitem"
},
{
"field": "ps_supp_key",
"table_name": "partsupp"
}
],
"op": "add"
},
{
"data": [
{
"field": "n_region_key",
"table_name": "nation"
},
{
"field": "r_region_key",
"table_name": "region"
}
],
"op": "add"
},
{
"data": [
{
"field": "n_nation_key",
"table_name": "nation"
},
{
"field": "s_nation_key",
"table_name": "supplier"
}
],
"op": "add"
},
{
"data": [
{
"field": "p_part_key",
"table_name": "part"
},
{
"field": "ps_part_key",
"table_name": "partsupp"
}
],
"op": "add"
},
{
"data": [
{
"field": "ps_supp_key",
"table_name": "partsupp"
},
{
"field": "s_supp_key",
"table_name": "supplier"
}
],
"op": "add"
}
],
"data_set_name": "tpch",
"tables": [
{
"fields": [
{
"col_no": 0,
"name": "c_cust_key",
"type": "Int32Type"
},
{
"col_no": 1,
"name": "c_name",
"type": "StringType"
},
{
"col_no": 2,
"name": "c_address",
"type": "StringType"
},
{
"col_no": 3,
"name": "c_nation_key",
"type": "Int32Type"
},
{
"col_no": 4,
"name": "c_phone",
"type": "StringType"
},
{
"col_no": 5,
"name": "c_acct_bal",
"type": "DoubleType"
},
{
"col_no": 6,
"name": "c_mkt_segment",
"type": "StringType"
},
{
"col_no": 7,
"name": "c_comment",
"type": "StringType"
}
],
"name": "customer",
"num_indexlets": 1
},
{
"fields": [
{
"col_no": 0,
"name": "l_order_key",
"type": "Int32Type"
},
{
"col_no": 1,
"name": "l_part_key",
"type": "Int32Type"
},
{
"col_no": 2,
"name": "l_supp_key",
"type": "Int32Type"
},
{
"col_no": 3,
"name": "l_line_number",
"type": "Int32Type"
},
{
"col_no": 4,
"name": "l_quantity",
"type": "DoubleType"
},
{
"col_no": 5,
"name": "l_extended_price",
"type": "DoubleType"
},
{
"col_no": 6,
"name": "l_discount",
"type": "DoubleType"
},
{
"col_no": 7,
"name": "l_tax",
"type": "DoubleType"
},
{
"col_no": 8,
"name": "l_return_flag",
"type": "StringType"
},
{
"col_no": 9,
"name": "l_line_status",
"type": "StringType"
},
{
"col_no": 10,
"name": "l_ship_date",
"type": "DateType"
},
{
"col_no": 11,
"name": "l_commit_date",
"type": "DateType"
},
{
"col_no": 12,
"name": "l_receipt_date",
"type": "DateType"
},
{
"col_no": 13,
"name": "l_ship_instruct",
"type": "StringType"
},
{
"col_no": 14,
"name": "l_ship_mode",
"type": "StringType"
},
{
"col_no": 15,
"name": "l_comment",
"type": "StringType"
}
],
"name": "lineitem",
"num_indexlets": 1
},
{
"fields": [
{
"col_no": 0,
"name": "n_nation_key",
"type": "Int32Type"
},
{
"col_no": 1,
"name": "n_name",
"type": "StringType"
},
{
"col_no": 2,
"name": "n_region_key",
"type": "Int32Type"
},
{
"col_no": 3,
"name": "n_comment",
"type": "StringType"
}
],
"name": "nation",
"num_indexlets": 1
},
{
"fields": [
{
"col_no": 0,
"name": "o_order_key",
"type": "Int32Type"
},
{
"col_no": 1,
"name": "o_cust_key",
"type": "Int32Type"
},
{
"col_no": 2,
"name": "o_order_status",
"type": "StringType"
},
{
"col_no": 3,
"name": "o_total_price",
"type": "DoubleType"
},
{
"col_no": 4,
"name": "o_order_date",
"type": "DateType"
},
{
"col_no": 5,
"name": "o_order_priority",
"type": "StringType"
},
{
"col_no": 6,
"name": "o_clerk",
"type": "StringType"
},
{
"col_no": 7,
"name": "o_ship_priority",
"type": "Int32Type"
},
{
"col_no": 8,
"name": "o_comment",
"type": "StringType"
}
],
"name": "order",
"num_indexlets": 1
},
{
"fields": [
{
"col_no": 0,
"name": "p_part_key",
"type": "Int32Type"
},
{
"col_no": 1,
"name": "p_name",
"type": "StringType"
},
{
"col_no": 2,
"name": "p_mfgr",
"type": "StringType"
},
{
"col_no": 3,
"name": "p_brand",
"type": "StringType"
},
{
"col_no": 4,
"name": "p_type",
"type": "StringType"
},
{
"col_no": 5,
"name": "p_size",
"type": "Int32Type"
},
{
"col_no": 6,
"name": "p_container",
"type": "StringType"
},
{
"col_no": 7,
"name": "p_retail_price",
"type": "DoubleType"
},
{
"col_no": 8,
"name": "p_comment",
"type": "StringType"
}
],
"name": "part",
"num_indexlets": 1
},
{
"fields": [
{
"col_no": 0,
"name": "ps_part_key",
"type": "Int32Type"
},
{
"col_no": 1,
"name": "ps_supp_key",
"type": "Int32Type"
},
{
"col_no": 2,
"name": "ps_avail_qty",
"type": "Int32Type"
},
{
"col_no": 3,
"name": "ps_supply_cost",
"type": "DoubleType"
},
{
"col_no": 4,
"name": "ps_comment",
"type": "StringType"
}
],
"name": "partsupp",
"num_indexlets": 1
},
{
"fields": [
{
"col_no": 0,
"name": "r_region_key",
"type": "Int32Type"
},
{
"col_no": 1,
"name": "r_name",
"type": "StringType"
},
{
"col_no": 2,
"name": "r_comment",
"type": "StringType"
}
],
"name": "region",
"num_indexlets": 1
},
{
"fields": [
{
"col_no": 0,
"name": "s_supp_key",
"type": "Int32Type"
},
{
"col_no": 1,
"name": "s_name",
"type": "StringType"
},
{
"col_no": 2,
"name": "s_address",
"type": "StringType"
},
{
"col_no": 3,
"name": "s_nation_key",
"type": "Int32Type"
},
{
"col_no": 4,
"name": "s_phone",
"type": "StringType"
},
{
"col_no": 5,
"name": "s_acctbal",
"type": "DoubleType"
},
{
"col_no": 6,
"name": "s_comment",
"type": "StringType"
}
],
"name": "supplier",
"num_indexlets": 1
}
]
}