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.
- 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.
- Open /opt/omni-operator/hive/conf/omni.conf.
vi /opt/omni-operator/hive/conf/omni.conf
- 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
- Press Esc, type :wq!, and press Enter to save the file and exit.
- Open /opt/omni-operator/hive/conf/omni.conf.
- Add the following content to the $HIVE_HOME/conf/hive-site.xml file on the management node:
- Open the file.
vi $HIVE_HOME/conf/hive-site.xml
- 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> - Press Esc, type :wq!, and press Enter to save the file and exit.
- Open the file.
Parent topic: Using on Hive