tpch.create_tables.sql Maven / Gradle / Ivy

Go to download
create table nation (
	N_NATIONKEY INT,
	N_NAME STRING,
	N_REGIONKEY INT,
	N_COMMENT STRING,
    primary key(N_NATIONKEY)
);

create table lineitem (
	L_ORDERKEY INT,
	L_PARTKEY INT,
	L_SUPPKEY INT,
	L_LINENUMBER INT,
	L_QUANTITY DOUBLE,
	L_EXTENDEDPRICE DOUBLE,
	L_DISCOUNT DOUBLE,
	L_TAX DOUBLE,
	L_RETURNFLAG STRING,
	L_LINESTATUS STRING,
	L_SHIPDATE STRING,
	L_COMMITDATE STRING,
	L_RECEIPTDATE STRING,
	L_SHIPINSTRUCT STRING,
	L_SHIPMODE STRING,
	L_COMMENT STRING,
    primary key(L_ORDERKEY, L_PARTKEY, L_SUPPKEY, L_LINENUMBER)
);

create table orders (
	O_ORDERKEY INT,
	O_CUSTKEY INT,
	O_ORDERSTATUS STRING,
	O_TOTALPRICE DOUBLE,
	O_ORDERDATE STRING,
	O_ORDERPRIORITY STRING,
	O_CLERK STRING,
	O_SHIPPRIORITY INT,
	O_COMMENT STRING,
    primary key(O_ORDERKEY)
);

create table supplier(
	S_SUPPKEY INT,
	S_NAME STRING,
	S_ADDRESS STRING,
	S_NATIONKEY INT,
	S_PHONE STRING,
	S_ACCTBAL DOUBLE,
	S_COMMENT STRING,
    primary key(S_SUPPKEY)
);

create table partsupp (
	PS_PARTKEY INT,
	PS_SUPPKEY INT,
	PS_AVAILQTY INT,
	PS_SUPPLYCOST DOUBLE,
	PS_COMMENT STRING,
    primary key(PS_PARTKEY,PS_SUPPKEY)
);

create table customer (
	C_CUSTKEY INT,
	C_NAME STRING,
	C_ADDRESS STRING,
	C_NATIONKEY INT,
	C_PHONE STRING,
	C_ACCTBAL DOUBLE,
	C_MKTSEGMENT STRING,
	C_COMMENT STRING,
    primary key(C_CUSTKEY)
);

create table part (
	P_PARTKEY INT,
	P_NAME STRING,
	P_MFGR STRING,
	P_BRAND STRING,
	P_TYPE STRING,
	P_SIZE INT,
	P_CONTAINER STRING,
	P_RETAILPRICE DOUBLE,
	P_COMMENT STRING,
    primary key(P_PARTKEY)
);

create table region (
	R_REGIONKEY INT,
	R_NAME STRING,
	R_COMMENT STRING,
     primary key(R_REGIONKEY)
);