Hi, Have reported these issues on JIRA -
https://issues.apache.org/jira/browse/METAMODEL-127 https://issues.apache.org/jira/browse/METAMODEL-128 Regards, Ashish On Thu, Mar 26, 2015 at 11:37 PM, Kasper Sørensen < [email protected]> wrote: > Hi Ashish, > > Thank you for looking into this. No to my knowledge they sound like newly > found issues. You're more than welcome to report them on JIRA! > > Regards, > Kasper > > 2015-03-26 9:45 GMT+01:00 Ashish Mukherjee <[email protected]>: > > > Hello, > > > > I am using a CSV Data Context example with multiple fields - occurrences, > > first_name, last_name. Came across the following bugs (seems to me > anyway) > > while executing these queries - > > > > 1) SELECT DISTINCT persons.csv.first_name FROM persons.csv > > > > This query performs a distinct across all the three columns and not just > on > > the column adjacent to the DISTINCT keyword. > > > > 2) 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. > > > > Are these known issues being addressed? I could not find them by a > > superficial search in JIRA. > > > > Regards, > > Ashish > > >
