[ 
https://issues.apache.org/jira/browse/HIVE-12895?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Charles Pritchard updated HIVE-12895:
-------------------------------------
    Description: 
With two tables that have different cluster by columns, using multiple INSERT 
OVERWRITE TABLE syntax results in the output files of one of the tables being 
named "_bucket_number_0" which should have clearly been renamed to the usual 
"00000_0" style. The temporary filename is not picked up for later selects, 
making this a more urgent issue.

This is with:
Tbl1: CLUSTERED BY (col1) SORTED BY(col1) INTO 1 BUCKETS;
Tbl2: CLUSTERED BY (col2) SORTED BY(col2) INTO 1 BUCKETS;

FROM statement
INSERT OVERWRITE TABLE tbl1 select...
INSERT OVERWRITE TABLE tbl2 select...;

  was:
With two tables that have different cluster by columns, using multiple INSERT 
OVERWRITE TABLE syntax results in the output files of one of the tables being 
named "_bucket_number_0", which is not picked up by analyzer/select later on.


This is with:
Tbl1: CLUSTERED BY (col1) SORTED BY(col1) INTO 1 BUCKETS;
Tbl2: CLUSTERED BY (col2) SORTED BY(col2) INTO 1 BUCKETS;

FROM statement
INSERT OVERWRITE TABLE tbl1 select...
INSERT OVERWRITE TABLE tbl2 select...;


> Bucket files not renamed with multiple insert overwrite table statements
> ------------------------------------------------------------------------
>
>                 Key: HIVE-12895
>                 URL: https://issues.apache.org/jira/browse/HIVE-12895
>             Project: Hive
>          Issue Type: Bug
>    Affects Versions: 0.14.0
>            Reporter: Charles Pritchard
>
> With two tables that have different cluster by columns, using multiple INSERT 
> OVERWRITE TABLE syntax results in the output files of one of the tables being 
> named "_bucket_number_0" which should have clearly been renamed to the usual 
> "00000_0" style. The temporary filename is not picked up for later selects, 
> making this a more urgent issue.
> This is with:
> Tbl1: CLUSTERED BY (col1) SORTED BY(col1) INTO 1 BUCKETS;
> Tbl2: CLUSTERED BY (col2) SORTED BY(col2) INTO 1 BUCKETS;
> FROM statement
> INSERT OVERWRITE TABLE tbl1 select...
> INSERT OVERWRITE TABLE tbl2 select...;



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

Reply via email to