How to connect hive LLAP via ODBC using http and uid /pwd?

[#1]

Have you managed to connect hive LLAP via ODBC using http and uid /pwd?

If yes, can you provide the option you laid on the http path in the http properties?

Using 'cliservice' passes the connection test but it eventually fails with the below error when using the odbc in power bi since LLAp does not support cli.

DataSource.Error: ODBC: ERROR [HY000][Hortonworks][Hardy]

(35)Errorfrom server: error code:'0' error message:

'MetaException(message:java.lang.NullPointerException)'.

Details:

DataSourceKind=Odbc

DataSourcePath=dsn=Hive_DSN

OdbcErrors=Table

Connecting to hiveserver2 works in the above-mentioned way

Thanks

[#2]

Just want to be sure you are using port 10500. LLAP and non-LLAP each have their own HiveServer2 (ports 10500 and 10000, respectively.

[#3]

yes Sir am sure.

[#4]

++ non-LLAP works fine with the same setup just different port. Will keep posted.

[#5]

hi @rbiswas

There are some configs and screens here:

https://hortonworks.com/tutorial/interactive-sql-on-hadoop-with-hive-llap/

[#6]

Am trying to use http not sasl.

[#7 · Accepted solution]

@Sonu Sahi and @Greg Keys

There is a bug in Hortonworks > ODBC 2.1.5 This is fixed and will be part of HDP 3.0

As an interim, we can use ODBC driver v2.1.2 from the archive section under HDP 2.4.

Thanks