<Sigh>  That did not work for me.  However, someone did suggest just that in this thread I started for Dbeaver: https://github.com/dbeaver/dbeaver/issues/4240.  They were using a password, though.   Just to be absolutely clear, you are using AuthMech=3;UseSasl=0 but no PWD, right?   @xfly, do you have any luck with this syntax? ... View more

You are not using the AuthMech parameter at all.  Perhaps you are not exactly doing what this thread is discussing.  According to the manual, AuthMech should be required.  Regardless, for my use case with Dbeaver I can say for sure that without AuthMech I am not able to connect.   So, one more time...Has anyone successfully connected using AuthMech=2, as described in the manual? ... View more

Can you post you connection string? ... View more

It seems like this thread still has no resolution.  I was inclined to give the benefit of the doubt to Cloudera and assume this was a DBeaver issue but it seems other people using straight Java cannot get a working connection string either.    It would be great if we could get a cloudera employee to have another look at this thread.  In particular, Dbeaver is an outstanding DB client and I was using it with great success before I started using authentication.  It is a real shame to have lost it.   Can anyone successfully use the connection string from the manual (username, no password)? ... View more

I cannot get it to work either.  I am trying to use the connection string within the DBbeaver database client and it just hangs forever. ... View more

AuthMech=6?  I don't see that in the manual as an option.  Can you please post your full connection string?  Thanks ... View more

Interestingly, though many people in this thread are complaining of the same issue, no one has posted an error message that shows the correct syntax as outlined by the manual in the link from @Lars Volker.   Specifically, the manual shows the syntax for the connection string with a username (and no password) should be using AuthMech=2:   jdbc:impala://node1.example.com:21050;AuthMech=2;UID=impala At least for me, this "resolved" the issue because now I am trying to debug a connection timeout.  So I guess that is progress 😕 ... View more

Thank you, @Lars Volker.   Definitely learned something new there! ... View more

Thank you @GeKas and @Lars Volker.   This has been incredibly helpful to know that it is a documented bug and, further, that patching the bug will resolve the issue.   As @GeKas pointed out, I too find it confusing that redirecting standard output triggers the python bug.  At the point that stdout is being directed, isn't python out of the picture?  Yet it triggers the same bug as if python had been used to write to the file.   In my case, I am trying to pipe the result to a hadoop process.  What is strange is that I am almost certain that the script is using the -B flag, in which case I shouldn't be affected by this bug at all.  I am going to investigate today.    Thanks again for all your help.  This has been a really, really good experience on the Cloudera forum 🙂 ... View more