You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@hive.apache.org by "mahesh kumar behera (Jira)" <ji...@apache.org> on 2021/05/24 02:00:00 UTC

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

     [ https://issues.apache.org/jira/browse/HIVE-2508?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

mahesh kumar behera updated HIVE-2508:
--------------------------------------
        Parent: HIVE-20962
    Issue Type: Sub-task  (was: Bug)

> Join on union type fails
> ------------------------
>
>                 Key: HIVE-2508
>                 URL: https://issues.apache.org/jira/browse/HIVE-2508
>             Project: Hive
>          Issue Type: Sub-task
>          Components: Query Processor
>            Reporter: Ashutosh Chauhan
>            Priority: Major
>              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
(v8.3.4#803005)