Reply
Highlighted
Master
Posts: 377
Registered: ‎07-01-2015
Accepted Solution

Impala unsupported set commands

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

 

Cloudera Employee
Posts: 370
Registered: ‎07-29-2015

Re: Impala unsupported set commands

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.
Expert Contributor
Posts: 338
Registered: ‎01-25-2017

Re: Impala unsupported set commands

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

Master
Posts: 377
Registered: ‎07-01-2015

Re: Impala unsupported set commands

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

Thanks

Announcements