hive SQL语句练习

hive SQL语句练习

建数据库：

建表：

--部门
create table tb_dept(
deptno INT,
dname STRING,
loc STRING
)ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t'
LINES TERMINATED BY '\n';

载入数据： 

LOAD  DATA local INPATH '/opt/datas/dept.txt'  INTO TABLE tb_dept;

--员工
create table tb_emp(
empno INT,
ename STRING,
job STRING,
mgr INT,
hiredate STRING,
sal DOUBL