Re: Insert query with selective columns in Hive

2016-05-25 Thread mahender bigdata
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

Re: Insert query with selective columns in Hive

2016-05-24 Thread Mich Talebzadeh
This should work Mine is Hive 2 hive> create table testme (col1 int, col2 int, col3 int, col4 int); OK Time taken: 4.006 seconds hive> insert into testme values(1,2,3,4); Loading data to table test.testme OK Time taken: 70.844 seconds hive> insert into testme (col1,col2,col3,col4) values(1,2,3,4)

Insert query with selective columns in Hive

2016-05-24 Thread mahender bigdata
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