I am having the same issue with my java application.
String url = "jdbc:sqlserver://" + host + ":1433;DatabaseName=" +
database + ";integratedSecurity=true";
String driver = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
SparkConf conf = new
SparkConf().setAppName(appName).setMaster(master);
JavaSparkContext sc = new JavaSparkContext(conf);
SQLContext sqlContext = new SQLContext(sc);
Map<String, String> options = new HashMap<>();
options.put("driver", driver);
options.put("url", url);
options.put("dbtable", "tbTableName");
DataFrame jdbcDF = sqlContext.load("jdbc", options);
jdbcDF.printSchema();
jdbcDF.show();
It prints the schema of the DataFrame just fine, but as soon as it tries to
evaluate it for the show() call, I get a ClassNotFoundException for the
driver. But the driver is definitely included as a dependency, so is MS SQL
Server just not supported?
--
View this message in context:
http://apache-spark-user-list.1001560.n3.nabble.com/Microsoft-SQL-jdbc-support-from-spark-sql-tp22399p22404.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
