Hi,

I am trying to connect to Teradata from spark and getting below error for
not finding suitable drivers.

: java.sql.SQLException: No suitable driver found for jdbc:teradata://XXXXXX


I have tried adding jar files using %dep, as well as in zeppelin-env.sh
setting up SPARK_CLASSPATH variable but instead of adding under classpaths,
it adds under spark.driver.extraClassPath.
SPARK_CLASSPATH=/...path/terajdbc4.jar:/..path/tdgssconfig.jar


Below is code I tried from Z :

%pyspark
df = sqlContext.load(source="jdbc", url="jdbc:teradata://XXXXX,
user=XXXXXX, password=XXXXXXX", dbtable="XXXXXXX")

I have tried from shell adding the driver and connecting from there and it
worked like charm.

Thanks in advance!

-Dhaval

Reply via email to