How to display Hive variable values in logging?

[#1]

Suppose I have a Hive query like this:

insert into table my_table

select 1, ${hiveconf:my_variable}

from some_other_table;

Is there a config setting so that the value of "my_variable" will be displayed in the logging or in the verbose output of the query?

All I ever see is "${hiveconf:my_variable}".

Thanks!

[#2 · Accepted solution]

@Zack Riesland

As far as I know there is no such config property. You may have to write additional lines in your hive script to view the values/redirect them to a separate file.

You can view the value using

select ${hiveconf.my_variable};

To see values of all the variables you may use

set -v