hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Aniket Mokashi <aniket...@gmail.com>
Subject Uniquejoin does not work with Partitioned table
Date Wed, 21 Sep 2011 23:33:39 GMT
Hi,

I am trying to use uniquejoin to join multiple tables with same key in one
mapreduce job.
It works well if I stage individual partition data in temporary staging
tables.
But, if I make it work on top of partitioned tables, I do not get any
output.
Does anyone know how to fix this?

I am using following syntax-
INSERT INTO ...
SELECT
.....
FROM UNIQUEJOIN
PRESERVE table1 (keys...)
PRESERVE table2 (keys...)
WHERE
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.

Thanks,
Aniket

Mime
View raw message