You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
TABLE <- tbl(impala, "default.test")
## The following works
TABLE %>%
left_join(TABLE)
## The following chokes the Impala engine
TABLE %>%
left_join(TABLE) %>%
left_join(TABLE)
## Because
TABLE %>%
left_join(TABLE) %>%
left_join(TABLE) %>%
show_query()
> <SQL>
> SELECT `default`.`test`.``.``.`1`.*
> FROM `default`.`test` AS `default`.`test`.``.``.`1`
> LEFT JOIN `default`.`test` AS `default`.`test`.``.``.`2`
> ON (
> `default`.`test`.``.``.`1`.`x` = `default`.`test`.``.``.`2`.`x` AND
> `default`.`test`.``.``.`1`.`y` = `default`.`test`.``.``.`2`.`y`
> )
> LEFT JOIN `default`.`test` AS `default`.`test`.``.``.`3`
> ON (
> `default`.`test`.``.``.`1`.`x` = `default`.`test`.``.``.`3`.`x` AND
> `default`.`test`.``.``.`1`.`y` = `default`.`test`.``.``.`3`.`y`
> )
Notice how generated query contains empty identifiers in backticks. Buggy behaviou doesn't happen when TABLE is backed by SQLite, for example, so this is likely specific to implyr.
R version 4.1.2 (2021-11-01)
Platform: x86_64-pc-linux-gnu (64-bit)
Running under: Ubuntu 22.04.2 LTS
dbplyr_2.3.2
implyr_0.4.0
The text was updated successfully, but these errors were encountered:
To reproduce:
Notice how generated query contains empty identifiers in backticks. Buggy behaviou doesn't happen when TABLE is backed by SQLite, for example, so this is likely specific to implyr.
R version 4.1.2 (2021-11-01)
Platform: x86_64-pc-linux-gnu (64-bit)
Running under: Ubuntu 22.04.2 LTS
dbplyr_2.3.2
implyr_0.4.0
The text was updated successfully, but these errors were encountered: