Parameters in Impala?

[#1]

Hello,

I was wondering if it's possible to pass parameter in to Impala, for exemple like this Hive script:

set TABLE_NAME = cc_activitydocument ;

drop table ${hiveconf:TABLE_NAME};
drop table ${hiveconf:TABLE_NAME}_str;
drop table ${hiveconf:TABLE_NAME}_history;
drop table ${hiveconf:TABLE_NAME}_history_str;

i'm not finding any documentation how to translate that into Impala?

Thanks 🙂

[#2]

@Broche

Please refer the below link, it may help you

https://www.cloudera.com/documentation/enterprise/5-8-x/topics/impala_set.html

[#3]

Hello, thanks i was able to do it in shell.

However i'm not able to do it from Hue or Dbeaver. Any workaround for that?

[#4]

Hi @Broche you can use this script.(for hue)

For id column, 2 is default value. You don't have to define default value, its optional.