Repository: kylin Updated Branches: refs/heads/document bda894edd -> fbe11af26
KYLIN-2775 sample streaming cube tutorial Project: http://git-wip-us.apache.org/repos/asf/kylin/repo Commit: http://git-wip-us.apache.org/repos/asf/kylin/commit/fbe11af2 Tree: http://git-wip-us.apache.org/repos/asf/kylin/tree/fbe11af2 Diff: http://git-wip-us.apache.org/repos/asf/kylin/diff/fbe11af2 Branch: refs/heads/document Commit: fbe11af269d25ffa2705e38fcecfd3a4a1e5ee50 Parents: bda894e Author: Billy Liu <[email protected]> Authored: Tue Oct 10 16:29:39 2017 +0800 Committer: Billy Liu <[email protected]> Committed: Tue Oct 10 16:29:39 2017 +0800 ---------------------------------------------------------------------- website/_docs21/tutorial/kylin_sample.md | 15 ++++++++++++++- 1 file changed, 14 insertions(+), 1 deletion(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/kylin/blob/fbe11af2/website/_docs21/tutorial/kylin_sample.md ---------------------------------------------------------------------- diff --git a/website/_docs21/tutorial/kylin_sample.md b/website/_docs21/tutorial/kylin_sample.md index c04eec2..592231f 100644 --- a/website/_docs21/tutorial/kylin_sample.md +++ b/website/_docs21/tutorial/kylin_sample.md @@ -5,7 +5,7 @@ categories: tutorial permalink: /docs21/tutorial/kylin_sample.html --- -Kylin provides a script for you to create a sample Cube; the script will also create three sample hive tables: +Kylin provides a script for you to create a sample Cube; the script will also create five sample hive tables: 1. Run ${KYLIN_HOME}/bin/sample.sh ; Restart kylin server to flush the caches; 2. Logon Kylin web with default user ADMIN/KYLIN, select project "learn_kylin" in the project dropdown list (left upper corner); @@ -16,6 +16,19 @@ Kylin provides a script for you to create a sample Cube; the script will also cr 6. You can verify the query result and compare the response time with hive; +## Quick Start with Streaming Sample Cube + +Kylin provides a script for streaming sample cube also. This script will create Kafka topic and send the random messages constantly to the generated topic. + +1. Export KAFKA_HOME first, and start Kylin. +2. Run ${KYLIN_HOME}/bin/sample.sh, it will generate Table DEFAULT.KYLIN_STREAMING_TABLE, Model kylin_streaming_model, Cube kylin_streaming_cube in learn_kylin project. +3. Run ${KYLIN_HOME}/bin/sample-streaming.sh, it will create Kafka Topic kylin_streaming_topic into the localhost:9092 broker. It also send the random 100 messages into kylin_streaming_topic per second. +4. Follow the the standard cube build process, and trigger the Cube kylin_streaming_cube build. +5. Check the build process in "Monitor" tab, until at least one job is 100%. +6. Execute SQLs in the "Insight" tab, for example: + select count(*), HOUR_START from kylin_streaming_table group by HOUR_START +7. Verify the query result. + ## What's next You can create another cube with the sample tables, by following the tutorials.
