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? ... View more

I am trying to figure out a tool for querying spark SQL queries and provides features like Hue (user authentication , Download result and restrictions to access tables) Zeppelin and Jupyter are more like a notebooks and doesn't have features like user authentication and download result feature. Any suggestions around this ? Thanks in advance. ... View more