CODEWITHSUNDEEP
hadoophivehiveql
Eleanor
Eleanor

Reputation: 306

How can I check the settings in hive CLI?

I want to run a hive query in hive command and I want to make it faster, so I ran:

hive:messages> set mapred.job.priority = VERY_HIGH; hive:messages> set
hi = 1;

but I found actually I can set any string to be anything in hive so I wonder is there a way to check all the settings I have made?

Upvotes: 6

Views: 18007

Answers (1)

franklinsijo
franklinsijo

Reputation: 18270

To list all the settings available in the current Hive session,

hive> SET;

This will list all the

  • System Variables
  • Environment Variables
  • Hadoop, Hive Configurations (User defined and Default properties)
  • Hive Variables set using set, define, hivevar.

It is not possible to filter only a specific set of variables. But to get the value of a particular configuration/variable, use the configuration name as the argument to SET

hive> SET zzzz=123;
hive> SET zzzz;
zzzz=123;

Upvotes: 21

Related Questions