Backend: Hive

See vignette("translate-function") and vignette("translate-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(z, "a", "b"))
#> <SQL>
#> SELECT REGEXP_REPLACE(`z`, '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`