Jdbc:hive// for older Hive like(in) SparkSQL Driver


#1

Hey guys

I found that Metabase provides a driver for connecting to SparkSQL databases,
But unfortunately, this SparkSQL driver doesn’t work with my hiveserver.
logs like this:

12-19 09:11:57 DEBUG metabase.middleware :: POST /api/database 400 (5 s) (0 DB calls).
{:valid false, :dbname “Timed out after 5000 milliseconds.”, :message “Timed out after 5000 milliseconds.”}
12-19 09:13:08 ERROR metabase.driver :: Failed to connect to database: java.sql.SQLException: Could not open client transport with JDBC Uri: jdbc:hive2://172.0.0.11:8080/test: Invalid status 72

i have seen many of these discussions and issues on github,






… … …
but never have the solution for supporting the jdbc://hive(not 2),
I supposed that only jdbc:hive but not jdbc:hive2 would be worked.
so maybe the root cause is “org.apache.hive.jdbc”,
im new in Clojure and failed to rebuild spark deps,
how can i use “org.apache.hadoop.hive.jdbc” instead?
or can we build a new plugin for older hive,
or support two kind of protocol on the same driver like this:
QQ%E6%88%AA%E5%9B%BE20181219183209

any idea of this?
thx a lot!


#2

Anybody here~?:disappointed_relieved: