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/TeraJD BC
/opt/teradata/stage/TeraJD BC/tdgssco nfig.jar
/opt/teradata/stage/TeraJD BC/terajdb c4.jar
/opt/teradata/client/16.20 /tbuild/ja r/teradata -connector -1.4.4.jar
tried multiple ways but no success:
sqoop eval --driver com.teradata.jdbc.TeraDriv er --connect jdbc:teradata://xxx.xx.xxx .com/datab ase=dxx --username xxxx --password xxxxx--query "SELECT * FROM xxxx.xx"
sqoop eval -libjars /opt/teradata/client/16.20 /tbuild/ja r/teradata -connector -1.4.4.jar --driver com.teradata.jdbc.TeraDriv er --connect jdbc:teradata://xxx.xx.xxx .com/datab ase=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/clie nt/16.20/t build/jar/ teradata-c onnector-1 .4.4.jar:$ TDCHJAR
export TDCHJARS=$TDCHJAR,/opt/ter adata/stag e/TeraJDBC /tdgssconf ig.jar,/op t/teradata /stage/Ter aJDBC/tera jdbc4.jar: $TDCHJARS
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/TeraJD
/opt/teradata/stage/TeraJD
/opt/teradata/stage/TeraJD
/opt/teradata/client/16.20
tried multiple ways but no success:
sqoop eval --driver com.teradata.jdbc.TeraDriv
sqoop eval -libjars /opt/teradata/client/16.20
what is the command I should use and what am I doing wrong?
tried exporting the paths as well:
export TDCHJAR=/opt/teradata/clie
export TDCHJARS=$TDCHJAR,/opt/ter
This question needs an answer!
Become an EE member today
7 DAY FREE TRIALMembers 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.