hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Chaoyu Tang (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-2508) Join on union type fails
Date Thu, 19 Dec 2013 14:54:13 GMT

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

Mime
View raw message