-
Notifications
You must be signed in to change notification settings - Fork 4
/
Copy pathQ3_create_benchmark.sql
7 lines (7 loc) · 2.27 KB
/
Q3_create_benchmark.sql
1
2
3
4
5
6
7
CREATE TABLE IF NOT EXISTS feedback(Q3_Col31 string, Q3_Col32 timestamp, Q3_Col0 timestamp, Q3_Col58 double, index(key=(Q3_Col31), ttl=0m, ttl_type=absolute)) OPTIONS(replicanum=1) ;
CREATE TABLE IF NOT EXISTS train(Q3_Col31 string, Q3_Col3 string, Q3_Col32 timestamp, Q3_Col33 timestamp, Q3_Col6 string, Q3_Col34 string, index(key=(Q3_Col3), ttl=0m, ttl_type=absolute, ts=`Q3_Col32`)) OPTIONS(replicanum=1) ;
CREATE TABLE IF NOT EXISTS order_cancel_return(Q3_Col0 timestamp, Q3_Col1 timestamp, Q3_Col2 string, Q3_Col3 string, Q3_Col4 int, Q3_Col5 string, index(key=(Q3_Col3), ttl=0m, ttl_type=absolute, ts=`Q3_Col0`)) OPTIONS(replicanum=1) ;
CREATE TABLE IF NOT EXISTS order_sales(Q3_Col0 timestamp, Q3_Col35 string, Q3_Col36 string, Q3_Col37 string, Q3_Col38 string, Q3_Col39 string, Q3_Col40 string, Q3_Col41 string, Q3_Col42 string, Q3_Col2 string, Q3_Col43 string, Q3_Col44 string, Q3_Col45 string, Q3_Col46 timestamp, Q3_Col4 bigInt, Q3_Col47 double, Q3_Col48 double, Q3_Col3 string, Q3_Col49 string, Q3_Col50 string, Q3_Col6 string, Q3_Col51 string, Q3_Col52 string, Q3_Col53 double, Q3_Col54 double, Q3_Col55 double, Q3_Col56 double, Q3_Col57 string, index(key=(Q3_Col3), ttl=0m, ttl_type=absolute, ts=`Q3_Col0`)) OPTIONS(replicanum=1) ;
CREATE TABLE IF NOT EXISTS product_item(Q3_Col0 timestamp, Q3_Col6 string, Q3_Col7 string, Q3_Col8 string, Q3_Col9 string, Q3_Col10 string, Q3_Col11 string, Q3_Col12 string, Q3_Col13 string, Q3_Col14 string, Q3_Col15 string, Q3_Col16 string, Q3_Col17 string, Q3_Col18 string, Q3_Col19 string, Q3_Col20 string, Q3_Col21 string, Q3_Col22 string, Q3_Col23 string, Q3_Col24 string, Q3_Col25 string, Q3_Col26 string, Q3_Col27 string, Q3_Col28 timestamp, Q3_Col29 timestamp, Q3_Col30 timestamp, index(key=(Q3_Col6), ttl=0m, ttl_type=absolute, ts=`Q3_Col0`)) OPTIONS(replicanum=1) ;
CREATE TABLE IF NOT EXISTS product_sku(Q3_Col0 timestamp, Q3_Col3 string, Q3_Col59 string, Q3_Col60 string, Q3_Col61 string, Q3_Col62 string, Q3_Col63 string, Q3_Col64 string, Q3_Col65 string, index(key=(Q3_Col3), ttl=0m, ttl_type=absolute)) OPTIONS(replicanum=1) ;
CREATE TABLE IF NOT EXISTS shipping_sku(Q3_Col0 timestamp, Q3_Col3 string, Q3_Col54 double, Q3_Col66 timestamp, Q3_Col67 timestamp, Q3_Col68 timestamp, index(key=(Q3_Col3), ttl=0m, ttl_type=absolute, ts=`Q3_Col0`)) OPTIONS(replicanum=1) ;