question Re: Impala unsupported set commands in Archives of Support Questions (Read Only)

Impala unsupported set commands

Tomas79 — Fri, 16 Sep 2022 13:46:38 GMT

Hi,

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

One example:

SET AllowSelfSignedCert=1

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

Re: Impala unsupported set commands

Tim Armstrong — Thu, 04 Oct 2018 17:19:16 GMT

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

Fawze — Fri, 05 Oct 2018 06:14:33 GMT

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

Re: Impala unsupported set commands

Tomas79 — Fri, 05 Oct 2018 06:26:00 GMT

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

Thanks