]
RH Bugzilla Integration commented on TEIID-3930:
------------------------------------------------
Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug
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.