R help - Nov 2010 - sqldf hanging on macintosh - works on windows

Have a long script that runs fine on windows (32 bit). When I try to run in
on two different macs (64 bit), however, it hangs with identical behavior.

I start with:
library(sqldf)

This results in messages:
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

I then read some data, etc.

I execute the following:

#merge raw data and all possible combinations
  df.final <- sqldf('select Date, Hour, x as RoomsInUse from
"df.possible.combos"
    left join "df.aggregate" using (Hour, Date)')

I receive the messages:
Loading required package: tcltk
Loading Tcl/Tk interface ... 
+ 

Then I get into some kind of loop. Message at bottom ribbon says:

executing:
try(gsub('\\s+','',paste(capture.output(print(arg(summary))),collapse=")),silent=TRUE)

On the pc implementation it runs flawlessly, and quickly. 

Truly appreciate any ideas.

-- 
View this message in context:
http://r.789695.n4.nabble.com/sqldf-hanging-on-macintosh-works-on-windows-tp3022193p3022193.html
Sent from the R help mailing list archive at Nabble.com.

On Mon, Nov 1, 2010 at 9:59 AM, GL <pflugg at shands.ufl.edu>
wrote:
>
> Have a long script that runs fine on windows (32 bit). When I try to run in
> on two different macs (64 bit), however, it hangs with identical behavior.
>
> I start with:
> library(sqldf)
>
> This results in messages:
> 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
>
> I then read some data, etc.
>
> I execute the following:
>
> #merge raw data and all possible combinations
> ?df.final <- sqldf('select Date, Hour, x as RoomsInUse from
> "df.possible.combos"
> ? ?left join "df.aggregate" using (Hour, Date)')
>
> I receive the messages:
> Loading required package: tcltk
> Loading Tcl/Tk interface ...
> +
>
> Then I get into some kind of loop. Message at bottom ribbon says:
>
> executing:
>
try(gsub('\\s+','',paste(capture.output(print(arg(summary))),collapse=")),silent=TRUE)
>
That is not a line that appears in the sqldf source code.  Try these
suggestions anyways:

http://permalink.gmane.org/gmane.comp.lang.r.general/209443


-- 
Statistics & Software Consulting
GKX Group, GKX Associates Inc.
tel: 1-877-GKX-GROUP
email: ggrothendieck at gmail.com