151 lines
2.4 KiB
Plaintext
151 lines
2.4 KiB
Plaintext
CREATE TRIO TABLE PARTSUPP_SF1_V_0 (
|
|
ID int,
|
|
PARTKEY int
|
|
) with confidences;
|
|
|
|
CREATE TRIO TABLE PARTSUPP_SF1_V_1 (
|
|
ID int,
|
|
SUPPKEY int
|
|
) with confidences;
|
|
|
|
CREATE TRIO TABLE PARTSUPP_SF1_V_2 (
|
|
ID int,
|
|
AVAILQTY int
|
|
) with confidences;
|
|
|
|
CREATE TRIO TABLE PARTSUPP_SF1_V_3 (
|
|
ID int,
|
|
SUPPLYCOST float
|
|
) with confidences;
|
|
|
|
CREATE TRIO TABLE PARTSUPP_SF1_V_4 (
|
|
ID int,
|
|
COMMENT varchar(200)
|
|
) with confidences;
|
|
|
|
CREATE TRIO TABLE LINEITEM_SF1_V_0 (
|
|
ID int,
|
|
ORDERKEY int
|
|
) with confidences;
|
|
|
|
CREATE TRIO TABLE LINEITEM_SF1_V_1 (
|
|
ID int,
|
|
PARTKEY int
|
|
) with confidences;
|
|
|
|
CREATE TRIO TABLE LINEITEM_SF1_V_2 (
|
|
ID int,
|
|
SUPPKEY int
|
|
) with confidences;
|
|
|
|
CREATE TRIO TABLE LINEITEM_SF1_V_3 (
|
|
ID int,
|
|
LINENUMBER int
|
|
) with confidences;
|
|
|
|
CREATE TRIO TABLE LINEITEM_SF1_V_4 (
|
|
ID int,
|
|
QUANTITY float
|
|
) with confidences;
|
|
|
|
CREATE TRIO TABLE LINEITEM_SF1_V_5 (
|
|
ID int,
|
|
EXTENDEDPRICE float
|
|
) with confidences;
|
|
|
|
CREATE TRIO TABLE LINEITEM_SF1_V_6 (
|
|
ID int,
|
|
DISCOUNT float
|
|
) with confidences;
|
|
|
|
CREATE TRIO TABLE LINEITEM_SF1_V_7 (
|
|
ID int,
|
|
TAX float
|
|
) with confidences;
|
|
|
|
CREATE TRIO TABLE LINEITEM_SF1_V_8 (
|
|
ID int,
|
|
RETURNFLAG varchar(1)
|
|
) with confidences;
|
|
|
|
CREATE TRIO TABLE LINEITEM_SF1_V_9 (
|
|
ID int,
|
|
STATUS varchar(1)
|
|
) with confidences;
|
|
|
|
CREATE TRIO TABLE LINEITEM_SF1_V_10 (
|
|
ID int,
|
|
SHIPDATE varchar(10)
|
|
) with confidences;
|
|
|
|
CREATE TRIO TABLE LINEITEM_SF1_V_11 (
|
|
ID int,
|
|
COMMITDATE varchar(10)
|
|
) with confidences;
|
|
|
|
CREATE TRIO TABLE LINEITEM_SF1_V_12 (
|
|
ID int,
|
|
RECEIPTDATE varchar(10)
|
|
) with confidences;
|
|
|
|
CREATE TRIO TABLE LINEITEM_SF1_V_13 (
|
|
ID int,
|
|
SHIPINSTRUCT varchar(25)
|
|
) with confidences;
|
|
|
|
CREATE TRIO TABLE LINEITEM_SF1_V_14 (
|
|
ID int,
|
|
SHIPMODE varchar(10)
|
|
) with confidences;
|
|
|
|
CREATE TRIO TABLE LINEITEM_SF1_V_15 (
|
|
ID int,
|
|
COMMENT varchar(44)
|
|
) with confidences;
|
|
|
|
CREATE TRIO TABLE ORDER_SF1_V_0 (
|
|
ID int,
|
|
ORDERKEY int
|
|
) with confidences;
|
|
|
|
CREATE TRIO TABLE ORDER_SF1_V_1 (
|
|
ID int,
|
|
CUSTKEY int
|
|
) with confidences;
|
|
|
|
CREATE TRIO TABLE ORDER_SF1_V_2 (
|
|
ID int,
|
|
ORDERSTATUS varchar(1)
|
|
) with confidences;
|
|
|
|
CREATE TRIO TABLE ORDER_SF1_V_3 (
|
|
ID int,
|
|
TOTALPRICE float
|
|
) with confidences;
|
|
|
|
CREATE TRIO TABLE ORDER_SF1_V_4 (
|
|
ID int,
|
|
ORDERDATE varchar(10)
|
|
) with confidences;
|
|
|
|
CREATE TRIO TABLE ORDER_SF1_V_5 (
|
|
ID int,
|
|
ORDERPRIORITY varchar(15)
|
|
) with confidences;
|
|
|
|
CREATE TRIO TABLE ORDER_SF1_V_6 (
|
|
ID int,
|
|
CLERK varchar(15)
|
|
) with confidences;
|
|
|
|
CREATE TRIO TABLE ORDER_SF1_V_7 (
|
|
ID int,
|
|
SHIPPRIORITY int
|
|
) with confidences;
|
|
|
|
CREATE TRIO TABLE ORDER_SF1_V_8 (
|
|
ID int,
|
|
COMMENT varchar(79)
|
|
) with confidences;
|
|
|