"Unable to create serializer 'org.apache.hive.com.esotericsoftware.kryo.serializers.FieldSerializer' for class: com.huawei.boostkit.hive.OmniGroupByOperator" Is Reported When Hive 3.1.0 Runs SQL Statements That Contain the GroupBy Operator
Symptom
When some SQL statements contain the GroupBy operator, Hive OmniOperator reports the error "Unable to create serializer 'org.apache.hive.com.esotericsoftware.kryo.serializers.FieldSerializer' for class: com.huawei.boostkit.hive.OmniGroupByOperator."
Key Process and Cause Analysis
This problem may also occur when open-source SQL statements are executed in Hive. A related issue is Kryo ISSUE. This problem is caused by a Kryo bug and can be solved by using a later version of Kryo. This problem has been eliminated in Hive 4.0.
Conclusion and Solution
In the POM file of the Hive project, change the Kryo version to 4.0.0, recompile the package, and use it to replace the hive-exec-3.1.0.jar package in the lib directory of the Hive installation directory. You can also replace the hive-exec-3.1.0.jar package with a compiled Hive JAR package.