Hello, I am using read.csv.sql first time for reading the large data file.If I am ran this code that showns warning ?closing unused connection?. Is it I am missing any argument from my command or how to comeout from this warning?. R code:- Library(sqldf) ip_dir_path <- ?D:/BharatWarule/big_data_July? inFile_sql <- file.path(ip_dir_path, "cypress_modeldev_account_info.csv") input_abt <- read.csv.sql(inFile_sql,sql = s) Warning message: closing unused connection 3 (D:/BharatWarule/big_data_July/cypress_modeldev_account_info.csv) Thanks, Bharat ----- Bharat Warule Cypress Analytica , Pune -- View this message in context: http://r.789695.n4.nabble.com/Warning-message-with-read-csv-sql-tp4636285.html Sent from the R help mailing list archive at Nabble.com.
Warning message with read.csv.sql
3 messages · Bharat Warule, Gabor Grothendieck, Uwe Ligges
On Thu, Jul 12, 2012 at 8:17 AM, Bharat Warule <bwarule at gmail.com> wrote:
Hello, I am using read.csv.sql first time for reading the large data file.If I am ran this code that showns warning ?closing unused connection?. Is it I am missing any argument from my command or how to comeout from this warning?. R code:- Library(sqldf) ip_dir_path <- ?D:/BharatWarule/big_data_July? inFile_sql <- file.path(ip_dir_path, "cypress_modeldev_account_info.csv") input_abt <- read.csv.sql(inFile_sql,sql = s) Warning message: closing unused connection 3 (D:/BharatWarule/big_data_July/cypress_modeldev_account_info.csv) Thanks, Bharat ----- Bharat Warule Cypress Analytica , Pune -- View this message in context: http://r.789695.n4.nabble.com/Warning-message-with-read-csv-sql-tp4636285.html Sent from the R help mailing list archive at Nabble.com.
______________________________________________ R-help at r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
Read the last line about reproducible code.
Statistics & Software Consulting GKX Group, GKX Associates Inc. tel: 1-877-GKX-GROUP email: ggrothendieck at gmail.com
4 days later
On 13.07.2012 14:00, Gabor Grothendieck wrote:
On Thu, Jul 12, 2012 at 8:17 AM, Bharat Warule <bwarule at gmail.com> wrote:
Hello, I am using read.csv.sql first time for reading the large data file.If I am ran this code that showns warning ?closing unused connection?. Is it I am missing any argument from my command or how to comeout from this warning?. R code:- Library(sqldf) ip_dir_path <- ?D:/BharatWarule/big_data_July? inFile_sql <- file.path(ip_dir_path, "cypress_modeldev_account_info.csv") input_abt <- read.csv.sql(inFile_sql,sql = s) Warning message: closing unused connection 3 (D:/BharatWarule/big_data_July/cypress_modeldev_account_info.csv)
You had open connections before that you forgot to close. R detected that some are unused and closed them for you. That's it. It is also a warning, not an error. Uwe Ligges
Thanks, Bharat ----- Bharat Warule Cypress Analytica , Pune -- View this message in context: http://r.789695.n4.nabble.com/Warning-message-with-read-csv-sql-tp4636285.html Sent from the R help mailing list archive at Nabble.com.
______________________________________________ R-help at r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
Read the last line about reproducible code.