Forum Discussion

manojkumarvohra's avatar
manojkumarvohra
New Member
9 years ago
Solved

Impala kerberos Direct Query

Hi,

 

We are trying to establish a direct connection with our Impala server.

 

We have initailised our Kerberos TGT on windows.

 

We tried connecting with our deamonhost:21050 but its giving below error:

[Microsoft][ThriftExtension] (5) Error occurred while contacting server: No more data to read.. This could be because you are trying to establish a non-SSL connection to a SSL-enabled server.

 

Can you please guide what could be the issue here?

We have not enabled SSL on our server.

 

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi manojkumarvohra,

    Based on this official article,  Anonymous and UserName/Password credentials  are supported when connecting to Impala server in Power BI Desktop. 

    Kerberos authentication is not supported yet, an idea about this issue has been submitted in the following link, please vote it up to get this feature prioritized. In your scenario, please use Anonymous or UserName/Password credential to connect to Impala server on DirectQuery mode, and check if it is successful.

    https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/15949948-support-kerberos-authentication-for-impala-connect

    Thanks,
    Lydia Zhang

  • nottp106's avatar
    nottp106
    New Member
    8 years ago

    Hi, I'm found same problem now. I use impala connect to hadoop via power bi. Please advice me thank you.

     

     

  • fabiothomaz's avatar
    fabiothomaz
    New Member
    8 years ago

    While the support for DirectQuery in a Kerberos enabled environment isn't released, you can configure your Impala service to authenticate with LDAP.
    The impala service will use the authenticated LDAP user for authorization (sentry) and the impala service principal to access the cluster resources.
    With this configuration, we're able to use PBI DirectQuery + Impala + Kerberos.

    You can find more about Impala LDAP authentication at:
    https://www.cloudera.com/documentation/enterprise/latest/topics/impala_ldap.html

    Regards,
    Fabio Thomaz