title: SparkSQL vs Hive on Spark - Difference and pros and cons?
body: <p>SparkSQL CLI internally uses HiveQL and in case Hive on spark(HIVE-7292) , hive uses spark as backend engine. Can somebody throw some more light, how exactly these two scenarios are different and pros and cons of both approaches?</p>