Spark sql vs hive on spark

[#1]

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?

[#2 · Accepted solution]

@Sandeep Nemuri

Sandeep, Please see this http://www.slideshare.net/hortonworks/hive-on-spar...

[#3]

Also, very good blog

[#4]

Thanks @Neeraj Sabharwal, Deck has provided many insights.