hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Divakar Reddy <divakarredd...@gmail.com>
Subject Re: downloading RDBMS table data to Hive with Sqoop import
Date Tue, 05 May 2015 18:32:36 GMT
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