[ https://issues.apache.org/jira/browse/HIVE-18299?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16323575#comment-16323575 ]
Daniel Dai commented on HIVE-18299: ----------------------------------- [~anishek], can you review? > DbNotificationListener fail on mysql with "select for update" > ------------------------------------------------------------- > > Key: HIVE-18299 > URL: https://issues.apache.org/jira/browse/HIVE-18299 > Project: Hive > Issue Type: Bug > Components: Metastore > Reporter: Daniel Dai > Assignee: Daniel Dai > Attachments: HIVE-18299.1.patch > > > This is a continuation of HIVE-17830, which haven't solved the issue. We need > to run "SET \@\@session.sql_mode=ANSI_QUOTES" statement before we run > select \"NEXT_EVENT_ID\" from \"NOTIFICATION_SEQUENCE\"". We shall keep table > name quoted to be in consistent with rest of ObjectStore code. This approach > is the same as what MetaStoreDirectSql take (set session variable before > every query). -- This message was sent by Atlassian JIRA (v6.4.14#64029)