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