Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

how to view hive cli settings

Highlighted

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;
3 REPLIES 3
Highlighted

Re: how to view hive cli settings

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?

Re: how to view hive cli settings

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.

Highlighted

Re: how to view hive cli settings

@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

Don't have an account?
Coming from Hortonworks? Activate your account here