Hi - You need to write a shell script to accomplish this requirement. Step 1. you need to find the Max value of your Delta/Incremental field value and assign this value to a variable. 2. In this Scenario, you need to use the Sqoop Import statement instead of Creation. 3. In the same script you, need to use the Sqoop Import with --query in where clause put the condition and read your variable. This will solves your problem... ... View more

Hi - could you share your entire UNIX script that using sqoop Statement.. ... View more

Hi, You can use the windows functions in Hive using OVER (PARTITION BY code ORDER BY code DESC) for your reference and I am not sure the performance but you can tweak that also. ... View more