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. Added the Hive configuration.
   1. Create a Hive configuration file /opt/omni-operator/hive/conf/omni.conf on the cluster management node and all compute nodes.

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

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

      # <----Other properties---->
      enableBatchExprEvaluate=false
      # <----Hive properties---->
      EmptySearchStrReplaceRule=REPLACE
      CastDecimalToDoubleRule=CONVERT_WITH_STRING
      ZeroStartIndexSupportRule=IS_SUPPORT
      SupportContainerVecRule=SUPPORT
      StringToDateFormatRule=NOT_ALLOW_REDUCED_PRECISION
      NegativeStartIndexOutOfBoundsRule=EMPTY_STRING
      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:
   1. Open the file.

      vi $HIVE_HOME/conf/hive-site.xml

   2. Press i to enter the insert mode and add the following content to the file:

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

   3. Press Esc, type :wq!, and press Enter to save the file and exit.