> > BTY, spark-avro works great for our experience, but still, some non-tech > people just want to use as a SQL shell in spark, like HIVE-CLI. >
To clarify: you can still use the spark-avro library with pure SQL. Just use the CREATE TABLE ... USING com.databricks.spark.avro OPTIONS (path '...') syntax.