Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-18299

DbNotificationListener fail on mysql with "select for update"

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 3.0.0
    • Component/s: Metastore
    • Labels:
      None
    • Target Version/s:
    • Hadoop Flags:
      Reviewed

      Description

      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).

        Attachments

          Activity

            People

            • Assignee:
              daijy Daniel Dai
              Reporter:
              daijy Daniel Dai
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: