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

Hive QA commented on HIVE-21598:
--------------------------------



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

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

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

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

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: 12967619 - PreCommit-HIVE-Build

> CTAS on ACID table during incremental does not replicate data
> -------------------------------------------------------------
>
>                 Key: HIVE-21598
>                 URL: https://issues.apache.org/jira/browse/HIVE-21598
>             Project: Hive
>          Issue Type: Bug
>          Components: HiveServer2, repl
>            Reporter: Ashutosh Bapat
>            Assignee: Ashutosh Bapat
>            Priority: Major
>              Labels: CTAS, Repl
>         Attachments: HIVE-21598.01.patch, HIVE-21598.02.patch, 
> HIVE-21598.03.patch, HIVE-21598.04.patch, HIVE-21598.05.patch, 
> HIVE-21598.06.patch
>
>
> Scenario
> create database dumpdb with dbproperties('repl.source.for'='1,2,3');
> use dumpdb;
> create table t1 (id int) clustered by(id) into 3 buckets stored as orc 
> tblproperties ("transactional"="true");
> insert into t1 values(1);
> insert into t1 values(2);
> repl dump dumpdb;
> repl load loaddb from <bootstrap load directory>;
> use loaddb;
> select * from t1;
> +--------+
> | t6.id |
> +--------+
> | 1 |
> | 2 |
> +--------
> use dumpdb;
> create table t6 stored as orc tblproperties ("transactional"="true") as 
> select * from t1;
> select * from t6;
> +--------+
> | t6.id |
> +--------+
> | 1 |
> | 2 |
> +--------+
> repl dump dumpdb from <last repl id>
> repl load loaddb from <inc dump location>;
> use loaddb;
> select * from t6;
> +--------+
> | t6.id |
> +--------+
> +--------+
> t6 gets created but there's no data.
>  
> On further investigation, I see that the CommitTxnEvent's dump directory has 
> _files but it is empty. Looks like we do not log names of the files created 
> as part of CTAS.



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

Reply via email to