You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@metamodel.apache.org by "Ashish Mukherjee (JIRA)" <ji...@apache.org> on 2015/03/29 05:54:53 UTC

[jira] [Created] (METAMODEL-128) Ordering on aggregation value not working

Ashish Mukherjee created METAMODEL-128:
------------------------------------------

             Summary: 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)