1、本地-->hive table: load data local inpath ‘/home/k6k4/user.txt’ (overwrite)into table user;
2、Hdfs-->hive table: load data inpath ‘/user/hive/warehouse/user.txt’ (overwrite)into table user;
3、hive table-->hive table 查询导入: create table user as select * from user1;(也可以具体查询某项数据)
4、hive table-->hive table 查询结果导入:insert (overwrite)into table user select * from user1;
2、Hdfs-->hive table: load data inpath ‘/user/hive/warehouse/user.txt’ (overwrite)into table user;
3、hive table-->hive table 查询导入: create table user as select * from user1;(也可以具体查询某项数据)
4、hive table-->hive table 查询结果导入:insert (overwrite)into table user select * from user1;
上一题:分区和分桶有什么区别?
下一题:Hive有哪几种导出数据的方式?
标签: hive、user、overwrite、导入、inpath
笔试题
刷题
简历模板
AI算法
大数据
内推
内推: