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

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