FAQ
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

Search Discussions

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
groupuser @
categorieshive, hadoop
postedSep 21, '11 at 11:34p
activeSep 21, '11 at 11:34p
posts1
users1
websitehive.apache.org

1 user in discussion

Aniket Mokashi: 1 post

People

Translate

site design / logo © 2022 Grokbase