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
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)
