Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

how to view hive cli settings

avatar
Super Collaborator

there are many parameters that we can set for a hive session like some shown below.

how can I see what currently is set in my hive session ?

set tez.grouping.split-count=4;
set hive.enforce.bucketing = true;
set hive.exec.dynamic.partition.mode = nonstrict;
3 REPLIES 3

avatar
Super Collaborator

ok I found out that just typing "set" gives all the settings but its huge , any filters I can use with the "set" command?

avatar
Expert Contributor

To see all values of a session in

1)HS2

beeline --outputformat=tsv2 -u '<HS2_JDBC_URL> -e 'set -v' > session.txt 

2) Cli

hive --outputformat=tsv2 -e 'set -v' > session.txt 

If specific key to be searched, then after launching beeline or cli, use the specific keys as below

beeline> set hive.exec.dynamic.partition.mode;

If my suggestion helped to resolve your query, accept the answer. It might help others in the community.

avatar
Super Guru

@Sami Ahmad,

You can run the below command

set;

For ex: If you want to check the params that are set to true, then you can run

hive -e 'set;' | grep true

.

-Aditya