Support Questions

Find answers, ask questions, and share your expertise

How to display Hive variable values in logging?

Super Collaborator

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!

1 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

View solution in original post

1 REPLY 1

@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
Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.