Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-20962 CommonMergeJoinOperator cannot join on complex keys
  3. HIVE-2508

Join on union type fails

    XMLWordPrintableJSON

Details

    • Sub-task
    • Status: Open
    • Major
    • Resolution: Unresolved
    • None
    • None
    • Query Processor

    Description

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

      Attachments

        Issue Links

          is related to

          Sub-task - The sub-task of the issue HIVE-24883 Support ARRAY/STRUCT types in equality SMB and Common merge join

          • Major - Major loss of function.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. HIVE-2390 Add UNIONTYPE serialization support to LazyBinarySerDe

          • Major - Major loss of function.
          • Closed

          New Feature - A new feature of the product, which has yet to be developed. HIVE-15434 Add UDF to allow interrogation of uniontype values

          • Major - Major loss of function.
          • Closed

          Activity

            People

              Unassigned Unassigned
              ashutoshc Ashutosh Chauhan
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated: