[teiid-issues] [JBoss JIRA] (TEIID-3930) Accumulo translator: select rowid returns empty resultset

[Jan Stastny (JIRA)]

Jan Stastny created TEIID-3930:
----------------------------------

             Summary: 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: Steven Hawkins


Accumulo translator, according to its [documentation|https://docs.jboss.org/author/display/teiid812final/Apache+Accumulo+Translator], enables querying accumulo through teiid's vdb with vdb 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.



--
This message was sent by Atlassian JIRA
(v6.4.11#64026)