Apache Superset with Apache Hive Connection

[soumilshah1995]

As you can see I a connected to my HIVE through thrift server which is running locally

Error

[soumilshah1995]

Any Updates ?

[soumilshah1995]

Any Updates ?

[soumilshah1995]

Any updates

[soumilshah1995]

Hello Any updates

[NicolasPA]

Did you install the database driver as recommended in the doc? https://superset.apache.org/docs/databases/installing-database-drivers For Hive, I recommend using impyla instead of pyhive because the later is not maintained anymore. I'm running Superset in Docker with impyla and connecting to Hive in Docker through a Docker network, on WSL2.

Dockerfile to include the driver in the Superset image:

FROM apache/superset:3.1.1
USER root
# Driver for Hive
RUN pip install impyla

Creating the network:

docker network create hive_network
docker network connect hive_network hiveserver2
docker network connect hive_network superset_hive

Thanks to the Docker network, Hive is now accessible from host name hiveserver2.

So my SQL Alchemy URI is: hive://hiveserver2:10000/default

[bkyryliuk]

I have it working with hive in our settings, connection string looks like:

hive://user@host:port/db

We are leveraging latest pyhive. Also just FYI: pyhive was donated to apache kyuubi for the further maintanance and development: https://lists.apache.org/thread/jtqk3m0x201vfbn6992s4cb17qp4mzvo

[bkyryliuk]

Please provide a way to reproduce the issue and share what superset version is experiencing it. Closing the ticket for now.