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":"1107625...@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":"1107625...@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)