I’m trying to use a dplyr pipeline for querying data inside a mapd database.
My current problem with it is that mapd SQL is SQL-92 conformant, and thus, doesn’t accept R basic
!= operator, only SQL-92
I made a request to mapd to support the
!= operator, but in the meantime, I was wondering if you know any way to automatically convert my
!= characters, generated with my dplyr’s query, to
Considering my code is in a dplyr pipeline, agnostic regarding the db hosting the data, I can’t write the request, do some string manipulation (like a basic
str_replace) and then send the request : it has to work on local data.frames too.
I was wondering if
dbplyr allows to restrict the operators set, and thius, fix my problem.
I’m querying the db through
RJDBC package (using JDBC driver).
Thanks for any idea