You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@metamodel.apache.org by "ASF GitHub Bot (JIRA)" <ji...@apache.org> on 2015/04/01 00:54:52 UTC
[jira] [Commented] (METAMODEL-128) Ordering on aggregation value
not working
[ https://issues.apache.org/jira/browse/METAMODEL-128?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14389567#comment-14389567 ]
ASF GitHub Bot commented on METAMODEL-128:
------------------------------------------
Github user kaspersorensen commented on the pull request:
https://github.com/apache/metamodel/pull/13#issuecomment-88277332
Correct, that's the one type of subquery we support. One that is in the FROM clause. We don't support it in select or where (currently).
> 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)