Currently, we are hive version 2.3.7 in google cloud. And my jobs are failing intermittently once in a week with above error, As a workaround, we are restarting the hive megastore , curious as to know why this issue occurs in this version and how to fix the issue permanently.
Error log :-
java.sql.SQLException: org.apache.hive.service.cli.HiveSQLException: Error while processing statement: FAILED: Execution Error, return code -101 from org.apache.hadoop.hive.ql.exec.mr.MapRedTask. unable to create new native thread
Caused by: java.lang.OutOfMemoryError: unable to create new native thread
Any suggestions would be appreciated.