-Uniquejoin does not work with Partitioned table
Aniket Mokashi 2011-09-21, 23:33
I am trying to use uniquejoin to join multiple tables with same key in one
It works well if I stage individual partition data in temporary staging
But, if I make it work on top of partitioned tables, I do not get any
Does anyone know how to fix this?
I am using following syntax-
INSERT INTO ...
PRESERVE table1 (keys...)
PRESERVE table2 (keys...)
t1.partitionkey = X and
t2.partitionkey = X
It works well, if I copy table1 table2's partitions into table1_stage,
table2_stage which are unpartitioned tables.