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 unsupported set commands

Solved Go to solution

Impala unsupported set commands

Master Collaborator

Hi,

 I noticed that SET queries generated by a third party app on the Impala cluster are constantly failing. 

One example:

 

SET AllowSelfSignedCert=1

 

impala_set_fail.PNG

 

Is this something related to the Impala JDBC driver or are these coming from the application using this JDBC?

Can I somehow turn off this annoying SET command?

Thanks

 

Version: CDH5.15, Impala using TLS

 

1 ACCEPTED SOLUTION

Accepted Solutions

Re: Impala unsupported set commands

Master Collaborator
It might be an application incorrectly trying to set the SIMBA driver option by SQL (which won't work). AFAIK the Simba JDBC driver won't do this itself.
3 REPLIES 3

Re: Impala unsupported set commands

Master Collaborator
It might be an application incorrectly trying to set the SIMBA driver option by SQL (which won't work). AFAIK the Simba JDBC driver won't do this itself.

Re: Impala unsupported set commands

Super Collaborator

@Tomas79 Does your 3rd party support running 2 commands or SQL in the same file/document?

Re: Impala unsupported set commands

Master Collaborator

I have figured out that this is coming from the third party tool, so it has nothing to do with the Simba driver. 

Thanks