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

DDL operations on hive might create large messages for DBNotification

    XMLWordPrintableJSON

Details

    Description

      Certain type of ddl operations might create large messages as part of DBNoitification, this might lead to the rdbms throwing an error when storing the message since its size is to large. It will also increase the footprint of the rdbms space usage.

      We should try store compressed messages to allow handling these situations.

      Edit: For notification_log table the message column for all supported databases can store messages from 2GB to 4GB

      Attachments

        1. a.sql
          7 kB
          Anishek Agarwal
        2. b.sql
          33 kB
          Anishek Agarwal
        3. HIVE-20679.1.patch
          233 kB
          Anishek Agarwal
        4. HIVE-20679.2.patch
          234 kB
          Anishek Agarwal
        5. HIVE-20679.3.patch
          236 kB
          Anishek Agarwal
        6. HIVE-20679.4.patch
          237 kB
          Anishek Agarwal
        7. HIVE-20679.5.patch
          242 kB
          Anishek Agarwal
        8. HIVE-20679.6.patch
          242 kB
          Anishek Agarwal
        9. HIVE-20679.8.patch
          242 kB
          Anishek Agarwal
        10. HIVE-20679.9.patch
          242 kB
          Anishek Agarwal

        Issue Links

          Activity

            People

              anishek Anishek Agarwal
              anishek Anishek Agarwal
              Votes:
              1 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 20m
                  20m