Re: Can I update just one row in Hive table using Hive INSERT OVERWRITE

[unmesha sreeveni]

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

Re: Can I update just one row in Hive table using Hive INSERT OVERWRITE

[Nitin Pawar]

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

Can I update just one row in Hive table using Hive INSERT OVERWRITE

[Raj Hadoop]

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.