Details
-
Bug
-
Resolution: Done
-
Major
-
8.12.3
-
None
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.