[ASTERIXDB-2784] Handling large objects in join

    - user model changes: no
    - storage format changes: no
    - interface changes: no

    Details:
    - Do not allow the spilled partitions to get more than one regular
    frame in hybrid hash join and flush the big objects mapped to
    spilled partitions directly to the disk.
    - Decreasing the join memory to the value before change
    8123:[ASTERIXDB-2783] Fix hash collision for hash join/groupby.

Change-Id: I9b5a2d25cd95e880264d70624aeb88302714989f
Reviewed-on: https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/8463
Integration-Tests: Jenkins <jenkins@fulliautomatix.ics.uci.edu>
Tested-by: Jenkins <jenkins@fulliautomatix.ics.uci.edu>
Reviewed-by: Ali Alsuliman <ali.al.solaiman@gmail.com>
diff --git a/asterixdb/asterix-app/src/test/resources/cc-ssl.conf b/asterixdb/asterix-app/src/test/resources/cc-ssl.conf
index d67da13..47171e0 100644
--- a/asterixdb/asterix-app/src/test/resources/cc-ssl.conf
+++ b/asterixdb/asterix-app/src/test/resources/cc-ssl.conf
@@ -62,7 +62,7 @@
 compiler.framesize=32KB
 compiler.sortmemory=320KB
 compiler.groupmemory=160KB
-compiler.joinmemory=768KB
+compiler.joinmemory=256KB
 compiler.textsearchmemory=160KB
 compiler.windowmemory=192KB
 messaging.frame.size=4096