See vignette("translation-function") and vignette("translation-verb") for
details of overall translation technology. Key differences for this backend
are a scattering of custom translations provided by users.
Use simulate_hive() with lazy_frame() to see simulated SQL without
converting to live access database.
Examples
library(dplyr, warn.conflicts = FALSE)
lf <- lazy_frame(a = TRUE, b = 1, d = 2, c = "z", con = simulate_hive())
lf %>% transmute(x = cot(b))
#> <SQL>
#> SELECT 1.0 / TAN(`b`) AS `x`
#> FROM `df`
lf %>% transmute(x = bitwShiftL(c, 1L))
#> <SQL>
#> SELECT SHIFTLEFT(`c`, 1) AS `x`
#> FROM `df`
lf %>% transmute(x = str_replace_all(c, "a", "b"))
#> <SQL>
#> SELECT REGEXP_REPLACE(`c`, 'a', 'b') AS `x`
#> FROM `df`
lf %>% summarise(x = median(d, na.rm = TRUE))
#> <SQL>
#> SELECT PERCENTILE(`d`, 0.5) AS `x`
#> FROM `df`
lf %>% summarise(x = var(c, na.rm = TRUE))
#> <SQL>
#> SELECT VARIANCE(`c`) AS `x`
#> FROM `df`