Zhichao Zhang

I ran the below sql and the Spark UI show the DAG below: ``` select count(date_sk) from ( select d_date_sk as date_sk from date_dim union all select ws_sold_date_sk as date_sk...

please rebase to main and add some ut.

please refer to [gluten-ut](https://github.com/oap-project/gluten/tree/main/gluten-ut) module or the test cases in https://github.com/oap-project/gluten/tree/main/backends-clickhouse/src/test/scala/io/glutenproject/execution

this is duplicate with PR #451

There is already a pr for these feature #371 , please re-check.

Please rebase and re-test. Also move test case to gluten-ut module ? After CH Backend supports these expression and reuse test cases.

> > Please rebase and re-test. > > Also move test case to gluten-ut module ? After CH Backend supports these expression and reuse test cases. > > Have re-tested....

just one comment, others LGTM.

@ashwini-krishnakumar I met the same problem and raised a pr to fix this issue, please help to review [PR#1962](https://github.com/apache/carbondata/pull/1962)

@ashwini-krishnakumar I run your test cases with my pr and all are passed too.