hive的数据导入

----- hive的数据导入
使用load语句
    load data [local] inpath 'filepath' [overwrite] 
    into table tablename [partition (partcol1=val1,partcol2=val2,......)]
    
---将student1.txt数据导入表t2
load data local inpath '../data/student1.txt' into table t2;

---将student1.txt数据导入表t3
load data local inpath '../data/student1.txt' into table t3;

---将../data下的所有数据文件导入表t3中，且覆盖原来的数据
load data local inpath '../data/' overwrite into table t3;

---将hdfs中/input/student1.txt导入到表t3
load data inpath '/input/student1.txt' overwrite into table t3;

---将不同文件导入到分区表partition_table
--- partition_table  ---分区表
--- data1.txt ---性别F
--- data2.txt ---性别M
load data local inpath '../data/data1.txt' into table partition_table partition (gender='F');
load data local inpath '../data/data2.txt' into table partition_table partition (gender='M');