hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From abhiTowson cal <>
Date Thu, 26 Jul 2012 20:01:34 GMT
Thank you Bejoy.


On Thu, Jul 26, 2012 at 3:57 PM, Bejoy Ks <> wrote:
> 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 <>
> To:
> Sent: Friday, July 27, 2012 12:50 AM
> 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

View raw message