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.

impala connection issue

Highlighted

impala connection issue

Explorer

There is a connection issue between MSTR (BI Tool) and imapala. 

 

FAILED!

[Cloudera][DriverSupport] (1110) Unexpected response received from server. Please ensure the server host and port specified for the connection are correct and confirm if SSL should be enabled for the connection.

 

Any suggestions?

 

5 REPLIES 5
Highlighted

Re: impala connection issue

Cloudera Employee

Several reasons can cause this error.  Check your ODBC settings and application/ODBC driver versions. For example, if one side is keberized/SSL enabled but another side isn't, or a 32bit application runs against 64bit ODBC driver, you can see this kind of error. If all look good, you need to check Impala ODBC Driver logs to find more details.

Highlighted

Re: impala connection issue

Explorer

Thanks will look into it.

 

There are sql failures on Monday's and Wednesday's afternoon. Because  of lot of MSTR (BI Tool) subscriptions are sent to impala and few of them fail. Can you tell me how to fix this issue.

Let me know what all information you need?

 

 

Highlighted

Re: impala connection issue

Cloudera Employee

Usually, I would inspect the profiles of failed queries to get rough ideas, then determine which logs I should check next. If you have a contract with Cloudera, it's worth to file a ticket. Cloudera Support will help you troubleshoot step by step.

Highlighted

Re: impala connection issue

Explorer

I cannot create a ticket as I do not have permission.

Is there any way I can reach out to support?

 

Thanks

Highlighted

Re: impala connection issue

Cloudera Employee

If you have a support contract with Cloudera, you can contact us via details at the following link under ‘How can I contact support?’ and we will be happy to assist:
https://my.cloudera.com/faq.html#support

If you do not yet have a support contract with Cloudera, you would need to first speak with a sales representative in order to contract with support via the following link:
https://www.cloudera.com/contact-sales.html

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