Support Questions

Find answers, ask questions, and share your expertise

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