question Impala - set statement forever in Archives of Support Questions (Read Only)

Impala - set statement forever

AlinaGHERMAN — Fri, 16 Sep 2022 10:08:56 GMT

ello,

I would like to set the folowing to true for all my impala queries:

set APPX_COUNT_DISTINCT=true;

and I can't find any way to do it...

I need this, because I have some impala queries that I send over the Impala JDBC Driver and that I would like to optimize.

Thank you!

Alina

Lars Volker — Mon, 14 Mar 2016 16:52:11 GMT

Hi Alina,

you can specify query options by appending them to the connection string for the JDBC driver, separated by semicolon. For example

jdbc:impala://me.cloudera.com:21050/default;appx_count_distinct=1

Settings you add there will be active for all queries during that JDBC connection. If you want to change defaults for the impalad daemon lifetime you can do so by adjusting IMPALA_SERVER_ARGS as described here: http://www.cloudera.com/documentation/enterprise/5-4-x/topics/impala_config_options.html

Cheers, Lars