search

Azure / azure-sqldb-spark

This project provides a client library that allows Azure SQL DB or SQL Server to act as an input source or output sink for Spark jobs.
MIT License
76 stars 52 forks source link

facing issues while read data from sql using azure-sqldb-spark 1.0.2...please help #77

Closed krishjun20 closed 4 years ago

krishjun20 commented 4 years ago

Hi Team, Facing issues while connect to azure sql for read data using scala(maven platform)and used packages azure-sqldb-spark 1.0.2,adal4j 1.2.0 and mssql-jdbc 7.4.0.jre8 . Please heck below exception details... Please help. Code : val config = Config(Map( "url" -> "*.database.windows.net", "databaseName" -> "dbanme", "user" -> "userid", "password" -> "****", "queryCustom" -> query ))

  println(s"SQL Query: ${config.properties.get("queryCustom")}")
  resultDF = sparkSession.sqlContext.read.sqlDB(config)
  resultDF.show()
  )

Error: Exception in thread "main" java.lang.NoClassDefFoundError: com/microsoft/azure/sqldb/spark/config/Config$...

arvindshmicrosoft commented 4 years ago

Thank you for using the connector. Have you verified that the JAR is on the classpath? What Spark platform are you using (Databricks / HDInsight / something else)?

arvindshmicrosoft commented 4 years ago

Closing due to lack of response.