本篇主要演示Hive的数据操作,包括向表中装载数据、插入数据、创建表以及导出数据。
一 向表中装载数据
1 语法结构
LOAD DATA [LOCAL] INPATH 'filepath' [OVERWRITE] INTO TABLE tablename [PARTITION (partcol1=val1, partcol2=val2 ...)]
2 示例
hive> load data local inpath '/home/hadoop/emp/'
> into table emp;
Loading data to table hive.emp
OK
Time taken: 0.95 seconds
hive> select *from emp;
OK
emp.id emp.name
1 Alen
2 Jane
3 Tom
4 Peter
Time taken: 0.252 seconds, Fetched: 4 row(s)
hive>
二 通过查询语句向表中插入数据
1 语法结构
INSERT OVERWRITE TABLE tablename1 [PARTITION (partcol1=val1, partcol2=val2 ...) [IF NOT EXISTS]] select_statement1 FROM from_statement;
INSERT INTO TABLE tablename1 [PARTITION (partcol1=val1, partcol2=val2 ...)] select_statement1 FROM from_statement;
Hive extension (multiple inserts):
FROM from_statement
INSERT OVE