Comments (5)
Dear Ian
I've been working with implyr for few weeks without problems, but now when I updated its dependencies (including update to rlang 0.2.0, but also includes update of dplyr, dbplyr) I ran to serious problem - basically all summarise queries ceased to work. I think it is related to the compatibility question you asked yourself so I raise it here.
There is some problem with parsing variables to group_by - I'm running below simple code.
index %>% summarize(divisor = sum(divisor)) %>% explain
Which gets translated like this:
<SQL> SELECT ``, SUM(
divisor) AS
divisorFROM ds_cz_prod.index GROUP BY ``
An error is thrown because of unintended grouping by empty variable. I can run this in parallel on a server where I updated implyr to latest version 0.2.2 but did not update the dependencies, and there it works normally, i.e. as
<SQL> SELECT SUM(
divisor) AS
divisor FROM ds_cz_prod.index
In attachment I include complete code I'm running on both machines, the result of explain statement, and the sessionInfo.
Let me note that I also switched to the latest Cloudera driver (working with JDBC) on my local workstation, but for both old and new driver the result is the same.
Please advise if there is something more I can check on my end, or if indeed some source code changes are needed?
implyr issue #18.pdf
Thank you
from implyr.
Thanks @mirekkolar for reporting this and providing all the details!
I ran into this same error myself just hours ago. I have one environment where the error occurs and one where it does not occur, and when I compare the sessionInfo()
output from those two sessions, the only difference I see is that the version of DBI is different (works on 0.7, fails on 0.8), so I believe this is related to a change in DBI, not in rlang. I will investigate further later today.
from implyr.
@mirekkolar I ran some more tests and confirmed that a change I already made to implyr on GitHub (7ffdfbf) fixes this problem.
I haven't published a new version of implyr on CRAN since this change, so if you're using the latest CRAN release version (0.2.2) then this problem will still affect you.
Can you install the development version of implyr from GitHub to see if this solves the problem for you?
devtools::install_github("ianmcook/implyr")
from implyr.
@ianmcook thanks so much for your fast reaction - yes with the development version all works well!
I cannot test the development version so easily in my server environment with older version of dependencies, for backwards compatibility - but based on the changes you referenced I don't think I should expect any problem there.
Thanks again and I hope the new version makes it to CRAN soon!
from implyr.
This is fixed in implyr version 0.2.3 on CRAN.
from implyr.
Related Issues (20)
- Fix literal string arguments in paste() HOT 1
- Add Function src_insert HOT 1
- read / write parquet / CSV files HOT 3
- ODBC ERROR: while contacting server - SSL connection HOT 3
- Eliminate uses of compare_tbls() and compare_tbls2() in tests HOT 1
- java.sql.SQLNonTransientConnectionException: [Cloudera][JDBC](10060) Connection has been closed. HOT 2
- Translating expression with extracted entry. HOT 3
- is there character length limit? : nchar(x) < 32700 HOT 7
- Drop db_sql_render method? HOT 3
- dbplyr 2.0.0 breaks implyr HOT 4
- copy_to dimension limit HOT 2
- Warning: "object '.__C__impala_connection' not found" when initializien impala connection HOT 2
- Write to external table in non-default location?
- Greater than 1024 rows of some variable types causes an encoding error HOT 1
- Dbplyr joins fail with default suffixes
- compute fails
- Two joins in a row fail
- compatibility with box::use HOT 1
- Support dbplyr edition 2
- Issues integrating with dbplyr 2.4.0 HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from implyr.