hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Bhagwan S. Soni" <bhgwnsson...@gmail.com>
Subject Re: downloading RDBMS table data to Hive with Sqoop import
Date Tue, 05 May 2015 19:12:16 GMT
You have to write a different hql which will handle update and delete, you
can not do this direct from sqoop.

On Wed, May 6, 2015 at 12:02 AM, Divakar Reddy <divakarreddy.a@gmail.com>
wrote:

> As per my knowledge Sqoop doesn't support updates and deletes.
>
> We are handling like:
>
> 1) drop particular data from *partitioned* (form partitioned Column)
> table and load it again with conditions in sqoop like --query "select *
> form xyz where date = '2015-04-02'
>
> Thanks,
> Divakar
>
> On Tue, May 5, 2015 at 10:41 AM, Ashok Kumar <ashok34668@yahoo.com> wrote:
>
>> Hi gurus,
>>
>> I can use Sqoop import to get RDBMS data say Oracle to Hive first and
>> then use incremental append for new rows with PK and last value.
>>
>> However, how do you account for updates and deletes with Sqoop without
>> full load of table from RDBMS to Hive?
>>
>> Thanks
>>
>
>

Mime
View raw message