You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "BALAMURUGAN (JIRA)" <ji...@apache.org> on 2016/09/07 07:56:21 UTC
[jira] [Updated] (HIVE-14712) Insert fails when using union all
[ https://issues.apache.org/jira/browse/HIVE-14712?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
BALAMURUGAN updated HIVE-14712:
-------------------------------
Description:
HUE version * 2.6.1-3485
hdp 2.3.4
insert overwrite trn_operation
Select code , opcode from
(
select code , opcode from master
union all
select code, opcode from master
)as base;
when i give the union it inserts but when i give union all it gives error.
ERROR : Failed with exception checkPaths
at org.apache.hadoop.hive.ql.metadata.Hive.checkPaths(Hive.java:2491)
at org.apache.hadoop.hive.ql.metadata.Hive.replaceFiles(Hive.java:2905)
at org.apache.hadoop.hive.ql.metadata.Hive.loadTable(Hive.java:1659)
at org.apache.hadoop.hive.ql.exec.MoveTask.execute(MoveTask.java:298)
at org.apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:160)
> Insert fails when using union all
> ---------------------------------
>
> Key: HIVE-14712
> URL: https://issues.apache.org/jira/browse/HIVE-14712
> Project: Hive
> Issue Type: Bug
> Components: Database/Schema
> Reporter: BALAMURUGAN
>
> HUE version * 2.6.1-3485
> hdp 2.3.4
> insert overwrite trn_operation
> Select code , opcode from
> (
> select code , opcode from master
> union all
> select code, opcode from master
> )as base;
> when i give the union it inserts but when i give union all it gives error.
> ERROR : Failed with exception checkPaths
> at org.apache.hadoop.hive.ql.metadata.Hive.checkPaths(Hive.java:2491)
> at org.apache.hadoop.hive.ql.metadata.Hive.replaceFiles(Hive.java:2905)
> at org.apache.hadoop.hive.ql.metadata.Hive.loadTable(Hive.java:1659)
> at org.apache.hadoop.hive.ql.exec.MoveTask.execute(MoveTask.java:298)
> at org.apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:160)
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)