USE DaveD; DROP TABLE dd_insert_values_test; CREATE TEMPORARY TABLE dd_insert_values_test ( field1 STRING, field2 STRING ); -- Works OK SET hive.cbo.enable=true; INSERT INTO dd_insert_values_test VALUES ('hive.cbo.enable=true', 'Without named fields'); -- Works OK SET hive.cbo.enable=true; INSERT INTO dd_insert_values_test(field1, field2) VALUES ('hive.cbo.enable=true', 'With named fields'); -- Works OK SET hive.cbo.enable=false; INSERT INTO dd_insert_values_test VALUES ('hive.cbo.enable=false', 'Without named fields'); -- FAILS! SET hive.cbo.enable=false; INSERT INTO dd_insert_values_test(field1, field2) VALUES ('hive.cbo.enable=false', 'With named fields'); -- 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) SELECT * FROM dd_insert_values_test; -- +-------------------------------+-------------------------------+ -- | dd_insert_values_test.field1 | dd_insert_values_test.field2 | -- +-------------------------------+-------------------------------+ -- | hive.cbo.enable=true | Without named fields | -- | hive.cbo.enable=true | With named fields | -- | hive.cbo.enable=false | Without named fields | -- +-------------------------------+-------------------------------+ -- -- Of course "hive.cbo.enable=false | With named fields" is missing because the INSERT query failed.