Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Parameters in Impala?

avatar
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

avatar
Champion

avatar
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?

avatar
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.