> > I have never used Hive, so I'll have to investigate further.
To clarify, I wasn't recommending you use Apache Hive, but instead the HiveContext <http://spark.apache.org/docs/latest/sql-programming-guide.html#getting-started> provided by Spark SQL. This will allow you to create views in a hive metastore (which will be created automatically unless configured otherwise).