Consider tidyr implementations for SQL

[hadley]

Consider tidyr implementations for SQL

[edgararuiz-zz]

I have a PR for pivot_wider() available now here: #344. If you'd like to try it out, you can install it using: install_github("tidyverse/dbplyr#344")

[edgararuiz-zz]

Should we target pivot_longer() and pivot_wider() instead of spread() and gather()?

[abalter]

What is the status of implementing unnest?

[TuSKan]

There are any ideias how to do it?
Something like that? http://modern-sql.com/use-case/pivot
for Hive there is lateral view explode ?

[iangow]

There are any ideas how to do it?

One can create (a crude version of) this functionality using dplyr verbs (see here).

[hadley]

Moved to dbplyr, since that contains all the low-level primitives needed for SQL generation

[edgararuiz-zz]

Should I finish this PR? #72

[hadley]

See https://github.com/halpo/pivot for existing work.

[hadley]

Yes. Although for an initial implementation we’d ignore most of the advanced features.

[aldomann]

Any updates on this?

[aldomann]

@edgararuiz thanks, managed to do what i wanted to do in another way, but I'll definitely check it out later and try to replicate my results and compare.

[edgararuiz-zz]

That'll be great, thank you

[ben1787]

I see that pivot_longer does not work on an uncollected dbplyr tibble. Am I doing something wrong or is this something that would be supported in the future?

Thanks!
Ben

[hadley]

Done, thanks to @mgirlich!