[R] RMySQL's column limit

[Jeffrey Horner]

Mark Van De Vyver wrote:
> My apologies,
> 
> I'm using R v2.2.1 via the JGR Editor GUI, RMySQL v0.5.7 under windows
> XP with latest patches.
> 
> MySQL is "server version: 4.1.12"
> I'm pretty sure it's running on a linux box.

It turns out that this may be a MySQL limit:

http://bugs.mysql.com/bug.php?id=4117

> 
> The dimension of template is >2000, I know the error kicks in at 3000,
> but haven't iterated to find the exact point - if it would help I can
> do this.
> 
> Regards
> Mark
> 
> On 3/24/06, David James <dj at research.bell-labs.com> wrote:
>> Hi,
>>
>> Mark Van De Vyver wrote:
>>> Dear R-users,
>>> First, thank you to the developers for the very useful R-library RMySQL.
>>>
>>> While using this library a recieved an error message:
>>>
>>> RS-DBI driver: (could not run statement: Too many columns)
>>>
>>> The statement that generated the error was:
>>>
>>> dbWriteTable(dbcon, "simdataseries", template, overwrite = TRUE,
>>> row.names = FALSE )
>>>
>>> I am assuming this is a RMySQL rather than MySQL limit.
>> We need more information, e.g., what's dim(template), what version
>> of MySQL you're using, etc.
>>
>>> If that is the case I was wondering just what this limit is and if it
>>> is possible to raise it?
>>>
>>> Thanks again for all the hard work.
>>>
>>> Sincerely
>>> Mark
>>>
>>> --
>>> Mark Van De Vyver, PhD
>>> --------------------------------------------------
>>> My research is available from my SSRN Author page:
>>> http://ssrn.com/author=36577
>>> --------------------------------------------------
>>> Finance Discipline
>>> School of Business
>>> The University of Sydney
>>> Sydney NSW 2006
>>> Australia
>>>
>>> Telephone: +61 2 9351-6452
>>> Fax: +61 2 9351-6461
>>>
>>>
>>> --
>>> Mark Van De Vyver, PhD
>>> --------------------------------------------------
>>> My research is available from my SSRN Author page:
>>> http://ssrn.com/author=36577
>>> --------------------------------------------------
>>> Finance Discipline
>>> School of Business
>>> The University of Sydney
>>> Sydney NSW 2006
>>> Australia
>>>
>>> Telephone: +61 2 9351-6452
>>> Fax: +61 2 9351-6461
>>>
>>> ______________________________________________
>>> R-help at stat.math.ethz.ch mailing list
>>> https://stat.ethz.ch/mailman/listinfo/r-help
>>> PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
>> --
>> David
>>
> 
> 
> --
> Mark Van De Vyver, PhD
> --------------------------------------------------
> My research is available from my SSRN Author page:
> http://ssrn.com/author=36577
> --------------------------------------------------
> Finance Discipline
> School of Business
> The University of Sydney
> Sydney NSW 2006
> Australia
> 
> Telephone: +61 2 9351-6452
> Fax: +61 2 9351-6461
> 
> ______________________________________________
> R-help at stat.math.ethz.ch mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html

-- 
Jeffrey Horner       Computer Systems Analyst         School of Medicine
615-322-8606         Department of Biostatistics   Vanderbilt University