【大数据入门核心技术-Kylin】（三）Kylin快速入门之离线任务构建

一、Kylin集群模式安装

参考

【大数据入门核心技术-Kylin】（二）Kylin集群安装_forest_long的博客-CSDN博客

二、Hive数据准备

新建hive库和插入数据

1、建库、建表
create database test_kylin0719;

use test_kylin0719;

// 1.创建部门表
create external table if not exists test_kylin0719.dept(
deptno int,
dname string,
loc int
)
row format delimited fields terminated by '\t';

// 2.创建员工表
create external table if not exists test_kylin0719.emp(
empno int,
ename string,
job string,
mgr int,
hiredate string, 
sal double, 
comm double,
deptno int)
row format delimited fields terminated by '\t';

use test_kylin0719;

show tables;


2、插入数据
insert into test_kylin0719.dept values(10,'dep001',1200),(11,'dep002',1400),(12,'dep003',1270),(13,'dep004',1290);

insert into test_kylin0719.emp values
(10