13.3.kylin关联hive构建modle cube

1.数据准备

https://github.com/fayson/cdhproject/tree/master/kylindemo

 

hdfs dfs -put employee.csv /tmp/data/kylin/
hdfs dfs -put employee.csv /tmp/data/kylin/
beeline -u "jdbc:hive2://mini2:10000/default" -n hive -f create_table.sql

2.创建project- 

3.加载hive表

 

 

5.创建model，导入project的名称和描述

 

 

 

6.选择纬度字段

7.度量字段

8.如果有分区选择分区表和列

 

9.modle make

10.创建cube

 

 

全选mode中的纬度

选择度量指标，sum,Max

 

默认--创建完成

11.构建Cube

执行

select count(*) from EMPLOYEE 

Start Time: 2019-08-02 10:01:40 UTC   Duration: 0.09s    Rerun  Save

Start Time: 2019-08-02 10:02:11 UTC   Duration: 0.11s    Rerun  Save

select max(salary) from EMPLOYEE

 

Start Time: 2019-08-02 10:36:55 UTC   Duration: 0.14s    Rerun  Save

 

统计各部门员工薪资总和，执行以下语句

select d.ID,sum(e.SALARY) as salary from EMPLOYEE as e left join DEPARTMENT as d on e.DEPTID=d.id group by d.ID order by salary desc

 

删除model先执行discard再drop