db= spark.read.format(“jdbc”).option(“url”,”host”).option(“user”,”username”).option(“password”,”mypass”).option(“dbtable”,”emp”).option(“driver”,”com.mysql.jdbc.Driver”).load()
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File “C:sparkspark-3.5.1-bin-hadoop3pythonlibpyspark.zippysparksqlreadwriter.py”, line 314, in load
File “C:sparkspark-3.5.1-bin-hadoop3pythonlibpy4j-0.10.9.7-src.zippy4jjava_gateway.py”, line 1322, in call
File “C:sparkspark-3.5.1-bin-hadoop3pythonlibpyspark.zippysparkerrorsexceptionscaptured.py”, line 185, in deco
pyspark.errors.exceptions.captured.IllegalArgumentException: requirement failed: The driver could not open a JDBC connection. Check the URL: host
hw to resolve this error
S_R_Ws is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.