Accumulo translator: select rowid returns empty resultset --------------------------------------------------------- Key: TEIID-3930 URL: https://issues.jboss.org/browse/TEIID-3930 Project: Teiid Issue Type: Bug Components: Misc. Connectors Affects Versions: 8.12.3 Reporter: Jan Stastny Assignee: Ramesh Reddy Fix For: 9.0, 8.12.5 Accumulo translator, according to its [documentation|https://docs.jboss.org/author/display/teiid812final/Apache+...], enables querying accumulo through teiid's vdb with table like: {code:xml} 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); {code} The problem is, that querying for rowid column won't return any results: Query {code:sql} SELECT rowid FROM User; {code} does return empty resultset.