metamodel-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "ASF GitHub Bot (JIRA)" <>
Subject [jira] [Commented] (METAMODEL-128) Ordering on aggregation value not working
Date Tue, 31 Mar 2015 10:08:52 GMT


ASF GitHub Bot commented on METAMODEL-128:

Github user narahari92 commented on the pull request:
    SELECT... FROM (SELECT name as n FROM ...) as q where n='foo';  is perfectly valid but
will fail if we don't consider select items of other clauses if and when we support sub queries
for from and where clause in MetaModel.

> Ordering on aggregation value not working
> -----------------------------------------
>                 Key: METAMODEL-128
>                 URL:
>             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,
> 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

View raw message