[R] Warning message with read.csv.sql

Uwe Ligges ligges at statistik.tu-dortmund.de
Tue Jul 17 20:41:33 CEST 2012



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.
>
>



More information about the R-help mailing list