Hive
  1. Hive
  2. HIVE-66

Insert into a dynamic serde table from a MetadataTypedColumnSetSerDe

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Critical Critical
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 0.3.0
    • Component/s: Query Processor
    • Labels:
      None

      Description

      Fails with column mismatch error.

        Activity

        Hide
        Ashish Thusoo added a comment -

        Test case is as follows:

        CREATE TABLE implicit_test1(a BIGINT, b STRING) ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe' WITH SERDEPROPERTIES('serialization.format'= 'org.apache.hadoop.hive.serde2.thrift.TCTLSeparatedProtocol') STORED AS TEXTFILE;

        DESCRIBE src;

        INSERT OVERWRITE TABLE implicit_test1
        SELECT src.key, src.value
        FROM src;

        where src is the MetadataTypedColumnSetSerDe table created in QTestUtil.java

        Show
        Ashish Thusoo added a comment - Test case is as follows: CREATE TABLE implicit_test1(a BIGINT, b STRING) ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe' WITH SERDEPROPERTIES('serialization.format'= 'org.apache.hadoop.hive.serde2.thrift.TCTLSeparatedProtocol') STORED AS TEXTFILE; DESCRIBE src; INSERT OVERWRITE TABLE implicit_test1 SELECT src.key, src.value FROM src; where src is the MetadataTypedColumnSetSerDe table created in QTestUtil.java
        Hide
        Ashish Thusoo added a comment -

        Also the following fails.

        INSERT OVERWRITE TABLE implicit_test1
        SELECT src.*
        FROM src;

        Show
        Ashish Thusoo added a comment - Also the following fails. INSERT OVERWRITE TABLE implicit_test1 SELECT src.* FROM src;
        Hide
        Zheng Shao added a comment -

        I believe this issue is fixed long time ago.

        Show
        Zheng Shao added a comment - I believe this issue is fixed long time ago.

          People

          • Assignee:
            Ashish Thusoo
            Reporter:
            Ashish Thusoo
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development