Support Questions
Find answers, ask questions, and share your expertise

Parameters in Impala?

Parameters in Impala?

Explorer

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 :)

 

 

3 REPLIES 3

Re: Parameters in Impala?

Champion

Re: Parameters in Impala?

Explorer

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?

Re: Parameters in Impala?

New Contributor

Meltem_0-1607533963522.png

 

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.