KYLIN-1795: fix sample.sh when using beeline Signed-off-by: shaofengshi <shaofeng...@apache.org>
Project: http://git-wip-us.apache.org/repos/asf/kylin/repo Commit: http://git-wip-us.apache.org/repos/asf/kylin/commit/2ba0478b Tree: http://git-wip-us.apache.org/repos/asf/kylin/tree/2ba0478b Diff: http://git-wip-us.apache.org/repos/asf/kylin/diff/2ba0478b Branch: refs/heads/v1.5.3-release-rc2 Commit: 2ba0478b1ade1acbf8640c956e8f3c449b77787f Parents: cdbdb55 Author: Yiming Liu <liuyiming....@gmail.com> Authored: Fri Jul 22 09:36:24 2016 +0800 Committer: shaofengshi <shaofeng...@apache.org> Committed: Fri Jul 22 12:34:58 2016 +0800 ---------------------------------------------------------------------- build/bin/sample.sh | 8 +++++++- examples/sample_cube/create_sample_tables.sql | 6 +++--- 2 files changed, 10 insertions(+), 4 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/kylin/blob/2ba0478b/build/bin/sample.sh ---------------------------------------------------------------------- diff --git a/build/bin/sample.sh b/build/bin/sample.sh index 7cc50c5..9939c62 100644 --- a/build/bin/sample.sh +++ b/build/bin/sample.sh @@ -25,6 +25,10 @@ job_jar=`find -L ${KYLIN_HOME}/lib/ -name kylin-job*.jar` echo "Going to create sample tables in hive..." cd ${KYLIN_HOME}/sample_cube/data +echo "Loading sample data into HDFS tmp path: /tmp/kylin/sample_cube/data" +hadoop fs -mkdir -p /tmp/kylin/sample_cube/data +hadoop fs -put * /tmp/kylin/sample_cube/data/ + hive_client_mode=`sh ${KYLIN_HOME}/bin/get-properties.sh kylin.hive.client` if [ "${hive_client_mode}" == "beeline" ] then @@ -35,6 +39,8 @@ else fi echo "Sample hive tables are created successfully; Going to create sample cube..." +hadoop fs -rm -r /tmp/kylin/sample_cube + cd ${KYLIN_HOME} hbase org.apache.hadoop.util.RunJar ${job_jar} org.apache.kylin.common.persistence.ResourceTool upload ${KYLIN_HOME}/sample_cube/metadata || { exit 1; } -echo "Sample cube is created successfully in project 'learn_kylin'; Restart Kylin server or reload the metadata from web UI to see the change." \ No newline at end of file +echo "Sample cube is created successfully in project 'learn_kylin'; Restart Kylin server or reload the metadata from web UI to see the change." http://git-wip-us.apache.org/repos/asf/kylin/blob/2ba0478b/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 943c0fa..d83566c 100644 --- a/examples/sample_cube/create_sample_tables.sql +++ b/examples/sample_cube/create_sample_tables.sql @@ -185,6 +185,6 @@ TRANS_ID bigint ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' STORED AS TEXTFILE; -LOAD DATA LOCAL INPATH 'DEFAULT.KYLIN_SALES.csv' OVERWRITE INTO TABLE DEFAULT.KYLIN_SALES; -LOAD DATA LOCAL INPATH 'DEFAULT.KYLIN_CAL_DT.csv' OVERWRITE INTO TABLE DEFAULT.KYLIN_CAL_DT; -LOAD DATA LOCAL INPATH '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_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
