benchmarks/sql_benchmarks/tpch/init/load_csv.sql

CREATE EXTERNAL TABLE nation
(
    n_nationkey INT,
    n_name      CHAR(25),
    n_regionkey INT,
    n_comment   VARCHAR(152),
    PRIMARY KEY (n_nationkey)
) STORED AS CSV LOCATION '${DATA_DIR:-data}/tpch_sf${BENCH_SIZE:-1}/csv/nation/nation.1.csv';

CREATE EXTERNAL TABLE region
(
    r_regionkey INT,
    r_name      CHAR(25),
    r_comment   VARCHAR(152),
    PRIMARY KEY (r_regionkey)
) STORED AS CSV LOCATION '${DATA_DIR:-data}/tpch_sf${BENCH_SIZE:-1}/csv/region/region.1.csv';

CREATE EXTERNAL TABLE supplier
(
    s_suppkey   INT,
    s_name      CHAR(25),
    s_address   VARCHAR(40),
    s_nationkey INT,
    s_phone     CHAR(15),
    s_acctbal   DECIMAL(15, 2),
    s_comment   VARCHAR(101),
    PRIMARY KEY (s_suppkey)
) STORED AS CSV LOCATION '${DATA_DIR:-data}/tpch_sf${BENCH_SIZE:-1}/csv/supplier/supplier.1.csv';

CREATE EXTERNAL TABLE customer
(
    c_custkey    INT,
    c_name       VARCHAR(25),
    c_address    VARCHAR(40),
    c_nationkey  INT,
    c_phone      CHAR(15),
    c_acctbal    DECIMAL(15, 2),
    c_mktsegment CHAR(10),
    c_comment    VARCHAR(117),
    PRIMARY KEY (c_custkey)
) STORED AS CSV LOCATION '${DATA_DIR:-data}/tpch_sf${BENCH_SIZE:-1}/csv/customer/customer.1.csv';

CREATE EXTERNAL TABLE part
(
    p_partkey     INT,
    p_name        VARCHAR(55),
    p_mfgr        CHAR(25),
    p_brand       CHAR(10),
    p_type        VARCHAR(25),
    p_size        INT,
    p_container   CHAR(10),
    p_retailprice DECIMAL(15, 2),
    p_comment     VARCHAR(23),
    PRIMARY KEY (p_partkey)
) STORED AS CSV LOCATION '${DATA_DIR:-data}/tpch_sf${BENCH_SIZE:-1}/csv/part/part.1.csv';

CREATE EXTERNAL TABLE partsupp
(
    ps_partkey    INT,
    ps_suppkey    INT,
    ps_availqty   INT,
    ps_supplycost DECIMAL(15, 2),
    ps_comment    VARCHAR(199),
    PRIMARY KEY (ps_partkey)
) STORED AS CSV LOCATION '${DATA_DIR:-data}/tpch_sf${BENCH_SIZE:-1}/csv/partsupp/partsupp.1.csv';

CREATE EXTERNAL TABLE orders
(
    o_orderkey      INT,
    o_custkey       INT,
    o_orderstatus   CHAR(1),
    o_totalprice    DECIMAL(15, 2),
    o_orderdate     DATE,
    o_orderpriority CHAR(15),
    o_clerk         CHAR(15),
    o_shippriority  INT,
    o_comment       VARCHAR(79),
    PRIMARY KEY (o_orderkey)
) STORED AS CSV LOCATION '${DATA_DIR:-data}/tpch_sf${BENCH_SIZE:-1}/csv/orders/orders.1.csv';

CREATE EXTERNAL TABLE lineitem
(
    l_orderkey      INT,
    l_partkey       INT,
    l_suppkey       INT,
    l_linenumber    INT,
    l_quantity      DECIMAL(15, 2),
    l_extendedprice DECIMAL(15, 2),
    l_discount      DECIMAL(15, 2),
    l_tax           DECIMAL(15, 2),
    l_returnflag    CHAR(1),
    l_linestatus    CHAR(1),
    l_shipdate      DATE,
    l_commitdate    DATE,
    l_receiptdate   DATE,
    l_shipinstruct  CHAR(25),
    l_shipmode      CHAR(10),
    l_comment       VARCHAR(44)
) STORED AS CSV LOCATION '${DATA_DIR:-data}/tpch_sf${BENCH_SIZE:-1}/csv/lineitem/lineitem.1.csv';