WSCG failed with join and hash agg

[jackylee-ch]

Describe the bug
It seems that it will cause compile failed when there is an aggregation after SMJ.

ArrowColumnarToRow
+- ColumnarHashAggregate(keys=[], functions=[sum(1)])
   +- ArrowCoalesceBatches
      +- ColumnarExchange SinglePartition, ENSURE_REQUIREMENTS, [id=#98], [id=#98], [OUTPUT] List(sum:LongType)
         +- *(1) ColumnarHashAggregate(keys=[], functions=[partial_sum(1)])
            +- *(1) ColumnarSortMergeJoin [tid#7, pid#46], [tid#238, pid#243], Inner, false

[jackylee-ch]

It also failed when then is an aggragation, which does not support WSCG, before SMJ. Here is an example.

ColumnarSortMergeJoin [q#5], [q#671], Inner, false
:- ColumnarSort [q#5 ASC NULLS FIRST], false, 0
:  +- xxxxxxx
+- ColumnarConditionProject (isnotnull(s#662) AND isnotnull(q#671))
   +- ColumnarHashAggregate(keys=[q#671], functions=[first_value(s#669, false), sum(p#695L)], output=[q#671, s#662, mp#663L])

[zhouyuan]

@jackylee-ch

Thanks for debugging, the issue is due to some legacy codegen check in SortMergeJoin - will do clean ups

[jackylee-ch]

Thanks for debugging, the issue is due to some legacy codegen check in SortMergeJoin - will do clean ups

@zhouyuan Thanks for reply. I also find compile failed cases when there is an aggregation after SHJ.