Link to home
Start Free TrialLog in
Avatar of kshathrya
kshathrya

asked on

Teradata JDBC Driver issue when using sqoop

Trying to use sqoop to pull data from teradata to put in hive.
the drivers are put in the following locations: (not sure if this is an issue and its expected in a diff location like /usr/lib

Driver Location:
/opt/teradata/stage/TeraJDBC
/opt/teradata/stage/TeraJDBC/tdgssconfig.jar
/opt/teradata/stage/TeraJDBC/terajdbc4.jar
/opt/teradata/client/16.20/tbuild/jar/teradata-connector-1.4.4.jar

 tried multiple ways but no success:

sqoop eval --driver com.teradata.jdbc.TeraDriver --connect jdbc:teradata://xxx.xx.xxx.com/database=dxx --username xxxx --password xxxxx--query "SELECT * FROM xxxx.xx"

sqoop eval -libjars /opt/teradata/client/16.20/tbuild/jar/teradata-connector-1.4.4.jar --driver com.teradata.jdbc.TeraDriver --connect jdbc:teradata://xxx.xx.xxx.com/database=dxx ----username xxxx --password xxxxx--query "SELECT * FROM xxxx.xx"

what is the command I should use and what am I doing wrong?

tried exporting the paths as well:

export TDCHJAR=/opt/teradata/client/16.20/tbuild/jar/teradata-connector-1.4.4.jar:$TDCHJAR
export TDCHJARS=$TDCHJAR,/opt/teradata/stage/TeraJDBC/tdgssconfig.jar,/opt/teradata/stage/TeraJDBC/terajdbc4.jar:$TDCHJARS
This question needs an answer!
Become an EE member today
7 DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.