Re: Presto+CarbonData optimization work discussion

Posted by bhavya411 on
URL: http://apache-carbondata-dev-mailing-list-archive.168.s1.nabble.com/Presto-CarbonData-optimization-work-discussion-tp18509p18897.html

Please find the queries below , yes we are using default 1024 GB as block size

 CREATE TABLE NATION ( N_NATIONKEY INT, N_NAME STRING, N_REGIONKEY INT, N_COMMENT STRING ) STORED BY 'carbondata';

CREATE TABLE REGION ( R_REGIONKEY INT , R_NAME STRING , R_COMMENT STRING) STORED BY 'carbondata';

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 DECIMAL(15,2) ,P_COMMENT STRING ) STORED BY 'carbondata';

CREATE TABLE SUPPLIER ( S_SUPPKEY INT ,S_NAME STRING ,S_ADDRESS STRING ,S_NATIONKEY INT ,S_PHONE STRING , S_ACCTBAL DECIMAL(15,2) , S_COMMENT STRING ) STORED BY 'carbondata';

CREATE TABLE PARTSUPP ( PS_PARTKEY INT ,PS_SUPPKEY INT ,PS_AVAILQTY INT , PS_SUPPLYCOST DECIMAL(15,2) ,PS_COMMENT STRING ) STORED BY 'carbondata';


CREATE TABLE CUSTOMER (C_CUSTKEY INT ,C_NAME STRING ,C_ADDRESS STRING ,C_NATIONKEY INT ,C_PHONE STRING ,C_ACCTBAL DECIMAL(15,2) ,C_MKTSEGMENT STRING ,C_COMMENT STRING) STORED BY 'carbondata';

CREATE TABLE ORDERS ( O_ORDERKEY INT ,O_CUSTKEY INT ,O_ORDERSTATUS STRING ,O_TOTALPRICE DECIMAL(15,2) ,O_ORDERDATE DATE ,O_ORDERPRIORITY STRING,O_CLERK STRING ,O_SHIPPRIORITY INT ,O_COMMENT STRING ) STORED BY 'carbondata';

CREATE 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 STRING ,L_LINESTATUS STRING ,L_SHIPDATE DATE ,L_COMMITDATE DATE ,L_RECEIPTDATE DATE ,L_SHIPINSTRUCT STRING ,L_SHIPMODE STRING ,L_COMMENT STRING ) STORED BY 'carbondata';