I have ORACLE as my Hive Database and I am getting belwo error in ORACLE DB :
"ORA-00060: Deadlock detected. See Note 60.1 at My Oracle Support for Troubleshooting ORA-60 Errors. More info in file /apps/oracle/diag/rdbms/hive"
WHat could be the possible reasons for this...how to resolve this? It is creating trace files of very large sizes and sending alerts
Is ACID enabled? If yes, you might be hitting one of the bugs. Both have been fixed, so please see the version of Hive you are using and whether you have applied the patch or not:
Another issue pointed out is below when metastore throws a deadlock. There is a workaround mentioned in case you have same issue:
HI Sindhu, datanucleus.connectionPoolingType is dbcp.
If there are inputs based on this.. please let me know