hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From unmesha sreeveni <unmeshab...@gmail.com>
Subject Re: Can I update just one row in Hive table using Hive INSERT OVERWRITE
Date Wed, 19 Nov 2014 09:15:11 GMT
Try these steps:
http://unmeshasreeveni.blogspot.in/2014/11/updating-partition-table-using-insert.html

On Sat, Apr 5, 2014 at 2:33 AM, Nitin Pawar <nitinpawar432@gmail.com> wrote:

> for non partitioned columns ans in one word: NO
>
> detailed answer here: This feature is still being build as part of
> https://issues.apache.org/jira/browse/HIVE-5317
>
>
> On Sat, Apr 5, 2014 at 2:28 AM, Raj Hadoop <hadoopraj@yahoo.com> wrote:
>
>>
>> Can I update ( delete and insert kind of) just one row keeping the
>> remaining rows intact in Hive table using Hive INSERT OVERWRITE. There is
>> no partition in the Hive table.
>>
>>
>> INSERT OVERWRITE TABLE tablename SELECT col1,col2,col3 from tabx where
>> col2='abc';
>>
>> Does the above work ? Please advise.
>>
>>
>>
>
>
> --
> Nitin Pawar
>



-- 
*Thanks & Regards *


*Unmesha Sreeveni U.B*
*Hadoop, Bigdata Developer*
*Centre for Cyber Security | Amrita Vishwa Vidyapeetham*
http://www.unmeshasreeveni.blogspot.in/

Mime
View raw message