Hi, I am trying to pull data from ms-sql server. I have tried using the spark.sql.jdbc
CREATE TEMPORARY TABLE c USING org.apache.spark.sql.jdbc OPTIONS ( url "jdbc:sqlserver://10.1.0.12:1433\;databaseName=dbname\;", dbtable "Customer" ); But it shows java.sql.SQLException: No suitable driver found for jdbc:sqlserver I have jdbc drivers for mssql but i am not sure how to use them I provide the jars to the sql shell and then tried the following: CREATE TEMPORARY TABLE c USING com.microsoft.sqlserver.jdbc.SQLServerDriver OPTIONS ( url "jdbc:sqlserver://10.1.0.12:1433\;databaseName=dbname\;", dbtable "Customer" ); But this gives ERROR CliDriver: scala.MatchError: SQLServerDriver:4 (of class com.microsoft.sqlserver.jdbc.SQLServerDriver) Can anyone tell what is the proper way to connect to ms-sql server. Thanks -- View this message in context: http://apache-spark-user-list.1001560.n3.nabble.com/Microsoft-SQL-jdbc-support-from-spark-sql-tp22399.html Sent from the Apache Spark User List mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: user-unsubscr...@spark.apache.org For additional commands, e-mail: user-h...@spark.apache.org
