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)