anishek created HIVE-17830: ------------------------------ Summary: dbnotification fails to work with rdbms other than postgres Key: HIVE-17830 URL: https://issues.apache.org/jira/browse/HIVE-17830 Project: Hive Issue Type: Bug Components: HiveServer2 Reporter: anishek Assignee: anishek Priority: Critical Fix For: 3.0.0
as part of HIVE-17721 we had changed the direct sql to acquire the lock for postgres as {code} select "NEXT_EVENT_ID" from "NOTIFICATION_SEQUENCE" for update; {code} however this breaks other databases and we have to use different sql statements for different databases for postgres use {code} select "NEXT_EVENT_ID" from "NOTIFICATION_SEQUENCE" for update; {code} for SQLServer {code} select "NEXT_EVENT_ID" from "NOTIFICATION_SEQUENCE"with (updlock); {code} for other databases {code} select NEXT_EVENT_ID from NOTIFICATION_SEQUENCE for update; {code} -- This message was sent by Atlassian JIRA (v6.4.14#64029)