How to do distinct(., .keep_all = TRUE) in dbplyr?

ftoresh · March 12, 2020, 3:13am

When using .keep_all = TRUE while piping inside a database I get "Error: Can only find distinct value of specified columns if .keep_all is FALSE". How can I replicate the same action in another way?

mara · March 16, 2020, 3:05pm

I see exactly what you're talking about in the code. My wild-speculation is that there might be something that makes this tricky to implement across all the possible back ends. But, I think it'd be a reasonable feature request.

github.com

tidyverse/dbplyr/blob/3bfecdf0d922ec08db1925e35e162c726af5a1b5/R/verb-distinct.R#L2-L15


      
          distinct.tbl_lazy <- function(.data, ..., .keep_all = FALSE) {
            if (dots_n(...) > 0) {
              if (.keep_all) {
                stop(
                  "Can only find distinct value of specified columns if .keep_all is FALSE",
                  call. = FALSE
                )
              }
          
              .data <- transmute(.data, ...)
            }
          
            add_op_single("distinct", .data, dots = list())
          }

You can file it here:

ftoresh · March 18, 2020, 5:43pm

Will do then! Thanks

system · April 8, 2020, 5:43pm

This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.