topic Apache Hive / AtScale. ODBC works, native connector fails in Connectivity & Data Prep

Apache Hive / AtScale. ODBC works, native connector fails

DavidFosterVF — Thu, 03 Nov 2022 09:20:05 GMT

I need help with connecting to Apache Hive / AtScale.

Using Windows Apache Hive ODBC Driver I am able to get a successful connection if I change the transport from HTTP to SASL. It took a lot of faff with the reverse proxy and SSL certificates, but it works.

When I try to replicate that connection using Qlik Sense's native Apache Hive connector I get an error (see attached).

Questions:

Can I get the Qlik connector to use a proxy?
Can I specify the Qlik connector to use SASL?

Re: Apache Hive / AtScale. ODBC works, native connector fails

Jay_Brown — Thu, 03 Nov 2022 12:27:46 GMT

Hello @DavidFosterVF ,

Lots of questions here but could you try to add some parameters:
name: ThriftTransport, Value: 1
name: HTTPPath, Value: gateway/default/hive

Those are according this documentation from Simba:

https://www.simba.com/products/Hive/doc/ODBC_InstallGuide/win/content/odbc/hi/options/ui/thrifttransport.htm
simba.com

Binary (0)
SASL (1)
HTTP (2)

Best,

Re: Apache Hive / AtScale. ODBC works, native connector fails

DavidFosterVF — Fri, 04 Nov 2022 14:40:24 GMT

Great thanks

Re: Apache Hive / AtScale. ODBC works, native connector fails

DavidFosterVF — Fri, 04 Nov 2022 14:49:53 GMT

@Jay_Brown there does not seem to be a keyword for using a proxy. Any ideas

Re: Apache Hive / AtScale. ODBC works, native connector fails

Jay_Brown — Fri, 04 Nov 2022 17:10:00 GMT

David, unfortunately there is not much info on this. Have you tried things such as Proxy_Host/ProxyHost?

For our other drivers we have similar driver custom parameters available: UseProxy, ProxyHost, ProxyPort, ProxyUID, ProxyPWD; However, information is very limited unfortunately and I don't have an instance with this config to test against.

If you check within the connectors folder, Default location:
C:\Program Files\Common Files\Qlik\Custom Data\QvOdbcConnectorPackage\hive\lib
you can see that the driver is developed by Simba, so you may want to check the Simba community to see if there are passable parameters other than what I've posted.

Re: Apache Hive / AtScale. ODBC works, native connector fails

DavidFosterVF — Wed, 09 Nov 2022 08:57:15 GMT

@Jay_Brown

These instructions seem to have worked for the proxy.

Configure Simba ODBC driver with a proxy in Windows - Databricks

i have been able to successfully connect and retrieve data.

Thanks for your help.

Re: Apache Hive / AtScale. ODBC works, native connector fails

Jay_Brown — Wed, 09 Nov 2022 13:07:53 GMT

That's fantastic @DavidFosterVF !

This information will definitely help others in the future and thank you for sharing the final configuration needed!