title: Spark SQL: set avro Schema option using SQL API
body: <p>I'm trying to read <strong>Avro</strong> data from <strong>Spark SQL</strong> using <strong>SQL API</strong>.</p>
  
  <p>Example:</p>
  
  <pre><code>CREATE TEMPORARY TABLE episodes
  USING com.databricks.spark.avro
  OPTIONS (path "/tmp/episodes.avro")
  </code></pre>
  
  <p>Is it possible to set avroSchema (<strong>.avsc</strong> file) option like in Scala API?</p>
  
  <p>Example:</p>
  
  <pre><code>spark
    .read
    .format("com.databricks.spark.avro")
    .option("avroSchema", new Schema.Parser().parse(new File("user.avsc")).toString)
    .load("/tmp/episodes.avro").show()
  </code></pre>