Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here. Want to know more about what has changed? Check out the Community News blog.

Add a dynamic variable to a Hive view

Add a dynamic variable to a Hive view

New Contributor

I would like to create a Hive view that would would include a dynamic variable that would give different output depending on what was done using the set command

 

The following doesn't work.

 

create view default.view_mikeg_test as
select * from prod_integration.dim_company where company_code = ${hiveconf:company_code};

 

This produces an error and will only work if I set the variable company_code first (i.e. set company_code = '7777') and then that value gets imbedded into the view.  That's not what I want.  I have tried to use single and double quotes around ${hiveconf:company_code} as suggested in other forums.  There has to be a simple solution to this.

 

1 REPLY 1

Re: Add a dynamic variable to a Hive view

Guru
I don't think this is supported at the moment.