注意:hive不支持insert into table values()的插入数据spa
hive表中加载数据的四种方式code
1.从本地加载数据orm
hive (hive)> create table wyp > (id int,name string, > age int,tel string) > row format delimited > fields terminated by '\t' > stored as textfile;
load data local inpath '/opt/hive-0.13.1/emp.txt' into table emp ;
2.从HDFS加载数据:string
load data inpath '/hive_load_data/wyp.txt' into table wyp;
注:這裡也是將HDFS中的內容移動到Hive中,而不是複製。另一個必定要注意,若是有一個同樣名稱的文件,你再使用命令加載數據是會報錯的。it
3.从接的表中加载数据到hive中io
hive (hive)> create table test( > id int,name string, > tel string) > partitioned by (age int) > row format delimited > fields terminated by '\t' > stored as textfile;
hive (hive)> insert into table test > partition (age='25') > select id,name,tel > from wyp;
4.在建表的时候往表中插入数据table
方式一:form
hive (hive)> create table test4 > as > select id,name,tel > from wyp;
方式二:class
hive (hive)> create table test4 > like wyp;