hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Adam Kramer (JIRA)" <j...@apache.org>
Subject [jira] Resolved: (HIVE-1919) Allow ARRAY_CONTAINS to be used as join key
Date Tue, 18 Jan 2011 19:44:44 GMT

     [ 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.


Mime
View raw message