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

[RH Bugzilla Integration (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-3930?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

RH Bugzilla Integration updated TEIID-3930:
-------------------------------------------
    Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1301540
        Bugzilla Update: Perform


> 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 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.



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