Results 4 comments of Vojtech Kurka

OK, so can I force SQ to use the "temp" schema for aggregate tables? My use case is simple: just one server, two schemas - "archive" with data and "temp"...

I think all these operations can be done in a cross-schema fashion: CREATE TABLE temp.aggr.... .. AS SELECT .... FROM mydb.mytable ..... I _have_ the schemas on the same mysqld...