At this time, the JDBC Data source is not extensible so it cannot support SQL Server. There was some thoughts - credit to Cheng Lian for this - about making the JDBC data source extensible for third party support possibly via slick.
On Mon, Apr 6, 2015 at 10:41 PM bipin <bipin....@gmail.com> wrote: > 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 > >
