| tables: | |
| - name: customer | |
| type: source-table | |
| update-mode: append | |
| connector: | |
| type: filesystem | |
| path: "$TABLE_DIR/customer.csv" | |
| format: | |
| type: csv | |
| fields: | |
| - name: c_custkey | |
| type: BIGINT | |
| - name: c_name | |
| type: VARCHAR | |
| - name: c_address | |
| type: VARCHAR | |
| - name: c_nationkey | |
| type: BIGINT | |
| - name: c_phone | |
| type: VARCHAR | |
| - name: c_acctbal | |
| type: DOUBLE | |
| - name: c_mktsegment | |
| type: VARCHAR | |
| - name: c_comment | |
| type: VARCHAR | |
| field-delimiter: "|" | |
| line-delimiter: "\n" | |
| comment-prefix: "--" | |
| schema: | |
| - name: c_custkey | |
| type: BIGINT | |
| - name: c_name | |
| type: VARCHAR | |
| - name: c_address | |
| type: VARCHAR | |
| - name: c_nationkey | |
| type: BIGINT | |
| - name: c_phone | |
| type: VARCHAR | |
| - name: c_acctbal | |
| type: DOUBLE | |
| - name: c_mktsegment | |
| type: VARCHAR | |
| - name: c_comment | |
| type: VARCHAR | |
| - name: lineitem | |
| type: source-table | |
| update-mode: append | |
| connector: | |
| type: filesystem | |
| path: "$TABLE_DIR/lineitem.csv" | |
| format: | |
| type: csv | |
| fields: | |
| - name: l_orderkey | |
| type: BIGINT | |
| - name: l_partkey | |
| type: BIGINT | |
| - name: l_suppkey | |
| type: BIGINT | |
| - name: l_linenumber | |
| type: INT | |
| - name: l_quantity | |
| type: DOUBLE | |
| - name: l_extendedprice | |
| type: DOUBLE | |
| - name: l_discount | |
| type: DOUBLE | |
| - name: l_tax | |
| type: DOUBLE | |
| - name: l_returnflag | |
| type: VARCHAR | |
| - name: l_linestatus | |
| type: VARCHAR | |
| - name: l_shipdate | |
| type: DATE | |
| - name: l_commitdate | |
| type: DATE | |
| - name: l_receiptdate | |
| type: DATE | |
| - name: l_shipinstruct | |
| type: VARCHAR | |
| - name: l_shipmode | |
| type: VARCHAR | |
| - name: l_comment | |
| type: VARCHAR | |
| field-delimiter: "|" | |
| line-delimiter: "\n" | |
| comment-prefix: "--" | |
| schema: | |
| - name: l_orderkey | |
| type: BIGINT | |
| - name: l_partkey | |
| type: BIGINT | |
| - name: l_suppkey | |
| type: BIGINT | |
| - name: l_linenumber | |
| type: INT | |
| - name: l_quantity | |
| type: DOUBLE | |
| - name: l_extendedprice | |
| type: DOUBLE | |
| - name: l_discount | |
| type: DOUBLE | |
| - name: l_tax | |
| type: DOUBLE | |
| - name: l_returnflag | |
| type: VARCHAR | |
| - name: l_linestatus | |
| type: VARCHAR | |
| - name: l_shipdate | |
| type: DATE | |
| - name: l_commitdate | |
| type: DATE | |
| - name: l_receiptdate | |
| type: DATE | |
| - name: l_shipinstruct | |
| type: VARCHAR | |
| - name: l_shipmode | |
| type: VARCHAR | |
| - name: l_comment | |
| type: VARCHAR | |
| - name: nation | |
| type: source-table | |
| update-mode: append | |
| connector: | |
| type: filesystem | |
| path: "$TABLE_DIR/nation.csv" | |
| format: | |
| type: csv | |
| fields: | |
| - name: n_nationkey | |
| type: BIGINT | |
| - name: n_name | |
| type: VARCHAR | |
| - name: n_regionkey | |
| type: BIGINT | |
| - name: n_comment | |
| type: VARCHAR | |
| field-delimiter: "|" | |
| line-delimiter: "\n" | |
| comment-prefix: "--" | |
| schema: | |
| - name: n_nationkey | |
| type: BIGINT | |
| - name: n_name | |
| type: VARCHAR | |
| - name: n_regionkey | |
| type: BIGINT | |
| - name: n_comment | |
| type: VARCHAR | |
| - name: orders | |
| type: source-table | |
| update-mode: append | |
| connector: | |
| type: filesystem | |
| path: "$TABLE_DIR/orders.csv" | |
| format: | |
| type: csv | |
| fields: | |
| - name: o_orderkey | |
| type: BIGINT | |
| - name: o_custkey | |
| type: BIGINT | |
| - name: o_orderstatus | |
| type: VARCHAR | |
| - name: o_totalprice | |
| type: DOUBLE | |
| - name: o_orderdate | |
| type: DATE | |
| - name: o_orderpriority | |
| type: VARCHAR | |
| - name: o_clerk | |
| type: VARCHAR | |
| - name: o_shippriority | |
| type: INT | |
| - name: o_comment | |
| type: VARCHAR | |
| field-delimiter: "|" | |
| line-delimiter: "\n" | |
| comment-prefix: "--" | |
| schema: | |
| - name: o_orderkey | |
| type: BIGINT | |
| - name: o_custkey | |
| type: BIGINT | |
| - name: o_orderstatus | |
| type: VARCHAR | |
| - name: o_totalprice | |
| type: DOUBLE | |
| - name: o_orderdate | |
| type: DATE | |
| - name: o_orderpriority | |
| type: VARCHAR | |
| - name: o_clerk | |
| type: VARCHAR | |
| - name: o_shippriority | |
| type: INT | |
| - name: o_comment | |
| type: VARCHAR | |
| - name: part | |
| type: source-table | |
| update-mode: append | |
| connector: | |
| type: filesystem | |
| path: "$TABLE_DIR/part.csv" | |
| format: | |
| type: csv | |
| fields: | |
| - name: p_partkey | |
| type: BIGINT | |
| - name: p_name | |
| type: VARCHAR | |
| - name: p_mfgr | |
| type: VARCHAR | |
| - name: p_brand | |
| type: VARCHAR | |
| - name: p_type | |
| type: VARCHAR | |
| - name: p_size | |
| type: INT | |
| - name: p_container | |
| type: VARCHAR | |
| - name: p_retailprice | |
| type: DOUBLE | |
| - name: p_comment | |
| type: VARCHAR | |
| field-delimiter: "|" | |
| line-delimiter: "\n" | |
| comment-prefix: "--" | |
| schema: | |
| - name: p_partkey | |
| type: BIGINT | |
| - name: p_name | |
| type: VARCHAR | |
| - name: p_mfgr | |
| type: VARCHAR | |
| - name: p_brand | |
| type: VARCHAR | |
| - name: p_type | |
| type: VARCHAR | |
| - name: p_size | |
| type: INT | |
| - name: p_container | |
| type: VARCHAR | |
| - name: p_retailprice | |
| type: DOUBLE | |
| - name: p_comment | |
| type: VARCHAR | |
| - name: partsupp | |
| type: source-table | |
| update-mode: append | |
| connector: | |
| type: filesystem | |
| path: "$TABLE_DIR/partsupp.csv" | |
| format: | |
| type: csv | |
| fields: | |
| - name: ps_partkey | |
| type: BIGINT | |
| - name: ps_suppkey | |
| type: BIGINT | |
| - name: ps_availqty | |
| type: INT | |
| - name: ps_supplycost | |
| type: DOUBLE | |
| - name: ps_comment | |
| type: VARCHAR | |
| field-delimiter: "|" | |
| line-delimiter: "\n" | |
| comment-prefix: "--" | |
| schema: | |
| - name: ps_partkey | |
| type: BIGINT | |
| - name: ps_suppkey | |
| type: BIGINT | |
| - name: ps_availqty | |
| type: INT | |
| - name: ps_supplycost | |
| type: DOUBLE | |
| - name: ps_comment | |
| type: VARCHAR | |
| - name: region | |
| type: source-table | |
| update-mode: append | |
| connector: | |
| type: filesystem | |
| path: "$TABLE_DIR/region.csv" | |
| format: | |
| type: csv | |
| fields: | |
| - name: r_regionkey | |
| type: BIGINT | |
| - name: r_name | |
| type: VARCHAR | |
| - name: r_comment | |
| type: VARCHAR | |
| field-delimiter: "|" | |
| line-delimiter: "\n" | |
| comment-prefix: "--" | |
| schema: | |
| - name: r_regionkey | |
| type: BIGINT | |
| - name: r_name | |
| type: VARCHAR | |
| - name: r_comment | |
| type: VARCHAR | |
| - name: supplier | |
| type: source-table | |
| update-mode: append | |
| connector: | |
| type: filesystem | |
| path: "$TABLE_DIR/supplier.csv" | |
| format: | |
| type: csv | |
| fields: | |
| - name: s_suppkey | |
| type: BIGINT | |
| - name: s_name | |
| type: VARCHAR | |
| - name: s_address | |
| type: VARCHAR | |
| - name: s_nationkey | |
| type: BIGINT | |
| - name: s_phone | |
| type: VARCHAR | |
| - name: s_acctbal | |
| type: DOUBLE | |
| - name: s_comment | |
| type: VARCHAR | |
| field-delimiter: "|" | |
| line-delimiter: "\n" | |
| comment-prefix: "--" | |
| schema: | |
| - name: s_suppkey | |
| type: BIGINT | |
| - name: s_name | |
| type: VARCHAR | |
| - name: s_address | |
| type: VARCHAR | |
| - name: s_nationkey | |
| type: BIGINT | |
| - name: s_phone | |
| type: VARCHAR | |
| - name: s_acctbal | |
| type: DOUBLE | |
| - name: s_comment | |
| type: VARCHAR |