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 <ashish.mukher...@gmail.com>: > 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 >
