[teiid-issues] [JBoss JIRA] (TEIID-3930) Accumulo translator: select rowid returns empty resultset
Jan Stastny (JIRA)
issues at jboss.org
Mon Jan 25 05:52:01 EST 2016
[ https://issues.jboss.org/browse/TEIID-3930?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jan Stastny updated TEIID-3930:
-------------------------------
Description:
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.
was:
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.
> 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)
More information about the teiid-issues
mailing list