metamodel-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "ASF GitHub Bot (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (METAMODEL-128) Ordering on aggregation value not working
Date Wed, 01 Apr 2015 07:56:54 GMT

    [ https://issues.apache.org/jira/browse/METAMODEL-128?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14390180#comment-14390180
] 

ASF GitHub Bot commented on METAMODEL-128:
------------------------------------------

Github user kaspersorensen commented on the pull request:

    https://github.com/apache/metamodel/pull/13#issuecomment-88384811
  
    I believe that where clause will only work on JDBC because it gets carried along as one
big expression. But MM unfortunately will not understand it so no select items will be there
anyway. Hmm how about then making a getSelectItemByAlias(...) method. We could start with
just items from SELECT but could eventually expand it if subquery support increases. 


> Ordering on aggregation value not working
> -----------------------------------------
>
>                 Key: METAMODEL-128
>                 URL: https://issues.apache.org/jira/browse/METAMODEL-128
>             Project: Apache MetaModel
>          Issue Type: Bug
>    Affects Versions: 4.3.2
>            Reporter: Ashish Mukherjee
>
> I am using a CSV Data Context example with multiple fields - occurrences, first_name,
last_name. 
> The query -
> SELECT SUM(persons.csv.occurrences) AS X, persons.csv.first_name FROM ashish.persons.csv
GROUP BY persons.csv.first_name ORDER BY X
> This query always orders the results by first_name and not the aggregation value.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message