hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "BALAMURUGAN (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (HIVE-14712) Insert fails when using union all
Date Wed, 07 Sep 2016 07:57:20 GMT

     [ 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 table  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)

  was:
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 table  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)

Mime
View raw message