[teiid-issues] [JBoss JIRA] (TEIID-4213) Cassandra translator: enable pushdown of aggregate functions

[Ramesh Reddy (JIRA)]

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

Ramesh Reddy commented on TEIID-4213:
-------------------------------------

Come to find out whole version Teiid using is wrong. The version on the connection is "protocol" version, which referes to Thrift protocol version. BTW V1 and V2 removed in 3.x of Cassandra.  Then they have Cassandra versions, Datastax versions, CQL versions. See http://docs.datastax.com/en/landing_page/doc/landing_page/compatibility.html

I think we need to either depend on CQL version or Cassandra version? This is some logic we can use http://stackoverflow.com/questions/31502442/check-cql-version-with-cassandra-and-cqlsh

Depending upon CQL version, will give us the independence from the Server versions IMO, however it is not totally clear how they are progressing these versions, as Cassandra 2.x and 3.x support CQL 3.3 so we would not be able to peg individual capability support to CQL. :(

> Cassandra translator: enable pushdown of aggregate functions
> ------------------------------------------------------------
>
>                 Key: TEIID-4213
>                 URL: https://issues.jboss.org/browse/TEIID-4213
>             Project: Teiid
>          Issue Type: Feature Request
>          Components: Misc. Connectors
>    Affects Versions: 8.12.x
>            Reporter: Jan Stastny
>            Assignee: Ramesh Reddy
>            Priority: Minor
>             Fix For: 9.1
>
>
> Cassandra supports basic aggregate functions:
> MIN(),MAX(),SUM() and AVG()
> Currently Teiid doesn't push such queries.
> NOTE:In case of AVG() there is difference between the values returned from Teiid vs. Cassandra for an integer column. Cassandra returns only whole part of the number as integer, Teiid returns bigdecimal.



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