Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Detach GROUP BY items and result #18

Open
kit-ty-kate opened this issue Jan 14, 2014 · 2 comments
Open

Detach GROUP BY items and result #18

kit-ty-kate opened this issue Jan 14, 2014 · 2 comments

Comments

@kit-ty-kate
Copy link
Member

This issue is both a request and a question.
First the question: Why the items contained in the GROUP BY block is also returned in the result.
For example the following example will return both res and value:

<< group {res = sum[t.value]} by {t.value} | t in $table$ >>

So, let's imagine value is something big to send and we don't need it, then we will have a substantial performance lose.

Is it something possible ? Maybe we can have a extra operator to say this is something to not add to the result ?

@gasche
Copy link
Contributor

gasche commented Jan 14, 2014

When we designed group by, it simply seemed more expressive to do it that way. Do you have a realistic use-case where the grouped-over value is too large to be transmitted? In this case I guess << {foo.res} | foo in $grouped_stuff$ >> should do the job.

@kit-ty-kate
Copy link
Member Author

Ok. Oh yes, I though about that too. An other use-case for subqueries ! :)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants