awakeljw

There is a LLVM ERROR,because too many template expansions in joinRightColumns function. Can we enlarge the LLVM memory limit? Jun 14 11:43:55 FAILED: src/CMakeFiles/dbms.dir/Interpreters/HashJoin.cpp.o Jun 14 11:43:55 prlimit --as=10000000000 --data=5000000000...

> @awakeljw optimization makes sense. Need to wait for performance tests output. @kitaisreal performance tests have output. I set max_merged_block_bytes_in_join to 1G by default. There is a average performance improvement...

@Mergifyio update

@vdimir I have rebased the code. there is performance improvement by 10%-20% in joins_innerjoin_opt performance test.

> Trying to continue and implement the idea of squashing data into a single block and using `insertIndicesFrom` according to the current master state in #64296 @vdimir I don't have...

@vdimir The failed test "02680_mysql_ast_logical_err" is not related to this pr. In performance test, we have 20% performance improvement in hash_join_large_ouput test. By the way, should we set max_merged_block_bytes_in_join to...