HPCC-8686 - Allow global join merge stream to spill

Global join used to merge partitioned side to disk, change to
merge to memory and conditional spill on demand.
Also refactor global join code to remove duplicated code shared
between rightPartition/leftPartition implementations.

Signed-off-by: Jake Smith <jake.smith@lexisnexis.com>
HPCC-8686 - minor change following review
HPCC-10854 Roxie does not retry file resolution once query fails to load

If a query fails to load (because of missing files, the query will stay
suspended until either Roxie is restarted or the query is deleted and
republished.

Add an option to always retry loading queries if they failed to load
correctly (defaults true, but can be disabled in case it causes
performance issues on clusters where there are a lot of suspended
queries).

Also add an option to control:reload to foce retrying of failed queries

Signed-off-by: Richard Chapman <rchapman@hpccsystems.com>
HPCC-8686 - Add left/right partition test

Signed-off-by: Jake Smith <jake.smith@lexisnexis.com>
HPCC-11059 - Pass subscription exception back to client

Invalid subscriptions failed silently.

Signed-off-by: Jake Smith <jake.smith@lexisnexis.com>
HPCC-11053 - Fix regression if keyedjoin fetch file is missing

If using ,OPT on the dataset of an index, there was a
serialization error. Regression introduced by HPCC-10664

Signed-off-by: Jake Smith <jake.smith@lexisnexis.com>
HPCC-11066 Ensure graph overview is not blank

Older graph controls can display a blank graph at level 1 (mostly for simple
graphs).

Fixes HPCC-11066

Signed-off-by: Gordon Smith <gordon.smith@lexisnexis.com>
HPCC-11077 - Avoid RHS sort if isRightAlreadySorted

Signed-off-by: Jake Smith <jake.smith@lexisnexis.com>
Merge pull request #5577 from GordonSmith/HPCC-11066

HPCC-11066 Ensure graph overview is not blank

Reviewed-By: Miguel Vazquez <miguel.vazquez@lexisnexis.com>
Reviewed-By: Richard Chapman <rchapman@hpccsystems.com>
Merge pull request #5572 from jakesmith/hpcc-11053

HPCC-11053 - Fix regression if keyedjoin fetch file is missing

Reviewed-by: Gavin Halliday <ghalliday@hpccsystems.com>
Merge pull request #5501 from jakesmith/hpcc-8686

HPCC-8686 - Allow global join merge stream to spill

Reviewed-by: Gavin Halliday <ghalliday@hpccsystems.com>
Merge pull request #5560 from jakesmith/hpcc-11059

HPCC-11059 - Pass subscription exception back to client

Reviewed-by: Gavin Halliday <ghalliday@hpccsystems.com>
Merge pull request #5578 from jakesmith/hpcc-11077

HPCC-11077 - Avoid RHS sort if isRightAlreadySorted

Reviewed-by: Gavin Halliday <ghalliday@hpccsystems.com>
Merge pull request #5548 from richardkchapman/roxie-recheck-suspended

HPCC-10854 Roxie does not retry file resolution once query fails to load

Reviewed-by: Gavin Halliday <ghalliday@hpccsystems.com>