Is it possible to communicate with spark sql shell via jdbc from sql client UI?

Question

Apache Spark

There is conflicting information online. I want to set up a connection to a Spark session, v2.2, from any IDE, send requests, receive a response in the form of a dataset, as with any relational database.
You can easily connect to Hive, but does spark have such functionality? They write that this is possible through the thrift server, and using the standard hive2 jdbc, but I did not succeed.
Of particular interest is whether authorization in kerberos affects this.

Answer 1

https://spark.apache.org/docs/latest/sql-distribut...
https://cwiki.apache.org/confluence/plugins/servle...