backend-hana {dbplyr} | R Documentation |
Backend: SAP HANA
Description
See vignette("translation-function")
and vignette("translation-verb")
for
details of overall translation technology. Key differences for this backend
are:
Temporary tables get
#
prefix and useLOCAL TEMPORARY COLUMN
.No table analysis performed in
copy_to()
.-
paste()
uses||
Note that you can't create new boolean columns from logical expressions; you need to wrap with explicit
ifelse
:ifelse(x > y, TRUE, FALSE)
.
Use simulate_hana()
with lazy_frame()
to see simulated SQL without
converting to live access database.
Usage
simulate_hana()
Examples
library(dplyr, warn.conflicts = FALSE)
lf <- lazy_frame(a = TRUE, b = 1, c = 2, d = "z", con = simulate_hana())
lf %>% transmute(x = paste0(d, " times"))
[Package dbplyr version 2.5.0 Index]