RE: Join vs. Where...In

2015-08-29 Thread Mich Talebzadeh
that this email is virus free, therefore neither Peridale Ltd, its subsidiaries nor their employees accept any responsibility. From: Raviv Murciano-Goroff [mailto:ravi...@gmail.com] Sent: 29 August 2015 00:50 To: user@hive.apache.org Subject: Join vs. Where...In Hi, I often have the followi

Join vs. Where...In

2015-08-28 Thread Raviv Murciano-Goroff
Hi, I often have the following situation: I have a small table with a list of unique IDs and a very large table of events associated with the IDs. I want to perform some aggregation including only events associated with IDs from the small table. Is there a rule of thumb for whether performing a J