Sqoop incremental import (db schema incorrect)

hortonworks-data-platform,sqoop2

Try this : sqoop import --connect "jdbc:sqlserver://192.168.40.133:1434;database=AdventureWorksLT2012;username=test;password=test" --table ProductModel --hive-import -- --schema SalesLT --incremental append --check-column ProductModelID --last-value "128" ...

Connection failure to Sap Hana from Sqoop

java,hadoop,jdbc,sap,sqoop2

@hafizmujadid when there is a password expiration deadline comes , it throws these error. What you have to do is ask the team from Sap Hana side to change the password. This solved my problem and it may be yours.

Oozie cant able to find JDBC drivers in Sqoop

hadoop,sqoop,oozie,sqoop2

You need to add all lib files like jdbc drivers, etc in the oozie share lib folder inside sqoop folder . This should resolve your issue. To check the library files invoked/used by the job , go to the job tracker for the corresponding job and in syslogs you will...