Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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:
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:
0
)1
)2
)Best,
J
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:
0
)1
)2
)Best,
J
Great thanks
@Jay_Brown there does not seem to be a keyword for using a proxy. Any ideas
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.
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.
That's fantastic @DavidFosterVF !
This information will definitely help others in the future and thank you for sharing the final configuration needed!