KevinyhZou opened a new issue, #8995:
URL: https://github.com/apache/incubator-gluten/issues/8995
### Backend
CH (ClickHouse)
### Bug description
sql
```
select
id
from
(
select
id
,row_number() over (partition by id order by id desc) as rank
from test_tbl3
)c1 where rank =1
```
Exception message
```
Caused by: org.apache.gluten.exception.GlutenException: Not found column
col_0 in tuple Tuple()
0. Poco::Exception::Exception(String const&, int) @ 0x0000000016315272
1. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @
0x000000000d348699
2. DB::Exception::Exception(PreformattedMessage&&, int) @ 0x0000000006d27eec
3. DB::Exception::Exception<String const&, String>(int,
FormatStringHelperImpl<std::type_identity<String const&>::type,
std::type_identity<String>::type>, String const&, String&&) @ 0x0000000006dbc00b
4. local_engine::RowNumGroupArraySorted::parseSortOrderFields(String const&)
const @ 0x000000000d99ece1
5.
local_engine::RowNumGroupArraySorted::RowNumGroupArraySorted(std::shared_ptr<DB::IDataType
const>, DB::Array const&) @ 0x000000000d99e548
6. std::shared_ptr<local_engine::RowNumGroupArraySorted>
std::allocate_shared[abi:ne190107]<local_engine::RowNumGroupArraySorted,
std::allocator<local_engine::RowNumGroupArraySorted>,
std::shared_ptr<DB::IDataType const> const&, DB::Array const&,
0>(std::allocator<local_engine::RowNumGroupArraySorted> const&,
std::shared_ptr<DB::IDataType const> const&, DB::Array const&) @
0x000000000d99dace
7. local_engine::createAggregateFunctionRowNumGroupArray(String const&,
std::vector<std::shared_ptr<DB::IDataType const>,
std::allocator<std::shared_ptr<DB::IDataType const>>> const&, DB::Array const&,
DB::Settings const*) @ 0x000000000d99d8d1
8. DB::AggregateFunctionFactory::getImpl(String const&, DB::NullsAction,
std::vector<std::shared_ptr<DB::IDataType const>,
std::allocator<std::shared_ptr<DB::IDataType const>>> const&, DB::Array const&,
DB::AggregateFunctionProperties&, bool) const @ 0x000000000fb0d8b3
9. DB::AggregateFunctionFactory::get(String const&, DB::NullsAction,
std::vector<std::shared_ptr<DB::IDataType const>,
std::allocator<std::shared_ptr<DB::IDataType const>>> const&, DB::Array const&,
DB::AggregateFunctionProperties&) const @ 0x000000000fb0c021
10. local_engine::RelParser::getAggregateFunction(String const&,
std::vector<std::shared_ptr<DB::IDataType const>,
std::allocator<std::shared_ptr<DB::IDataType const>>>,
DB::AggregateFunctionProperties&, DB::Array const&) @ 0x000000000d7bb788
11.
local_engine::AggregateGroupLimitRelParser::buildAggregateDescription(DB::QueryPlan&)
@ 0x000000000d7c7126
12.
local_engine::AggregateGroupLimitRelParser::addGroupLmitAggregationStep(DB::QueryPlan&)
@ 0x000000000d7c1bde
13.
local_engine::AggregateGroupLimitRelParser::parse(std::unique_ptr<DB::QueryPlan,
std::default_delete<DB::QueryPlan>>, substrait::Rel const&,
std::list<substrait::Rel const*, std::allocator<substrait::Rel const*>>&) @
0x000000000d7bd680
14. local_engine::GroupLimitRelParser::parse(std::unique_ptr<DB::QueryPlan,
std::default_delete<DB::QueryPlan>>, substrait::Rel const&,
std::list<substrait::Rel const*, std::allocator<substrait::Rel const*>>&) @
0x000000000d7bce00
15. local_engine::SerializedPlanParser::parseOp(substrait::Rel const&,
std::list<substrait::Rel const*, std::allocator<substrait::Rel const*>>&) @
0x000000000d796329
16. local_engine::SerializedPlanParser::parseOp(substrait::Rel const&,
std::list<substrait::Rel const*, std::allocator<substrait::Rel const*>>&) @
0x000000000d795d79
17. local_engine::SerializedPlanParser::parse(substrait::Plan const&) @
0x000000000d795a0f
18. local_engine::SerializedPlanParser::createExecutor(substrait::Plan
const&) @ 0x000000000d796e4f
19.
Java_org_apache_gluten_vectorized_ExpressionEvaluatorJniWrapper_nativeCreateKernelWithItera
```
### Spark version
None
### Spark configurations
_No response_
### System information
_No response_
### Relevant logs
```bash
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
