[12/50] [abbrv] kylin git commit: KYLIN-2076 Improve sample cube and data

2016-10-18 Thread lidong 
KYLIN-2076 Improve sample cube and data

Signed-off-by: Li Yang 


Project: http://git-wip-us.apache.org/repos/asf/kylin/repo
Commit: http://git-wip-us.apache.org/repos/asf/kylin/commit/0c7e2688
Tree: http://git-wip-us.apache.org/repos/asf/kylin/tree/0c7e2688
Diff: http://git-wip-us.apache.org/repos/asf/kylin/diff/0c7e2688

Branch: refs/heads/master-cdh5.7
Commit: 0c7e2688e80822cfbdad901cef909884bfa79ee8
Parents: 726b0ec
Author: Cheng Wang 
Authored: Mon Oct 10 17:49:33 2016 +0800
Committer: Li Yang 
Committed: Mon Oct 10 18:02:04 2016 +0800

--
 examples/sample_cube/create_sample_tables.sql   | 2 +
 .../sample_cube/data/DEFAULT.KYLIN_SALES.csv| 2 -
 .../cube_desc/kylin_sales_cube_desc.json|18 +-
 .../template/model_desc/kylin_sales_model.json  | 4 +-
 .../template/table/DEFAULT.KYLIN_SALES.json |10 +-
 5 files changed, 10030 insertions(+), 10004 deletions(-)
--


http://git-wip-us.apache.org/repos/asf/kylin/blob/0c7e2688/examples/sample_cube/create_sample_tables.sql
--
diff --git a/examples/sample_cube/create_sample_tables.sql 
b/examples/sample_cube/create_sample_tables.sql
index 5ed7b9b..8399ee8 100644
--- a/examples/sample_cube/create_sample_tables.sql
+++ b/examples/sample_cube/create_sample_tables.sql
@@ -181,6 +181,8 @@ TRANS_ID bigint
 ,PRICE decimal(19,4)
 ,ITEM_COUNT bigint
 ,SELLER_ID bigint
+,USER_ID string
+,REGION string
 )
 ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
 STORED AS TEXTFILE;

[12/50] [abbrv] kylin git commit: KYLIN-2076 Improve sample cube and data

