Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

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

Solved Go to solution

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

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

Accepted Solutions
Highlighted

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

@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
Highlighted

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

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.

Highlighted

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

yes Sir am sure.

Highlighted

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

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

Highlighted

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

Guru
Highlighted

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

Am trying to use http not sasl.

Highlighted

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

@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

Don't have an account?
Coming from Hortonworks? Activate your account here