[
https://issues.apache.org/jira/browse/TRAFODION-2613?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Sandhya Sundaresan reassigned TRAFODION-2613:
---------------------------------------------
Assignee: Anoop Sharma
> 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
> Assignee: Anoop Sharma
> 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)
