question Re: How to display Hive variable values in logging? in Archives of Support Questions (Read Only)

How to display Hive variable values in logging?

zack_riesland — Tue, 11 Jul 2017 17:29:36 GMT

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!

Re: How to display Hive variable values in logging?

dineshc — Tue, 11 Jul 2017 22:46:06 GMT

@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