[jira] [Created] (TRAFODION-2613) Update results are not seen on selects sometimes on native hbase table

["Sandhya Sundaresan (JIRA)" <ji...@apache.org>]

Sandhya Sundaresan created TRAFODION-2613:
---------------------------------------------

             Summary: Update results are not seen on selects sometimes on native hbase table
                 Key: TRAFODION-2613
                 URL: https://issues.apache.org/jira/browse/TRAFODION-2613
             Project: Apache Trafodion
          Issue Type: Bug
          Components: dtm, sql-exe
    Affects Versions: 2.2-incubating
            Reporter: Sandhya Sundaresan
            Priority: Critical


The following test seabase/TEST022 shows strange symptoms on updates on external tables mapped to hbase table.
Commenting out this part of the test. It needs to be re-enabled /uncommented after this JIRA is fixed. 


>>select * from t022hbm1;

A     B
----  -----------

b               ?

--- 1 row(s) selected.
>>update t022hbm1 set b = 10;

--- 1 row(s) updated.
>>select * from t022hbm1;

--- 0 row(s) selected.
>>update t022hbm1 set b = null;

--- 0 row(s) updated.
>>select * from t022hbm1;

--- 0 row(s) selected.


Part of test script that fails :


cqd traf_hbase_mapped_tables 'ON';

drop hbase table t022hbm1;
create hbase table t022hbm1 (column family 'cf');
insert into hbase."_ROW_".t022hbm1 values ('a1', 
                 column_create(('cf:B', '100 ')));
insert into hbase."_ROW_".t022hbm1 values ('a2', column_create(('cf:A', 'a2')));
create external table t022hbm1 (a varchar(4) not null, b int) 
        primary key (a)
        attribute default column family 'cf'
        map to hbase table t022hbm1
        data format native;

insert into t022hbm1 values ('a', 1);
select * from t022hbm1;
--Non deterministic results from all updates below. 
update t022hbm1 set b = b + 1;
select * from t022hbm1;
insert into t022hbm1 values ('a', 1); -- should fail
insert into t022hbm1 values ('b', null);
select * from t022hbm1;
delete from t022hbm1 where a = 'a';
select * from t022hbm1;
update t022hbm1 set b = 10;
select * from t022hbm1;
update t022hbm1 set b = null;
select * from t022hbm1;
delete from t022hbm1;
select * from t022hbm1;



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)