hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From mahender bigdata <Mahender.BigD...@outlook.com>
Subject Re: Insert query with selective columns in Hive
Date Wed, 25 May 2016 12:24:06 GMT
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.
>
>
>


Mime
View raw message