Connect Redash to Hiveserver2 via JDBC


#1

I have an issue to connect Redash to Hive2. Below are connection string, ID/PW ( Sensitive info masked on purpose) used in DBeavor, and I have no issue.

JDBCURL:
jdbc:hive2://XXX.com:443/ngc;transportMode=http;ssl=true;httpPath=sql/protocolv1/o/0/nXXX-explorer
Host:XXX.com
Port:443
Database:XXX
Username:
token
Password:
XXXXXX

When I try to create data source in Redash, I select “Hive”, but there is no data field I can put for password and so on. Does Redash work with Hive2 requiring authentication?

Thanks for help


#2

Hi,

You need to upgrade to Redash v6, where we have support both for Hive HTTP connections (like the one you use here) and Databricks directly.


#3

it works. Thanks a lot.