Mailing-List: contact dev-help@metamodel.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@metamodel.apache.org
Date: Tue, 31 Mar 2015 10:08:52 +0000 (UTC)
From: "ASF GitHub Bot (JIRA)" <jira@apache.org>
To: dev@metamodel.apache.org
Message-ID: <JIRA.12786501.1427601290000.79148.1427796532679@Atlassian.JIRA>
In-Reply-To: <JIRA.12786501.1427601290000@Atlassian.JIRA>
References: <JIRA.12786501.1427601290000@Atlassian.JIRA>
 <JIRA.12786501.1427601290370@arcas>
Subject: [jira] [Commented] (METAMODEL-128) Ordering on aggregation value
 not working
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


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

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

Github user narahari92 commented on the pull request:

    https://github.com/apache/metamodel/pull/13#issuecomment-88024935
  
    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: 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)