kaIeidoscopic opened a new issue, #22086:
URL: https://github.com/apache/superset/issues/22086
Hi team,
Thanks for this powerful tools, I'm using Superset-1.4.2 docker container on
kubernetes cluster. I used REST interface to connect the drill before but I
found some performance issues so I'm trying to connect Drill cluster using JDBC
URL.
I have installed jdk/JayDeBeApi/jPype into container.
when I try to create a database in Superset UI
URL:
```
drill+jdbc://<my host>:31010
```
Superset will throw JVM not started error.
I don't know where can I start JVM in Superset, so I try to add below code
before call engine.raw_connection()
```
if not jpype.isJVMStarted():
jpype.startJVM()
https://github.com/apache/superset/blob/master/superset/databases/commands/test_connection.py#L100
```
after this when I click TEST CONNECTION button on Superset, the first will
return 'connection looks good' but second time return
below error.
```
ERROR: (java.sql.java.sql.SQLException) java.sql.SQLExpection: Failure in
creating DrillConnectionImpl: java.lang.NullPointerException(Background on this
error at: http://sqlalche.me/e/13/dpapi)
```
I'm not sure if this is a bug or if I'm using it incorrectly, could you
please provide more details about how to connect Superset with Apahce Drill
using JDBC URL?
sqlalchemy-drill version: 1.1.2
Superset version: 1.4.2
JDBC driver : drill-jdbc-all-1.19.0.jar
Jpype version: 1.4.1
JayDeBeApi version: 1.2.3
Thank you
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
