ALTER TABLE xref_tst ADD CONSTRAINT sku_pk PRIMARY KEY (sku_id);
Here is my sqoop export statement. Now when I run this first one below this it works fine and insert data into my empty oracle table. But when I add the 2 update lines in the second at the end it won't insert into my empty table. Does the update mode not work with hcatalog? What am I missing?
On the surface it looks like your second command should work too, since you've provided the --update-mode allowinsert parameter. Can you execute the second command with additional --verbose option and provide the output here?