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 <divakarredd...@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 <ashok34...@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 >> > >
