[ 
https://issues.apache.org/jira/browse/HIVE-14280?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16017070#comment-16017070
 ] 

Eden commented on HIVE-14280:
-----------------------------

Change the configuration as follows´╝Ü
set hive.mapred.supports.subdirectories=true;

> tez insert fails when union all the table itself
> ------------------------------------------------
>
>                 Key: HIVE-14280
>                 URL: https://issues.apache.org/jira/browse/HIVE-14280
>             Project: Hive
>          Issue Type: Bug
>          Components: Tez
>    Affects Versions: 1.2.1
>         Environment: hdp 2.3.4.7 on red hat 6
>            Reporter: Frank Luo
>
> It is very common in Hive world to "append" data to a table by inserting some 
> data, and do a "union all" with the same table. However the query works in 
> M/R but not tez. 
> Here is a sample to recreate the issue:
> CREATE TABLE tmp_table
> (
>    grp    STRING,
>    size   INT
> );
> insert into table tmp_table values
> ('a',1);
> --this query will fail
> insert overwrite table tmp_table
> select * from tmp_table a
> union all 
> select * from tmp_table b;
> Here is the error:
> ERROR : Failed with exception checkPaths: 
> hdfs://nameservice1/apps/hive/warehouse/jluo.db/tmp_table/.hive-staging_hive_2016-07-19_10-48-15_971_8813032872646179391-4161/-ext-10000
>  has nested directory 
> hdfs://nameservice1/apps/hive/warehouse/jluo.db/tmp_table/.hive-staging_hive_2016-07-19_10-48-15_971_8813032872646179391-4161/-ext-10000/1
> org.apache.hadoop.hive.ql.metadata.HiveException: checkPaths: 
> hdfs://nameservice1/apps/hive/warehouse/jluo.db/tmp_table/.hive-staging_hive_2016-07-19_10-48-15_971_8813032872646179391-4161/-ext-10000
>  has nested directory 
> hdfs://nameservice1/apps/hive/warehouse/jluo.db/tmp_table/.hive-staging_hive_2016-07-19_10-48-15_971_8813032872646179391-4161/-ext-10000/1
>       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.15#6346)

Reply via email to