此实践是在安装好kylin,并且成功进入http://IP:7070/kylin/login 界面之后的操作哦
登录Kylin
在hive测试加载数据(此实践数据存放在结尾)
准备测试数据
创建数据库、表、加载数据
create table dw_sales(id string,date1 string,channelId string, productId string, regionId string,amount int,price double)ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' stored as textfile;
-- 2、渠道表:dim_channel
-- channelId 渠道ID
-- channelName 渠道名称
create table dim_channel(channelId string, channelName string )ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' stored as textfile;
-- 3、产品表:dim_product
create table dim_product(productId string, productName string )ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' stored as textfile;
--4、区域表:dim_region
create table dim_region(regionId string,regionName string)ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' stored as textfile;
-- 导入数据
LOAD DATA LOCAL INPATH '/opt/kylindatas/dw_sales_data.txt' OVERWRITE INTO TABLE dw_sales;
LOAD DATA LOCAL INPATH '/opt/kylindatas/dim_channel_data.txt' OVERWRITE INTO TABLE dim_channel;
LOAD DATA LOCAL INPATH '/opt/kylindatas/dim_product_data.txt' OVERWRITE INTO TABLE dim_product;
LOAD DATA LOCAL INPATH '/opt/kylindatas/dim_region_data.txt' OVERWRITE INTO TABLE dim_region;
测试业务查询效率
需求:按照日期和渠道查看日期以及对应的交易金额和交易数量。
Sql=
select
date1, sum(price) as total_money, sum(amount) as total_amount
from
dw_sales
group by
date1,channelid;
实施
1、创建项目(Project)
2、创建数据源(DataSource)
3、创建模型(Model)
设置model名称
4、创建立方体(Cube)
在这里插入图片描述
5、 执行构建、等待构建完成
6、再执行SQL查询,获取结果
从Cube中查询数据
!!!实践数据
链接:https://pan.baidu.com/s/1-wjnV6KjsAFr4clFrZEbAw
提取码:xu86