Allow ARRAY_CONTAINS to be used as join key -------------------------------------------
Key: HIVE-1919 URL: https://issues.apache.org/jira/browse/HIVE-1919 Project: Hive Issue Type: Improvement Reporter: Adam Kramer Using ARRAY_CONTAINS(b.haystack, a.needle) fails with the "Both Left and Right Aliases Encountered in Join" error. But, it doesn't have to...it is effectively an equi-join, just more complicated. The appropriate functionality can be attained using EXPLODE and GROUP BY, but that is ridiculous in terms of amount of work generated for the cluster. -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.