hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Guodong Wang (JIRA)" <j...@apache.org>
Subject [jira] [Created] (HIVE-11126) multiple insert fails when select with group by clause
Date Fri, 26 Jun 2015 10:26:05 GMT
Guodong Wang created HIVE-11126:
-----------------------------------

             Summary: multiple insert fails when select with group by clause
                 Key: HIVE-11126
                 URL: https://issues.apache.org/jira/browse/HIVE-11126
             Project: Hive
          Issue Type: Bug
          Components: Parser
    Affects Versions: 0.12.0
            Reporter: Guodong Wang


When the select statement contains group by clause, multiple insert fails.

Here is the sample sql.
{code}
from test_src_table 
insert overwrite table test_target_table partition(p)
select src_id as id, "lala"  as p
group by src_id

insert overwrite table test_target_table partition(p)
select id, p from
select src_id as id, "papa" as p
group by src_id
{code}

The exception is like this
{code}
java.lang.RuntimeException: org.apache.hadoop.hive.ql.metadata.HiveException: Hive Runtime
Error while processing row {"_col0":"1107625951@qq.com","_col1":"lala"}
	at org.apache.hadoop.hive.ql.exec.mr.ExecMapper.map(ExecMapper.java:195)
	at org.apache.hadoop.mapred.MapRunner.run(MapRunner.java:50)
	at org.apache.hadoop.mapred.MapTask.runOldMapper(MapTask.java:417)
	at org.apache.hadoop.mapred.MapTask.run(MapTask.java:332)
	at org.apache.hadoop.mapred.Child$4.run(Child.java:268)
	at java.security.AccessController.doPrivileged(Native Method)
	at javax.security.auth.Subject.doAs(Subject.java:415)
	at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1614)
	at org.apache.hadoop.mapred.Child.main(Child.java:262)
Caused by: org.apache.hadoop.hive.ql.metadata.HiveException: Hive Runtime Error while processing
row {"_col0":"1107625951@qq.com","_col1":"lala"}
	at org.apache.hadoop.hive.ql.exec.MapOperator.process(MapOperator.java:550)
	at org.apache.hadoop.hive.ql.exec.mr.ExecMapper.map(Ex

FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.mr.MapRedTask
{code}





--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message