What is the hive command to see the value of hive.exec.dynamic.partition

Question

We know that set command is used to set some values for properties

 hive> SET hive.exec.dynamic.partition=true;
 hive> SET hive.exec.dynamic.partition.mode=non-strict;

But how do we read the current value of above property

I tried the below commands, its not working

 get hive.exec.dynamic.partition
 show hive.exec.dynamic.partition

Could someone help on getting the correct hive command to read the current value of those above properties .

leftjoin · Accepted Answer · 2019-03-20T18:40:13.617

23

The same SET command but without value assignment will print current value:

hive> SET hive.exec.dynamic.partition;

Output:

hive.exec.dynamic.partition=true

SET command without variable prints a list of configuration variables that are overridden.

See the documentation on Hive CLI and Beeline

edited Mar 20 '19 at 18:40

answered Aug 02 '16 at 08:23

leftjoin

score 0 · Answer 2 · answered Aug 02 '16 at 14:14

To check property: hive.exec.dynamic.partition

Run below command SET hive.exec.dynamic.partition; SET hive.exec.dynamic.partition.mode;

2 Answers2