Uploaded image for project: 'Apache Trafodion (Retired)'
  1. Apache Trafodion (Retired)
  2. TRAFODION-2613

Update results are not seen on selects sometimes on native hbase table

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Critical
    • Resolution: Unresolved
    • 2.2.0
    • None
    • dtm, sql-exe
    • None

    Description

      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;

      Attachments

        Activity

          People

            anoopsharma Anoop Sharma
            sandhya Sandhya Sundaresan
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated: