1+ -- Schema derived from TPC-H schema under the terms of the TPC Fair Use Policy.
2+ -- TPC-H queries are Copyright 1993-2022 Transaction Processing Performance Council.
3+
4+ CREATE EXTERNAL TABLE customer (
5+ c_custkey INT NOT NULL ,
6+ c_name VARCHAR NOT NULL ,
7+ c_address VARCHAR NOT NULL ,
8+ c_nationkey INT NOT NULL ,
9+ c_phone VARCHAR NOT NULL ,
10+ c_acctbal DECIMAL (15 , 2 ) NOT NULL ,
11+ c_mktsegment VARCHAR NOT NULL ,
12+ c_comment VARCHAR NOT NULL ,
13+ c_extra VARCHAR NOT NULL ,
14+ )
15+ STORED AS CSV
16+ WITH HEADER ROW DELIMITER ' |'
17+ LOCATION ' $PATH/customer.csv' ;
18+
19+ CREATE EXTERNAL TABLE lineitem (
20+ l_orderkey INT NOT NULL ,
21+ l_partkey INT NOT NULL ,
22+ l_suppkey INT NOT NULL ,
23+ l_linenumber INT NOT NULL ,
24+ l_quantity DECIMAL (15 , 2 ) NOT NULL ,
25+ l_extendedprice DECIMAL (15 , 2 ) NOT NULL ,
26+ l_discount DECIMAL (15 , 2 ) NOT NULL ,
27+ l_tax DECIMAL (15 , 2 ) NOT NULL ,
28+ l_returnflag VARCHAR NOT NULL ,
29+ l_linestatus VARCHAR NOT NULL ,
30+ l_shipdate DATE NOT NULL ,
31+ l_commitdate DATE NOT NULL ,
32+ l_receiptdate DATE NOT NULL ,
33+ l_shipinstruct VARCHAR NOT NULL ,
34+ l_shipmode VARCHAR NOT NULL ,
35+ l_comment VARCHAR NOT NULL ,
36+ l_extra VARCHAR NOT NULL ,
37+ )
38+ STORED AS CSV
39+ WITH HEADER ROW DELIMITER ' |'
40+ LOCATION ' $PATH/lineitem.csv' ;
41+
42+ CREATE EXTERNAL TABLE nation (
43+ n_nationkey INT NOT NULL ,
44+ n_name VARCHAR NOT NULL ,
45+ n_regionkey INT NOT NULL ,
46+ n_comment VARCHAR NOT NULL ,
47+ n_extra VARCHAR NOT NULL ,
48+ )
49+ STORED AS CSV
50+ WITH HEADER ROW DELIMITER ' |'
51+ LOCATION ' $PATH/nation.csv' ;
52+
53+ CREATE EXTERNAL TABLE orders (
54+ o_orderkey INT NOT NULL ,
55+ o_custkey INT NOT NULL ,
56+ o_orderstatus VARCHAR NOT NULL ,
57+ o_totalprice DECIMAL (15 , 2 ) NOT NULL ,
58+ o_orderdate DATE NOT NULL ,
59+ o_orderpriority VARCHAR NOT NULL ,
60+ o_clerk VARCHAR NOT NULL ,
61+ o_shippriority INT NULL ,
62+ o_comment VARCHAR NOT NULL ,
63+ o_extra VARCHAR NOT NULL ,
64+ )
65+ STORED AS CSV
66+ WITH HEADER ROW DELIMITER ' |'
67+ LOCATION ' $PATH/orders.csv' ;
68+
69+ CREATE EXTERNAL TABLE part (
70+ p_partkey INT NOT NULL ,
71+ p_name VARCHAR NOT NULL ,
72+ p_mfgr VARCHAR NOT NULL ,
73+ p_brand VARCHAR NOT NULL ,
74+ p_type VARCHAR NOT NULL ,
75+ p_size INT NULL ,
76+ p_container VARCHAR NOT NULL ,
77+ p_retailprice DECIMAL (15 , 2 ) NOT NULL ,
78+ p_comment VARCHAR NOT NULL ,
79+ p_extra VARCHAR NOT NULL ,
80+ )
81+ STORED AS CSV
82+ WITH HEADER ROW DELIMITER ' |'
83+ LOCATION ' $PATH/part.csv' ;
84+
85+ CREATE EXTERNAL TABLE partsupp (
86+ ps_partkey INT NOT NULL ,
87+ ps_suppkey INT NOT NULL ,
88+ ps_availqty INT NOT NULL ,
89+ ps_supplycost DECIMAL (15 , 2 ) NOT NULL ,
90+ ps_comment VARCHAR NOT NULL ,
91+ ps_extra VARCHAR NOT NULL ,
92+ )
93+ STORED AS CSV
94+ WITH HEADER ROW DELIMITER ' |'
95+ LOCATION ' $PATH/partsupp.csv' ;
96+
97+ CREATE EXTERNAL TABLE region (
98+ r_regionkey INT NOT NULL ,
99+ r_name VARCHAR NOT NULL ,
100+ r_comment VARCHAR NOT NULL ,
101+ r_extra VARCHAR NOT NULL ,
102+ )
103+ STORED AS CSV
104+ WITH HEADER ROW DELIMITER ' |'
105+ LOCATION ' $PATH/region.csv' ;
106+
107+ CREATE EXTERNAL TABLE supplier (
108+ s_suppkey INT NOT NULL ,
109+ s_name VARCHAR NOT NULL ,
110+ s_address VARCHAR NOT NULL ,
111+ s_nationkey INT NOT NULL ,
112+ s_phone VARCHAR NOT NULL ,
113+ s_acctbal DECIMAL (15 , 2 ) NOT NULL ,
114+ s_comment VARCHAR NOT NULL ,
115+ s_extra VARCHAR NOT NULL ,
116+ )
117+ STORED AS CSV
118+ WITH HEADER ROW DELIMITER ' |'
119+ LOCATION ' $PATH/supplier.csv' ;
0 commit comments