Details
-
Bug
-
Status: Open
-
Major
-
Resolution: Unresolved
-
0.14.0
-
None
-
None
-
None
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...;