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.

how to find conf ${hiveconf:} value or conf file for hive tables?

Solved Go to solution

how to find conf ${hiveconf:} value or conf file for hive tables?

Rising Star

Hi team i have hql query for data insertion INSERT OVERWRITE TABLE ${hiveconf:TB_MASTER} .

i am aware hiveconf:TB_MASTER is variable but i am not aware where i can get variable value for TB_MASTER, can you help me to possibilities to find value?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

Re: how to find conf ${hiveconf:} value or conf file for hive tables?

Guru

hi @rama

Typically, the variable would be defined somewhere earlier in the script that contains the query, or in the CLI, with a SET statement. Something like: SET TB_MASTER=table_name;

If you don't see where it was defined, then you would most likely be guessing from the total databases and tables within your system. If the system is very small, that might be feasible. You can use the "show databases" command to list the databases. If you see one that makes sense, you can issue a "use <database_name>" command and then issue a "show tables" to view the list of table names that exist within that Hive database.

Here are some links on Hive variables and how they work.

https://cwiki.apache.org/confluence/display/Hive/LanguageManual+VariableSubstitution#LanguageManualV...

https://community.hortonworks.com/articles/60309/working-with-variables-in-hive-hive-shell-and-beel....

View solution in original post

1 REPLY 1
Highlighted

Re: how to find conf ${hiveconf:} value or conf file for hive tables?

Guru

hi @rama

Typically, the variable would be defined somewhere earlier in the script that contains the query, or in the CLI, with a SET statement. Something like: SET TB_MASTER=table_name;

If you don't see where it was defined, then you would most likely be guessing from the total databases and tables within your system. If the system is very small, that might be feasible. You can use the "show databases" command to list the databases. If you see one that makes sense, you can issue a "use <database_name>" command and then issue a "show tables" to view the list of table names that exist within that Hive database.

Here are some links on Hive variables and how they work.

https://cwiki.apache.org/confluence/display/Hive/LanguageManual+VariableSubstitution#LanguageManualV...

https://community.hortonworks.com/articles/60309/working-with-variables-in-hive-hive-shell-and-beel....

View solution in original post

Don't have an account?
Coming from Hortonworks? Activate your account here