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 Mon, 30 Mar 2015 17:27:52 GMT

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

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

Github user narahari92 commented on the pull request:

    https://github.com/apache/metamodel/pull/13#issuecomment-87761146
  
    No that existing unit test still changes because the alias name in query will be replaced
by <tablename>.<columnName>.i.e. "foobarbaz" gets replaced by "a.foo"


> 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