Setting the Hive Configuration File

After installing Hive, you need to add the Hive configuration to the OmniOperator configuration file so that services can be executed.

1. Create the Hive configuration file directory /opt/omni-operator/hive. Add the Hive configurations to the /opt/omni-operator/hive/conf/omni.conf file on the management node and all compute nodes.
   1. Open /opt/omni-operator/hive/conf/omni.conf.

      vi /opt/omni-operator/hive/conf/omni.conf

   2. Press I to enter the insert mode and add the following Hive configurations (recommended).

      # <----Hive template---->
      RoundingRule=DOWN
      CheckReScaleRule=CHECK_RESCALE
      EmptySearchStrReplaceRule=REPLACE
      CastDecimalToDoubleRule=CONVERT_WITH_STRING
      ZeroStartIndexSupportRule=IS_SUPPORT
      SupportDecimalPrecisionImprovementRule=IS_SUPPORT

   3. Press Esc, type :wq!, and press Enter to save the file and exit.
2. Add the following content to the $HIVE_HOME/conf/hive-site.xml file on the management node:

   <property>
         <name>hive.optimize.index.filter</name>
         <value>false</value>
   </property>
   <property>
         <name>hive.execution.engine</name>
         <value>tez</value>
   </property>