Support Questions

Find answers, ask questions, and share your expertise

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

avatar

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

1 ACCEPTED SOLUTION

avatar

@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

View solution in original post

6 REPLIES 6

avatar
Guru

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

avatar

yes Sir am sure.

avatar

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

avatar
Guru

avatar

Am trying to use http not sasl.

avatar

@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