Support Questions

Find answers, ask questions, and share your expertise
Check out our newest addition to the community, the Cloudera Data Analytics (CDA) group hub.

how to view hive cli settings

Master 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;

Master 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?

Expert Contributor

To see all values of a session in


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.

@Sami Ahmad,

You can run the below command


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

hive -e 'set;' | grep true



Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.