You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "anishek (JIRA)" <ji...@apache.org> on 2017/10/18 08:43:00 UTC
[jira] [Created] (HIVE-17830) dbnotification fails to work with
rdbms other than postgres
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)