hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Divakar Reddy <>
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'


On Tue, May 5, 2015 at 10:41 AM, Ashok Kumar <> 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

View raw message