Blog for answers to commonly asked questions.
From: Daniel,Wu hadoop...@163.com
To: hive user@hive.apache.org
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
my Blog for answers to commonly asked questions.
From: Daniel,Wu hadoop...@163.com
To: hive user@hive.apache.org
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
: 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?
In oracle, it can first build hash for stores
asked
questions.http://dailyadvisor.blogspot.com
--
*From:* Daniel,Wu hadoop...@163.com
*To:* hive user@hive.apache.org
*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
--
*From:* Daniel,Wu hadoop...@163.com
*To:* hive user@hive.apache.org
*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
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