[ https://issues.apache.org/jira/browse/HIVE-1919?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Adam Kramer resolved HIVE-1919. ------------------------------- Resolution: Won't Fix Just realized that this is not in fact an equi-join...and there is no way to actually delete issues here. Hmph. > 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.