I have Apache Superset installed via Docker on my local machine. I have a separate production 20 Node Spark cluster with Hive as the Meta-Store. I want my SuperSet to be able to connect to Hive and run queries via Spark-SQL.
For connecting to Hive, I tried the following

\*\*Add Database --> SQLAlchemy URI \*\*\*

`hive://hive@<hostname>:10000/default`

but it is giving some error when I test connection. I believe I have to do some tunneling, but I am not sure how.

I have the Hive thrift server as well.

Please let me know how to proceed.