Ping..
On 5/24/2016 12:57 PM, mahender bigdata wrote:
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.
