hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Hive QA (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-20679) DDL operations on hive might create large messages for DBNotification
Date Wed, 17 Oct 2018 22:39:00 GMT

    [ https://issues.apache.org/jira/browse/HIVE-20679?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16654316#comment-16654316
] 

Hive QA commented on HIVE-20679:
--------------------------------



Here are the results of testing the latest attachment:
https://issues.apache.org/jira/secure/attachment/12944301/HIVE-20679.6.patch

{color:green}SUCCESS:{color} +1 due to 11 test(s) being added or modified.

{color:green}SUCCESS:{color} +1 due to 15198 tests passed

Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/14528/testReport
Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/14528/console
Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-14528/

Messages:
{noformat}
Executing org.apache.hive.ptest.execution.TestCheckPhase
Executing org.apache.hive.ptest.execution.PrepPhase
Executing org.apache.hive.ptest.execution.YetusPhase
Executing org.apache.hive.ptest.execution.ExecutionPhase
Executing org.apache.hive.ptest.execution.ReportingPhase
{noformat}

This message is automatically generated.

ATTACHMENT ID: 12944301 - PreCommit-HIVE-Build

> 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,
HIVE-20679.5.patch, HIVE-20679.6.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)

Mime
View raw message