You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
 
 
 
 
 
 
nsc_ba_public/tpch/03_ddl/ignite/16.ignite.supplier.sql

10 lines
248 B

CREATE TABLE tpch.SUPPLIER
(S_SUPPKEY INT PRIMARY KEY,
S_NAME CHAR(25),
S_ADDRESS VARCHAR(40),
S_NATIONKEY INTEGER,
S_PHONE CHAR(15),
S_ACCTBAL DECIMAL(15,2),
S_COMMENT VARCHAR(101),
dummy text) WITH "template=replicated,affinity_key=S_SUPPKEY";