[jira] [Commented] (HIVE-2508) Join on union type fails

["Chaoyu Tang (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/HIVE-2508?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13852944#comment-13852944 ] 

Chaoyu Tang commented on HIVE-2508:
-----------------------------------

I believe the observed error was due to the lack of union type support in LazyBinarySerDe which is used to deserialize the reduce values in Join, rather than the join on the key of union type. So any join query with select values having union type (e.g. SELECT * FROM DEST1 JOIN DEST2 on (DEST1.value = DEST2.value) should failed with same NPE.


> Join on union type fails
> ------------------------
>
>                 Key: HIVE-2508
>                 URL: https://issues.apache.org/jira/browse/HIVE-2508
>             Project: Hive
>          Issue Type: Bug
>          Components: Query Processor
>            Reporter: Ashutosh Chauhan
>              Labels: uniontype
>
> {code}
> hive> CREATE TABLE DEST1(key UNIONTYPE<STRING, STRING>, value BIGINT) STORED AS TEXTFILE;
> OK
> Time taken: 0.076 seconds
> hive> CREATE TABLE DEST2(key UNIONTYPE<STRING, STRING>, value BIGINT) STORED AS TEXTFILE;
> OK
> Time taken: 0.034 seconds
> hive> SELECT * FROM DEST1 JOIN DEST2 on (DEST1.key = DEST2.key);
> {code}



--
This message was sent by Atlassian JIRA
(v6.1.4#6159)