You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@metamodel.apache.org by Ashish Mukherjee <as...@gmail.com> on 2015/03/26 09:45:55 UTC

Possible bugs

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

Re: Possible bugs

Posted by Ashish Mukherjee <as...@gmail.com>.

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 <
i.am.kasper.sorensen@gmail.com> 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 <as...@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
> >
>

Re: Possible bugs

Posted by Kasper Sørensen <i....@gmail.com>.

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 <as...@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
>