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)
