How to pass database query to strings using dplyr filter function

Question

I'm trying to pass database query to strings using dplyr filter functions

here is the code

main<-tbl(portal, "account")%>%
  filter( dates >= "1640991600" & dates <= "1641077999")%>%
  collect()%>%
  as.character()

but it's not working, any help would be welcome

Hi user16087142, you need to provide us at least a bit of data or the error message. — Stephan
– Stephan, Commented Mar 16, 2022 at 10:03

danlooo · Accepted Answer · 2022-03-16 10:23:02Z

1

collect() will return an object of class data.frame which is a table that can not be converted into a character vector implicitly. Instead of as.character(), you can do write_csv("query_result.csv") to save the received table into a file or pull(col1) %>% as.character() to get a character vector of the column named col1.

answered Mar 16, 2022 at 10:23

danlooo

10.8k2 gold badges13 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Yomi.blaze93 Over a year ago

Thank you danlooo What I did was to save it as you have suggested in your answer("query_result.csv"), then read it back using read.csv and set the colClasses to "character"

Collectives™ on Stack Overflow

How to pass database query to strings using dplyr filter function

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related