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#LanguageManualVariableSubstitution-UsingVariables https://community.hortonworks.com/articles/60309/working-with-variables-in-hive-hive-shell-and-beel.html
... View more
