-
Notifications
You must be signed in to change notification settings - Fork 2.1k
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
Consider adding support for CROSS JOIN
#2924
Comments
Wouldn't it be better to add a new |
@ianmcook Yeah, I agree, implementing
However, if we go this route, I think we also need to implement Is someone willing/able/interested in implementing |
I like the idea of a suppressPackageStartupMessages(library(dplyr))
a <- data.frame(x = 1:3)
b <- data.frame(y= 1:2)
full_join(mutate(a, FAKECOL=1), mutate(b, FAKECOL=1), by='FAKECOL') %>%
select(-FAKECOL)
#> x y
#> 1 1 1
#> 2 1 2
#> 3 2 1
#> 4 2 2
#> 5 3 1
#> 6 3 2 Obviously there are a few more steps to pick a fake join condition column at run time. The method I have been using to generate names is: setdiff(paste("FC",
seq_len(1 + length(c(colnames(a), colnames(b)))),
sep = '_'),
c(colnames(a), colnames(b)))[[1]] |
Part of more general #2240 |
CROSS JOIN will be generated whenever by = character() Fixes tidyverse/dplyr#2924
Will this also work in |
This is just a translation of dplyr's |
CROSS JOIN
is unsupported underfull_join
.memdb
Triggers:
However,
tbl(src_memdb(), sql("SELECT * FROM d1 CROSS JOIN d2"))
sparklyr
Triggers,
See sparklyr/sparklyr#771
The text was updated successfully, but these errors were encountered: