Apache Kylin Tutorial 1.5
需积分: 10 119 浏览量
2016-08-23
10:26:01
上传
评论
收藏 9.01MB PDF 举报
Quick Start with Sample Cube
Kylin provides a script for you to create a sample Cube; the script will also create three sample hive
tables:
Run ${KYLIN_HOME}/bin/sample.sh ; Restart kylin server to flush the caches;
1.
Logon Kylin web, select project “learn_kylin”;
2.
Select the sample cube “kylin_sales_cube”, click “Actions” -> “Build”, pick up a date later than
2014-01-01 (to cover all 10000 sample records);
3.
Check the build progress in “Jobs” tab, until 100%;
4.
Execute SQLs in the “Query” tab, for example:
select part_dt, sum(price) as total_selled, count(distinct seller_id) as sellers from kylin_sales group by
part_dt order by part_dt
5.
You can verify the query result and compare the response time with hive;
6.
What’s next
After cube being built, please refer to other document of this tutorial for more detail information.
剩余80页未读，继续阅读
资源评论