2016-10-18 Thread lidong 
http://git-wip-us.apache.org/repos/asf/kylin/blob/0c7e2688/examples/sample_cube/data/DEFAULT.KYLIN_SALES.csv
--
diff --git a/examples/sample_cube/data/DEFAULT.KYLIN_SALES.csv 
b/examples/sample_cube/data/DEFAULT.KYLIN_SALES.csv
index 13c7d85..dffa43b 100644
--- a/examples/sample_cube/data/DEFAULT.KYLIN_SALES.csv
+++ b/examples/sample_cube/data/DEFAULT.KYLIN_SALES.csv
@@ -1,1 +1,1 @@
-0,2012-12-14,Others,88750,0,11,36.2828,0,1349
-0,2012-08-28,Others,175750,0,13,23.8563,0,1927
-0,2012-02-16,ABIN,148324,15,13,88.3418,0,1005
-0,2013-10-19,FP-non GTC,37831,0,13,47.3015,0,1209
-0,2012-10-22,Others,140746,100,11,83.4540,0,1154
-0,2013-01-25,FP-GTC,16509,0,-99,22.9896,0,1372
-0,2013-04-04,Others,963,0,13,88.5907,0,1648
-0,2012-04-11,Others,15687,0,15,88.1940,0,1866
-0,2013-01-19,ABIN,60606,3,13,77.9727,0,1936
-0,2012-04-30,FP-non GTC,106246,0,14,52.2950,0,1047
-0,2013-02-03,Auction,45333,0,16,56.3584,0,1470
-0,2012-09-02,FP-GTC,25147,0,-99,15.3553,0,1203
-0,2013-07-30,Others,24760,0,16,25.0770,0,1382
-0,2012-04-17,Auction,31519,0,16,72.7384,0,1069
-0,2013-04-30,FP-GTC,51582,0,15,75.8200,0,1085
-0,2013-03-23,FP-GTC,16509,0,15,8.6653,0,1559
-0,2013-04-01,ABIN,175750,3,16,64.2802,0,1507
-0,2013-07-12,ABIN,50677,0,-99,24.5987,0,1938
-0,2012-04-23,FP-GTC,45333,0,5,72.6553,0,1863
-0,2012-12-19,ABIN,3838,0,12,87.4142,0,1612
-0,2012-08-15,FP-GTC,62179,0,16,67.4238,0,1839
-0,2013-08-22,Auction,1357,0,5,18.3600,0,1303
-0,2013-08-23,ABIN,31519,0,5,67.6344,0,1877
-0,2013-09-12,FP-GTC,223,0,14,71.7898,0,1848
-0,2012-03-14,FP-GTC,132939,0,15,26.1496,0,1815
-0,2013-07-13,Others,67703,3,16,83.9661,0,1858
-0,2013-12-15,FP-non GTC,100847,0,5,34.3451,0,1387
-0,2012-08-30,Auction,62179,0,11,21.0496,0,1393
-0,2013-01-10,FP-GTC,48027,0,13,23.4142,0,1757
-0,2013-01-25,ABIN,145970,0,5,26.7842,0,1402
-0,2012-07-05,Auction,48027,0,-99,46.7320,0,1972
-0,2012-11-07,FP-GTC,20213,0,-99,19.7270,0,1873
-0,2013-06-20,ABIN,100847,0,5,76.2783,0,1409
-0,2012-10-08,ABIN,26262,0,5,48.7447,0,1029
-0,2013-04-30,ABIN,87118,0,15,63.2187,0,1529
-0,2013-04-24,FP-non GTC,20213,0,16,39.5057,0,1329
-0,2012-05-13,Others,164261,0,13,84.1246,0,1688
-0,2013-08-02,ABIN,31519,0,5,37.1504,0,1905
-0,2012-04-03,Auction,164261,0,11,92.0974,0,1341
-0,2012-09-02,FP-GTC,31519,0,14,87.7829,0,1460
-0,2013-10-05,ABIN,13987,0,16,74.0719,0,1381
-0,2012-01-13,FP-GTC,48027,0,15,71.2637,0,1915
-0,2013-03-01,Others,13836,0,14,16.7288,0,1953
-0,2012-09-12,FP-non GTC,16509,0,5,12.2933,0,1277
-0,2012-02-07,Auction,45333,0,5,64.9770,0,1040
-0,2013-12-14,FP-non GTC,158798,0,16,72.4413,0,1500
-0,2013-10-13,Auction,31519,0,5,79.3053,0,1816
-0,2012-06-11,ABIN,4943,0,5,11.6942,0,1696
-0,2012-10-18,ABIN,80053,0,-99,54.0933,0,1604
-0,2012-11-03,Auction,20886,0,5,9.8258,0,1764
-0,2012-01-15,Auction,44079,0,14,13.0371,0,1343
-0,2012-07-03,FP-GTC,159184,0,-99,92.5314,0,1724
-0,2012-02-16,FP-GTC,314,0,13,49.1825,0,1334
-0,2012-06-17,FP-non GTC,31387,3,12,0.6677,0,1603
-0,2012-07-15,FP-non GTC,32876,0,-99,50.9634,0,1248
-0,2012-07-24,FP-GTC,150265,15,16,57.5645,0,1653
-0,2012-10-06,Auction,145970,0,5,44.3091,0,1082
-0,2013-06-14,ABIN,80053,0,5,20.2388,0,1632
-0,2013-10-10,FP-non GTC,15868,0,11,28.6290,0,1523
-0,2012-09-30,ABIN,31673,0,12,75.8658,0,1719
-0,2012-04-02,FP-GTC,63861,0,5,25.8748,0,1311
-0,2012-03-16,Others,314,0,-99,9.2733,0,1409
-0,2012-09-30,FP-non GTC,60340,0,14,74.6610,0,1790
-0,2012-03-20,Others,87118,0,5,79.3781,0,1384
-0,2012-09-12,FP-GTC,1120,3,5,61.4408,0,1645
-0,2013-12-10,FP-non GTC,20886,0,11,14.8140,0,1943
-0,2012-12-05,FP-GTC,106246,0,12,24.9380,0,1858
-0,2012-08-21,Auction,43479,0,12,22.2008,0,1310
-0,2012-11-30,FP-GTC,175750,0,15,35.1161,0,1440
-0,2013-10-10,Others,95672,0,11,82.3718,0,1128
-0,2012-10-17,Auction,80053,0,15,9.8166,0,1105
-0,2012-03-16,FP-non GTC,57784,0,5,66.2369,0,1439
-0,2012-11-14,ABIN,65,0,11,17.5513,0,1855
-0,2013-06-24,FP-GTC,16509,0,15,53.9195,0,1130
-0,2012-08-13,FP-non GTC,65,0,5,69.8447,0,1548
-0,2012-01-03,Others,38238,0,11,90.3722,0,1739
-0,2013-11-24,FP-non GTC,175750,3,13,47.3441,0,1291
-0,2013-11-08,Auction,106246,0,5,38.6729,0,1310
-0,2013-04-07,Others,73506,0,-99,69.8999,0,1235
-0,2012-10-15,FP-GTC,314,0,13,44.1598,0,1265
-0,2012-01-20,FP-GTC,80287,0,-99,85.7263,0,1704
-0,2012-08-17,ABIN,32876,0,16,21.2934,0,1163
-0,2013-07-09,Auction,37831,0,15,38.2213,0,1557
-0,2013-09-21,Others,45333,0,13,25.5384,0,1184
-0,2013-10-28,FP-non GTC,11554,0,16,89.9654,0,1940
-0,2013-04-05,Auction,11554,0,14,41.8676,0,1384
-0,2013-03-25,FP-GTC,43398,0,14,75.0110,0,1697
-0,2012-05-03,ABIN,33038,15,12,64.6735,0,1147
-0,2012-10-13,ABIN,956