-
Notifications
You must be signed in to change notification settings - Fork 35
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
PostgreSQL is broken #45
Comments
Do you know if package |
@homerhanumat I haven't tried it in a long time, but I know that package is under active development. Can you try it out and report back? |
Will do. Thanks, by the way, for MDSR -- very impressive text. |
Might be a while before I get to try it. My remote Ubuntu-based server installs things fine but has only about 30G disk space to devote to the DB. My laptop is a Mac with plenty of space but RPostgres installation fails on Mac at the moment: r-dbi/RPostgres#155. |
Can you test with a single years worth of data?
All the best,
Nick
… On Dec 8, 2017, at 4:35 PM, Homer White ***@***.***> wrote:
Might be a while before I get to try it. My remote Ubuntu-based server installs things fine but has only about 30G disk space to devote to the DB. My laptop is a Mac with plenty of space but RPostgres installation fails on Mac at the moment: r-dbi/RPostgres#155.
—
You are receiving this because you are subscribed to this thread.
Reply to this email directly, view it on GitHub, or mute the thread.
|
2015 through the problematic 2016 -- sure, I can give ti a try. |
I tried this:
Got an error saying that it could not find the initialization script. So I tried again with an explicit reference to the script in the package:
Got two errors, the second of which was a complaint that it could not parse the first commented line of the script. I copied the script into my home directory, deleted the comment-lines, and tried again:
Now I'm down to just the one error, which is:
Thoughts? |
The above error occurs in the extract phase and is unrelated to choice of database. Perhaps the structure of |
Yes, some raw data sets have changed, some URLs have changed, and some |
So I have updated the package (here)to account for changes in location and structure of source files and in dplyr as well. It now works again with the RMySQL driver. It fails using RPostgres, with an error that suggests that the RPostgres method for |
Latest update to my fork of airlines permits creation and updating of a Postgres DB, loading the processed flights csv file to a PostgresDB with a direct sql Monthly updates (both in MySQL and Postgres) conclude with a warning:
This occurs because the flight csv files have a spurious trailing comma on the first line, so no harm is done. At this point one should not build the connection with |
One problem is that the
dbWriteTable
method from theRPostgreSQL
package will not actually accept theHEADER
flag (https://github.com/cran/RPostgreSQL/blob/master/R/PostgreSQLSupport.R#L570)This breaks the current implementation.
Possible workarounds:
data.frame
method -- but that will be slow and memory inefficientRPostgres
package working. This will probably be the long-term solution, but I don't know how long it will take.I believe this problem applies to all
etl
packages that use thedbWriteTable
character
method.The text was updated successfully, but these errors were encountered: