[R] RMySQL's column limit

[Mark Van De Vyver]

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.

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