2020-10-09 14:34发布
从本地导入:
load data local inpath '/home/st.txt' (overwrite) into table student;
从Hdfs导入:
load data inpath '/user/hive/warehouse/st.txt' (overwrite) into table student;
查询导入:
create table student_a as select * from student;(也可以具体查询某项数据)
查询结果导入:
insert (overwrite)into table student select * from student_a;
最多设置5个标签!
从本地导入:
load data local inpath '/home/st.txt' (overwrite) into table student;
从Hdfs导入:
load data inpath '/user/hive/warehouse/st.txt' (overwrite) into table student;
查询导入:
create table student_a as select * from student;(也可以具体查询某项数据)
查询结果导入:
insert (overwrite)into table student select * from student_a;
一周热门 更多>