As detailed in the documentation, Spark SQL comes with different connectors. Here we will just show with Livy.
Apache Livy provides a bridge to a running Spark interpreter so that SQL, pyspark and scala snippets can be executed interactively.
In the hue.ini configure the API url:
[spark]
# The Livy Server URL.
livy_server_url=http://localhost:8998
And as always, make sure you have an interpreter configured:
[notebook]
[[interpreters]]
[[[sparksql]]]
name=Spark SQL
interface=livy
And that's it, the editor will appear:
One advantage of using Hue is its File Browser for HDFS / S3 / Azure and full security.