Search code examples
hivehive-configuration

Hive property not getting set

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.

Solution

  • 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