[ 
https://issues.apache.org/jira/browse/HIVE-20679?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

anishek updated HIVE-20679:
---------------------------
    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



  was:
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. 




> DDL operations on hive might create large messages for DBNotification
> ---------------------------------------------------------------------
>
>                 Key: HIVE-20679
>                 URL: https://issues.apache.org/jira/browse/HIVE-20679
>             Project: Hive
>          Issue Type: Bug
>    Affects Versions: 3.1.0
>            Reporter: anishek
>            Assignee: anishek
>            Priority: Major
>         Attachments: HIVE-20679.1.patch, HIVE-20679.2.patch, 
> HIVE-20679.3.patch, HIVE-20679.4.patch, a.sql, b.sql
>
>
> 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



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Reply via email to