[ https://issues.apache.org/jira/browse/HIVE-22991?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Sankar Hariappan reassigned HIVE-22991: --------------------------------------- Assignee: Nishant Goel > 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 > Assignee: Nishant Goel > Priority: Minor > 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)