Hive高级语法

-- 通过 hive 加载数据
-- 创建数据表
USE myhivebook;

CREATE TABLE IF NOT EXISTS student
(
    id int,
    name string
) comment '学生表'
row FORMAT delimited
fields terminated BY ',';

desc formatted student;

-- 创建数据
vi /root/data/student.dat
1001,tom
1002,jack
1003,rose

-- 加载数据
-- 复制本地文件上传到hdfs中
LOAD DATA LOCAL INPATH '/root/data/student.dat' OVERWRITE INTO TABLE student;
-- 剪切hdfs文件到其他hdfs目录
dfs -mkdir -p /hadoop/mydata;
dfs -put /root/data/student.dat /hadoop/mydata;
dfs -ls /hadoop/mydata;
LOAD data inpath '/hadoop/mydata/student.dat' overwrite INTO TABLE student;
-- 追加本地文件到表中
LOAD data local inpath '/root/data/student.dat' INTO TABLE student;
-- 追加hdfs文件到表中
TRUNCATE TABLE student;
dfs -put /root/data/student.dat /hadoop/mydata;
LOAD data inpath '/hadoop/mydata/student.dat