[teiid-issues] [JBoss JIRA] (TEIID-2722) Cassandra: ORDER BY should do it in memory instead of trying to push down Cassandra in some cases

[Steven Hawkins (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-2722?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12829605#comment-12829605 ] 

Steven Hawkins commented on TEIID-2722:
---------------------------------------

TEIID-2717 did change the metadata so that only primary key columns are searchable, so this narrows the issue somewhat.  It looks like for now we should simply disable the cassandra translator advertising support for order by altogether.
                
> Cassandra:  ORDER BY should do it in memory instead of trying to push down Cassandra in some cases
> --------------------------------------------------------------------------------------------------
>
>                 Key: TEIID-2722
>                 URL: https://issues.jboss.org/browse/TEIID-2722
>             Project: Teiid
>          Issue Type: Bug
>          Components: Query Engine
>    Affects Versions: 8.6
>         Environment: Teiid 8.6 Alpha with Cassandra 1.2.11
>            Reporter: Ivan Chan
>            Assignee: Steven Hawkins
>              Labels: teiid
>
> When I tried to join 2 tables together from same keyspace using Teiid 8.6 Alpha with Cassandra 1.2.11.   It broke down SQL into 2 CQLs.  However, teiid SQL transformer adds order by clause to the CQL which is not supported.
> Original SQL:
> select "cassandraDS_users"."user_id" as "cassandraDS_users_user_id",
> "cassandraDS_invoice"."sale" as "cassandraDS_invoice_sale"
> from "cassandraDS"."invoice" "cassandraDS_invoice"
> inner join "cassandraDS"."users" "cassandraDS_users" on ("cassandraDS_invoice"."user_id" = "cassandraDS_users"."user_id")
> Break Down CQL:
> SELECT cassandraDS.invoice.user_id, cassandraDS.invoice.sale FROM cassandraDS.i
> nvoice ORDER BY cassandraDS.invoice.user_id
> SELECT cassandraDS.users.user_id FROM cassandraDS.users ORDER BY cassandraDS.us
> ers.user_id
> Error from CQL Driver:
> com.datastax.driver.core.exceptions.InvalidQueryException: ORDER BY is only supported when the partition key is restricted by an EQ or an IN.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira