Hi,Is there a way in Hive to insert specific columns rather than insert query with all columns options. Like I have table with 10 columns, in my insert statement, i would like to insert only 3 columns like below
insert into tbl1 (col1,col2,col10) values (1,2,3); insert into tbl1 (col1,col2,col10) values (4,5,6);Above query fails due to syntactic error, I have forcefully need to write Insert into tbl1 values (1,2,3.....10); I'm running in Hive 1.2 version.
