What happens in case of deadlocks in SAP HANA? If anyone know the complete scenario then please explain that here.
Deadlocks are situations where two or more transactions lock each other cross-wise so that no transaction will ever be able to proceed. If SAP HANA recognizes a deadlock (typically in combination with record locks), one of the transaction will be terminated and the following error is issued:
SQL error 133: transaction rolled back by detected deadlock
This behavior is different from other databases like Oracle where a deadlock will only terminate the current DML operation and not the whole transaction.
Read Here about How to check if SAP HANA database suffers from lock waits?