[HIVE-28595] Not able to insert data with hive.cbo.enable=false

• Type: Bug
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: 4.0.0-alpha-2
• Assignee: Indhumathi Muthumurugesh
• Reporter: chiranjeevi
• Created: 29/Oct/24 09:34
• Updated: 06/Nov/24 07:38

Description

create table if not exists trunc_call_center( cc_call_center_sk bigint , cc_call_center_id char(16) ) row format delimited fields terminated by '|';
insert into trunc_call_center(cc_call_center_sk, cc_call_center_id) VALUES(1234, 'a');
 set hive.cbo.enable=false;
ERROR:
Error: Error while compiling statement: FAILED: SemanticException 0:0 Expected 2 columns for insclause-0/db_name@trunc_call_center; select produces 1 columns. Error encountered near token ''a''
Please ignore line number 1, marked in the above error message. Error at line 375. (state=,code=0)

Able to insert data with set hive.cbo.enable=true;

 

Issue Links

• relates to: HIVE-27830 Deprecate hive.cbo.enable property