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

DbNotificationListener fail on mysql with "select for update"

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 3.0.0
    • Metastore
    • None
    • 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

        1. HIVE-18299.1.patch
          2 kB
          Daniel Dai

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved: