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.