title: Spark 2.0.0 - No FileSystem for scheme: null error in IntelliJ SBT project
body: <p>After a recent upgrade to Spark 2.0 from Spark 1.6.1 one of my IntelliJ Idea Scala programs seem to be unable to run and exits with the message "No FileSystem for scheme: null error". I have googled the error but seem to get hdfs related errors and they seem unrelated to what I see.</p>
  
  <p>I did make code changes related to changes in Spark 2.0. The change was to rather use a SparkSession rather than SparkContext and SparkSQL. </p>
  
  <p>Find the code below:</p>
  
  <pre><code>import org.apache.spark.sql.SparkSession
  
  object PropertyInvestmentCalcs {
  def main(args: Array[String]) {
  
  val spark = SparkSession
    .builder()
    .appName("Spark PropertyInvestmentCalcs")
    .master("spark://ODROIDXU41:7077")
    .config("spark.sql.warehouse.dir", "\\\\SERVER\\Users\\USER\\MYDrive\\Programming\\IntelliJ\\PropertyInvestmentCalcs\\spark-warehouse")
  //val sqlContext = new org.apache.spark.sql.SparkSession(spark)
  
  // Get number of data records in the table
  val nrRecordsDF = spark.read.format("jdbc")
    .option("url", "jdbc:mysql://localhost:3306/test")
    .option("driver", "com.mysql.jdbc.Driver")
    .option("dbtable", "(SELECT COUNT(*) AS nrRecords FROM test.propertydb) AS nrRecords_tmp")
    .option("user", "user")
    .option("password", "password").load()
  nrRecordsDF.show()
  nrRecordsDF.printSchema()
  }
  }
  </code></pre>
  
  <p>Contents of my build.sbt file:
      import sbt._</p>
  
  <pre><code>name := "PropertyInvestmentCalcs"
  
  version := "0.1.0-SNAPSHOT"
  
  scalaVersion := "2.11.8"
  
  libraryDependencies += "org.apache.spark" %% "spark-core" % "2.0.0" //% "provided"
  libraryDependencies += "org.apache.spark" %% "spark-sql" % "2.0.0" //% "provided"
  libraryDependencies += "org.apache.spark" %% "spark-hive" % "2.0.0" //% "provided"
  libraryDependencies += "mysql" % "mysql-connector-java" % "5.1.39"
  
  lazy val commonSettings = Seq(
    version := "0.1-SNAPSHOT",
    organization := "TJVR",
    scalaVersion := "2.11.8"
  )
  
  lazy val app = (project in file("app")).
    settings(commonSettings: _*).
    settings(
  // your settings here
    )
  
  artifact in (Compile, assembly) := {
    val art = (artifact in (Compile, assembly)).value
    art.copy(`classifier` = Some("assembly"))
  }
  
  addArtifact(artifact in (Compile, assembly), assembly)
  </code></pre>
  
  <p>Contents of my plugins.sbt file:</p>
  
  <pre><code>logLevel := Level.Warn
  
  addSbtPlugin("com.eed3si9n" % "sbt-assembly" % "0.14.3")
  </code></pre>
  
  <p>Thanks in advance for any help.</p>