hive的insert into

创建了一个空表 create table t1(a int);
然后有一个表t2(a int)有几行数据,
{{{hive> select * from t2;
OK
13
1214
1
Time taken: 0.175 seconds, Fetched: 3 row(s)}}}然后查询表t2的数据并导入t1中:
{{{hive> insert into t1 select * from t2;
Query ID = root_20161216133434_941c0576-6f56-4b4c-af38-b1097919cd25
Total jobs = 3
Launching Job 1 out of 3
Number of reduce tasks is set to 0 since there's no reduce operator
Starting Job = job_1481680614089_0016, Tracking URL = http://dell:8088/proxy/application_1481680614089_0016/
Kill Command = /mnt/software/hadoop-2.6.5/bin/hadoop job -kill job_1481680614089_0016
Hadoop job information for Stage-1: number of mappers: 0; number of reducers: 0
2016-12-16 13:34:19,980 Stage-1 map = 0%, reduce = 0%
Ended Job = job_1481680614089_0016 with errors
Error during job, obtaining debugging information...
Job Tracking URL: http://dell:8088/cluster/app/application_1481680614089_0016
FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.mr.MapRedTask
MapReduce Jobs Launched:
Stage-Stage-1: HDFS Read: 0 HDFS Write: 0 FAIL
Total MapReduce CPU Time Spent: 0 msec}}}hive这种insert不支持吗?
已邀请:
Apache hive 1.1.0
只支持批量load,原理是把load的文件mv到hive的仓库中去。
insert into table 吧?是可以用这种方式导数据的

要回复问题请先登录注册