[
https://issues.apache.org/jira/browse/HIVE-24883?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17334611#comment-17334611
]
Stamatis Zampetakis commented on HIVE-24883:
--------------------------------------------
The current PR aims to enable equality sort merge joins on ARRAY, UNION, and
STRUCT types. I am more or less fine with ARRAY and STRUCT types but still have
some doubts about UNION types. Currently, we don't allow comparisons with UNION
types even in simple filter conditions in the WHERE clause so not sure if it
makes sense to open the support in JOINS. A similar discussion about UNION and
joins appeared in the past (HIVE-2508) and at that point people were a bit
skeptical. Also in the
[wiki|https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Types#LanguageManualTypes-UnionTypesunionUnionTypes]
we are discouraging people from using it in comparisons.
Don't know if there were internal discussions about UNION types and JOINs (or
client requests) but personally I find it a bit weird and would prefer to be
more conservative and not support officially UNION type in comparisons unless
there is actually demand to do so. If people already agreed on this then it is
fine by me.
> Add support for complex types columns in Hive Joins
> ---------------------------------------------------
>
> Key: HIVE-24883
> URL: https://issues.apache.org/jira/browse/HIVE-24883
> Project: Hive
> Issue Type: Bug
> Components: Hive
> Affects Versions: 4.0.0
> Reporter: mahesh kumar behera
> Assignee: mahesh kumar behera
> Priority: Major
> Labels: pull-request-available
> Fix For: 4.0.0
>
> Time Spent: 2h 50m
> Remaining Estimate: 0h
>
> Hive fails to execute joins on array type columns as the comparison functions
> are not able to handle array type columns.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
