Would like to connect to specific db using src_impala

[hougs]

It would be nice to be able to connect to a specific database using src_impala instead of needing to use dbExecute(db, "use new_db").

[chezou]

just FYI, I created tbl_change_db() in sparklyr.
https://github.com/rstudio/sparklyr/pull/474/files#diff-df93ac01616b79a3ad2c2a1eb5c977a1R83

I will try to add same one for impyr.

[ianmcook]

If possible, I want to address this in such a way that the user can use idiomatic dplyr syntax rather than implyr-specific syntax. This is related to tidyverse/dplyr#244 and r-dbi/DBI#24.

[ianmcook]

The resolution of this should use forward-compatible syntax. That's not possible at the moment because Hadley and Kirill Müller and others are actively working to solve this problem in dplyr and DBI, and the syntax that will be used has not yet been decided. Closing this for now, but I will revisit it once there is an idiomatic syntax for this established by dyplr.

[chezou]

OK, it's a completely dplyr and DBI problem.

[ianmcook]

This is solved in dplyr 0.7.0 with the new function in_schema().