I am setting the following property in hive-site.xml:
<property>
<name>hive.exec.dynamic.partition.mode</name>
<value>nonstrict</value>
</property>
However in hive console if I run, show conf "hive.exec.dynamic.partition.mode";, I get strict
Does anybody have any clues as to why my configuration properties in hive-site.xml are not overriding the default properties? Further, I also tried to set this property from the console by using the set command, but with no luck there either.
I think that is happening why SHOW CONF doesn't show the current property's values that command show the default value.
Check this documentation
https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-ShowConf
Regards