Hi Can you please send your original query and perhaps a small dataset sample?
Thanks Dudu From: Buntu Dev [mailto:buntu...@gmail.com] Sent: Tuesday, July 26, 2016 10:46 AM To: user@hive.apache.org Subject: Alternatives to self join I'm currently doing a self-join on a table 4 times on varying conditions. Although it works fine, I'm not sure if there are any alternatives that perform better. Please let me know. Thanks!