You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@kylin.apache.org by li...@apache.org on 2016/10/10 13:54:24 UTC
[10/12] kylin git commit: KYLIN-2076 Improve sample cube and data
KYLIN-2076 Improve sample cube and data
Signed-off-by: Li Yang <li...@apache.org>
Project: http://git-wip-us.apache.org/repos/asf/kylin/repo
Commit: http://git-wip-us.apache.org/repos/asf/kylin/commit/5a114585
Tree: http://git-wip-us.apache.org/repos/asf/kylin/tree/5a114585
Diff: http://git-wip-us.apache.org/repos/asf/kylin/diff/5a114585
Branch: refs/heads/yang21-hbase1.x
Commit: 5a1145853e676c99459c43bfd941fb3e7c6e3fcf
Parents: 20093f4
Author: Cheng Wang <ch...@kyligence.io>
Authored: Mon Oct 10 17:49:33 2016 +0800
Committer: Li Yang <li...@apache.org>
Committed: Mon Oct 10 18:00:16 2016 +0800
----------------------------------------------------------------------
examples/sample_cube/create_sample_tables.sql | 4 +-
.../sample_cube/data/DEFAULT.KYLIN_SALES.csv | 20000 ++++++++---------
.../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, 10031 insertions(+), 10005 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/kylin/blob/5a114585/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 d83566c..8399ee8 100644
--- a/examples/sample_cube/create_sample_tables.sql
+++ b/examples/sample_cube/create_sample_tables.sql
@@ -181,10 +181,12 @@ 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;
LOAD DATA INPATH '/tmp/kylin/sample_cube/data/DEFAULT.KYLIN_SALES.csv' OVERWRITE INTO TABLE DEFAULT.KYLIN_SALES;
LOAD DATA INPATH '/tmp/kylin/sample_cube/data/DEFAULT.KYLIN_CAL_DT.csv' OVERWRITE INTO TABLE DEFAULT.KYLIN_CAL_DT;
-LOAD DATA INPATH '/tmp/kylin/sample_cube/data/DEFAULT.KYLIN_CATEGORY_GROUPINGS.csv' OVERWRITE INTO TABLE DEFAULT.KYLIN_CATEGORY_GROUPINGS;
\ No newline at end of file
+LOAD DATA INPATH '/tmp/kylin/sample_cube/data/DEFAULT.KYLIN_CATEGORY_GROUPINGS.csv' OVERWRITE INTO TABLE DEFAULT.KYLIN_CATEGORY_GROUPINGS;