question Re: How to connect hive LLAP via ODBC using http and uid /pwd? in Archives of Support Questions (Read Only)

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

rbiswas1 — Sat, 29 Jul 2017 00:51:50 GMT

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

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

gkeys — Sat, 29 Jul 2017 04:31:46 GMT

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

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

ssahi — Sat, 29 Jul 2017 04:34:41 GMT

hi @rbiswas

There are some configs and screens here:

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

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

rbiswas1 — Sat, 29 Jul 2017 04:40:45 GMT

yes Sir am sure.

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

rbiswas1 — Sat, 29 Jul 2017 04:42:09 GMT

Am trying to use http not sasl.

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

rbiswas1 — Sat, 29 Jul 2017 04:45:15 GMT

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

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

rbiswas1 — Wed, 02 Aug 2017 00:06:38 GMT

@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