Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-3930

Accumulo translator: select rowid returns empty resultset

    Details

      Description

      Accumulo translator, according to its documentation, enables querying accumulo through teiid's vdb with table like:

      CREATE FOREIGN TABLE "User" (
          rowid string OPTIONS (UPDATABLE FALSE, SEARCHABLE 'All_Except_Like'),
          name_age string OPTIONS (SEARCHABLE 'All_Except_Like', "teiid_accumulo:CF" 'name', "teiid_accumulo:CQ" 'age', "teiid_accumulo:VALUE-IN" '{VALUE}'),
          name_firstname string OPTIONS (SEARCHABLE 'All_Except_Like', "teiid_accumulo:CF" 'name', "teiid_accumulo:CQ" 'firstname', "teiid_accumulo:VALUE-IN" '{VALUE}'),
          name_lastname string OPTIONS (SEARCHABLE 'All_Except_Like', "teiid_accumulo:CF" 'name', "teiid_accumulo:CQ" 'lastname', "teiid_accumulo:VALUE-IN" '{VALUE}'),
          CONSTRAINT PK0 PRIMARY KEY(rowid)
      ) OPTIONS (UPDATABLE TRUE);
      

      The problem is, that querying for rowid column won't return any results:
      Query

      SELECT rowid FROM User;
      

      does return empty resultset.

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                rareddy Ramesh Reddy
                Reporter:
                jstastny Jan Stastny
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: