(no subject)
Jason Horn wrote:
Does anyone know what this error means: "RS-DBI driver warning: (unrecognized MySQL field type 246 in column 1)"
That the data type in column 1 could not be mapped to a known R type (type here as in "integer", "double", "logical", ...), perhaps MYSQL_TYPE_NEWDATE. If so, a workaround is to extract dates as strings, e.g., SELECT CONVERT(all_months_date USING ASCII) as date, .... and then use you favorite R date/time routine on the output data.frame. HTH, -- David
Here's the script:
query<-paste("select all_months.date as 'date', avg(all_months.count)
as 'counts' from (select date, time, loc, count(sum) as 'count' from
measurements where sum>0 and year(date)=2000 group by date, loc)
all_months group by all_months.date order by 'date'",sep="")
rs <- dbSendQuery(con, query)
data<-fetch(rs, n=-1)
[[alternative HTML version deleted]]
_______________________________________________ R-sig-DB mailing list -- R Special Interest Group R-sig-DB at stat.math.ethz.ch https://stat.ethz.ch/mailman/listinfo/r-sig-db