[jira] [Created] (HIVE-21598) CTAS on ACID table during incremental does not replicate data

[Ashutosh Bapat (JIRA)]

Ashutosh Bapat created HIVE-21598:
-------------------------------------

             Summary: 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


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)