Support Questions

Find answers, ask questions, and share your expertise
Announcements
Check out our newest addition to the community, the Cloudera Data Analytics (CDA) group hub.

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

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.

View solution in original post

3 REPLIES 3

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.

Super Collaborator

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

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

Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.