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

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.

it works. Thanks a lot.

Can you change how to configure it,