nly asked questions.
From: "Daniel,Wu"
To: hive
Sent: Thursday, August 11, 2011 7:01 PM
Subject: multiple tables join with only one hug table.
if the retailer fact table is sale_fact with 10B rows, and join with 3 small
tables: stores (10K), products(10K), period (1K). What'
tions.
From: "Daniel,Wu"
To: hive
Sent: Thursday, August 11, 2011 7:01 PM
Subject: multiple tables join with only one hug table.
if the retailer fact table is sale_fact with 10B rows, and join with 3 small
tables: stores (10K), products(10K), period (1K). What's the best join
f each mapper.
>>
>> -Ayon
>> See My Photos on Flickr <http://www.flickr.com/photos/ayonsinha/>
>> Also check out my Blog for answers to commonly asked
>> questions.<http://dailyadvisor.blogspot.com>
>>
>> --
>> *Fro
ler tables specified
in the Mapjoin hint into memory. Then every small table is in memory of each
mapper.
-Ayon
See My Photos on Flickr
Also check out my Blog for answers to commonly asked questions.
From: "Daniel,Wu"
To: hive
Sent: Thursday, August 11, 2011 7:01 PM
Subject: multi
;http://dailyadvisor.blogspot.com>
>
> --
> *From:* "Daniel,Wu"
> *To:* hive
> *Sent:* Thursday, August 11, 2011 7:01 PM
> *Subject:* multiple tables join with only one hug table.
>
> if the retailer fact table is sale_fact with 10B rows, a
.
From: "Daniel,Wu"
To: hive
Sent: Thursday, August 11, 2011 7:01 PM
Subject: multiple tables join with only one hug table.
if the retailer fact table is sale_fact with 10B rows, and join with 3 small
tables: stores (10K), products(10K), period (1K). What's the best join solution?
if the retailer fact table is sale_fact with 10B rows, and join with 3 small
tables: stores (10K), products(10K), period (1K). What's the best join solution?
In oracle, it can first build hash for stores, and hash for products, and hash
for stores. Then probe using the fact table, if the row mat
