| Hibernate adds alias for PARTITION keyword For example : {{@Formula(" ROW_NUMBER() OVER( PARTITION BY VOUCHER_MASTER_ID ORDER BY SIGN(amount) DESC , ABS(amount) ASC)") private Integer lineNumber;}} Causes this sql: {{ ROW_NUMBER() OVER( voucherlin21_.PARTITION BY voucherlin21_.VOUCHER_MASTER_ID ORDER BY SIGN(voucherlin21_.amount) DESC , ABS(voucherlin21_.amount) ASC) AS formula0_20_,}} By removing alias from PARTITION generated SQL works properly |