KYLIN-2076 Improve sample cube and data Signed-off-by: Li Yang <liy...@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-cdh5.7 Commit: 5a1145853e676c99459c43bfd941fb3e7c6e3fcf Parents: 20093f4 Author: Cheng Wang <cheng.w...@kyligence.io> Authored: Mon Oct 10 17:49:33 2016 +0800 Committer: Li Yang <liy...@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;
