hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From mahender bigdata <>
Subject Insert query with selective columns in Hive
Date Tue, 24 May 2016 19:57:29 GMT

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 

View raw message