[jira] [Created] (HIVE-22991) INSERT INTO with named field list and CBO=false fails

["David Doran (Jira)" <ji...@apache.org>]

David Doran created HIVE-22991:
----------------------------------

             Summary: INSERT INTO with named field list and CBO=false fails
                 Key: HIVE-22991
                 URL: https://issues.apache.org/jira/browse/HIVE-22991
             Project: Hive
          Issue Type: Bug
          Components: Query Planning
    Affects Versions: 3.0.0
            Reporter: David Doran
         Attachments: INSERT INTO with named field list and CBO=false bug.txt

Queries that insert into tables using a named field list fail when CBO is disabled.

Here's an example to illustrate what I mean:

INSERT INTO dd_insert_values_test(field1, field2) VALUES ('hive.cbo.enable=false', 'With named fields');

Notice that it names the fields (field1, field2) into which the values should be inserted.

With CBO disabled this query fails with error:

-- Error: Error while compiling statement: FAILED: SemanticException 0:0 Expected 2 columns for insclause-0/daved@dd_insert_values_test; select produces 1 columns. Error encountered near token ''With named fields'' (state=42000,code=40000)

With CBO enabled it works.

And without the named field list, it works with either CBO enabled or disabled. Please see the attached repro script: [^INSERT INTO with named field list and CBO=false bug.txt]



--
This message was sent by Atlassian Jira
(v8.3.4#803005)