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.
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`#> <SQL> #> SELECT SHIFTLEFT(`c`, 1) AS `x` #> FROM `df`#> <SQL> #> SELECT REGEXP_REPLACE(`z`, 'a', 'b') AS `x` #> FROM `df`#> <SQL> #> SELECT PERCENTILE(`d`, 0.5) AS `x` #> FROM `df`#> <SQL> #> SELECT VARIANCE(`c`) AS `x` #> FROM `df`