You are viewing a plain text version of this content. The canonical link for it is here.
Posted to mapreduce-user@hadoop.apache.org by hm...@tsmc.com on 2010/10/21 07:53:26 UTC
M/R use case
Hi there,
I wonder our oracle stored procedure is a good Hadoop M/R use case.
That procedure starts with a parameter like (productid) then it will
refer(do join) 32 tables.
Like Bill of Materail(BOM) stored in several normalized tables, the stored
procedure is denormalization process.
That a parameter will produce about 3000 records after that stored
procedure process.
Also, there are some logic bundling with the data, like if the string
begins with A ,
it will do join with TableA, if the string begins with B, it will do join
with TableB.
It's a complicated stored procedure, do a lot of join and even needs to
refer a Max() record in a table.
So, is this a good hadoop M/R use case?
Any suggestion would be appreciated!
Fleming Chiu(邱宏明)
Ext: 707-2260
Be Veg, Go Green, Save the Planet!
---------------------------------------------------------------------------
TSMC PROPERTY
This email communication (and any attachments) is proprietary information
for the sole use of its
intended recipient. Any unauthorized review, use or distribution by anyone
other than the intended
recipient is strictly prohibited. If you are not the intended recipient,
please notify the sender by
replying to this email, and then delete this email and any copies of it
immediately. Thank you.
---------------------------------------------------------------------------