Thanks for the information. Hopefully this will happen in near future. For now my best bet would be to export data and import it in spark sql.
On 7 April 2015 at 11:28, Denny Lee <denny.g....@gmail.com> wrote: > 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 >> >>
