[R] sqldf hanging on macintosh - works on windows
ggrothendieck at gmail.com
Mon Nov 1 17:56:50 CET 2010
On Mon, Nov 1, 2010 at 12:10 PM, Marc Schwartz <marc_schwartz at me.com> wrote:
> On Nov 1, 2010, at 10:55 AM, Gabor Grothendieck wrote:
>> On Mon, Nov 1, 2010 at 10:55 AM, GL <pflugg at shands.ufl.edu> wrote:
>>> Loading required package: DBI
>>> Loading required package: RSQLite
>>> Loading required package: RSQLite.extfuns
>>> Loading required package: gsubfn
>>> Loading required package: proto
>>> Loading required package: chron
>>>> df.final <- sqldf('select Date, Hour, x as RoomsInUse from
>>> + left join "df.aggregate" using (Hour, Date)')
>>> debugging in: sqldf("select Date, Hour, x as RoomsInUse from
>>> debug: words. <- words <- strapply(x, "[[:alnum:]._]+")
>>> Loading required package: tcltk
>>> Loading Tcl/Tk interface ...
>> There is something wrong with tcltk on your system. You can tell it
>> not to use tcltk by setting the appropriate option as discussed in
>> sqldf FAQ #5:
> If you installed R using the OSX binary from CRAN, it does not include tcl/tk. You need to install the separate tcltk package that Simon has put together and is available from:
> You also need to have X11 installed, which is available from the OSX DVD in the Optional Installs section.
> Marc Schwartz
Note that sqldf can work without tcltk, as well. The gsubfn package
does check for tcltk and and sets the engine to "R" rather than
is FALSE. There may be a bug in R or a problem with the installation.
Statistics & Software Consulting
GKX Group, GKX Associates Inc.
email: ggrothendieck at gmail.com
More information about the R-help