Hi Abshiek From my understanding, when you have the join happening in map or reduce, the values corresponding to a key from all all table's except one (if two tables are involved in join on same key, then just one table here) are buffered in memory and the left out one is streamed. Usually it is the largest table to be streamed, else the larger data can go into the memory(buffer) and create OOM errors.
This stream table hint is used to specify which table to be streamed. By default it is the table that comes on the right is streamed and the other is buffered. But if you wan't other than right table to be streamed you go for this hint. If you are joining more tables on different keys, then for every join set just specify the larger table on the right of ON condition. No need of stream table hint here. Regards Bejoy KS ________________________________ From: abhiTowson cal <abhishek.dod...@gmail.com> To: user@hive.apache.org Sent: Friday, July 27, 2012 12:50 AM Subject: STREAM (TABLE) IN HIVE HI all, Can any one explain me how stream table in hive works What is the importance of STREAM TABLE? When should i use it? Suppose i am joining four to five tables Which table should be mentioned in the STREAM table hint? Should Big Table be specified in the STREAM TABLE hint or Small Table Regards Abhishek
