apache / apache/gluten

[CH] TPCDS q14b Type mismatch of columns to JOIN

Open
#4,873 1 comment 0 reactions 0 assignees View on GitHub
bug triage
Dominant language
Scala
Stars
1.6k
Forks
657
Avg merge
2d 14h
Merged PRs (30d)
80

Description

### Backend

CH (ClickHouse)

### Bug description

```
24/03/06 23:16:23 WARN [task-result-getter-1] TaskSetManager: Lost task 3.0 in stage 412.0 (TID 56244) (core-1-6.c-59962a4a9d28d8c9.cn-hangzhou.emr.aliyuncs.com executor 6): io.glutenproject.exception.GlutenException: Type mismatch of columns to JOIN by: i_brand_id#40998 :: Int32 at left, store_8 :: String at right
0. /mnt/disk1/code/github/gluten/cpp-ch/build/./src/Common/Exception.cpp:96: DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000601b4bb in /opt/apps/ch/libch.so
1. ./contrib/llvm-project/libcxx/include/string:1499: DB::Exception::Exception(int, FormatStringHelperImpl::type, std::type_identity::type, std::type_identity::type, std::type_identity::type>, String const&, String&&, String const&, String&&) @ 0x000000000f4f6301 in /opt/apps/ch/libch.so
2. /mnt/disk1/code/github/gluten/cpp-ch/build/./src/Interpreters/JoinUtils.cpp:0: DB::JoinCommon::checkTypesOfKeys(DB::Block const&, std::vector> const&, DB::Block const&, std::vector> const&) @ 0x000000000f8356e9 in /opt/apps/ch/libch.so
3. ./contrib/llvm-project/libcxx/include/__iterator/wrap_iter.h:158: DB::HashJoin::checkTypesOfKeys(DB::Block const&) const @ 0x000000000f325582 in /opt/apps/ch/libch.so
4. ./contrib/llvm-project/libcxx/include/__memory/shared_ptr.h:815: DB::JoiningTransform::transformHeader(DB::Block, std::shared_ptr const&) @ 0x000000001015ebb0 in /opt/apps/ch/libch.so
5. /mnt/disk1/code/github/gluten/cpp-ch/build/./src/Processors/QueryPlan/JoinStep.cpp:104: DB::JoinStep::updateOutputStream() @ 0x00000000102a62e4 in /opt/apps/ch/libch.so
6. /mnt/disk1/code/github/gluten/cpp-ch/build/./src/Processors/QueryPlan/JoinStep.cpp:50: DB::JoinStep::JoinStep(DB::DataStream const&, DB::DataStream const&, std::shared_ptr, unsigned long, unsigned long, bool) @ 0x00000000102a496c in /opt/apps/ch/libch.so
7. ./contrib/llvm-project/libcxx/include/string:1570: local_engine::JoinRelParser::parseJoin(substrait::JoinRel const&, std::unique_ptr>, std::unique_ptr>) @ 0x00000000062c81d6 in /opt/apps/ch/libch.so
8. /mnt/disk1/code/github/gluten/cpp-ch/build/./utils/extern-local-engine/Parser/JoinRelParser.cpp:154: local_engine::JoinRelParser::parseOp(substrait::Rel const&, std::list>&) @ 0x00000000062c35c9 in /opt/apps/ch/libch.so
9. ./contrib/llvm-project/libcxx/include/__memory/unique_ptr.h:303: local_engine::SerializedPlanParser::parseOp(substrait::Rel const&, std::list>&) @ 0x0000000006336611 in /opt/apps/ch/libch.so
10. /mnt/disk1/code/github/gluten/cpp-ch/build/./utils/extern-local-engine/Parser/RelParser.cpp:70: local_engine::RelParser::parseOp(substrait::Rel const&, std::list>&) @ 0x00000000062e84f8 in /opt/apps/ch/libch.so
11. ./contrib/llvm-project/libcxx/include/__memory/unique_ptr.h:303: local_engine::SerializedPlanParser::parseOp(substrait::Rel const&, std::list>&) @ 0x0000000006336611 in /opt/apps/ch/libch.so
12. /mnt/disk1/code/github/gluten/cpp-ch/build/./utils/extern-local-engine/Parser/RelParser.cpp:70: local_engine::RelParser::parseOp(substrait::Rel const&, std::list>&) @ 0x00000000062e84f8 in /opt/apps/ch/libch.so
13. ./contrib/llvm-project/libcxx/include/__memory/unique_ptr.h:303: local_engine::SerializedPlanParser::parseOp(substrait::Rel const&, std::list>&) @ 0x0000000006336611 in /opt/apps/ch/libch.so
14. ./contrib/llvm-project/libcxx/include/__memory/unique_ptr.h:303: local_engine::SerializedPlanParser::parseOp(substrait::Rel const&, std::list>&) @ 0x0000000006336c79 in /opt/apps/ch/libch.so
15. /mnt/disk1/code/github/gluten/cpp-ch/build/./utils/extern-local-engine/Parser/SerializedPlanParser.cpp:0: local_engine::SerializedPlanParser::parse(String const&) @ 0x000000000634816d in /opt/apps/ch/libch.so
16. /mnt/disk1/code/github/gluten/cpp-ch/build/./utils/extern-local-engine/local_engine_jni.cpp:277: Java_io_glutenproject_vectorized_ExpressionEvaluatorJniWrapper_nativeCreateKernelWithIterator @ 0x0000000005fb98e6 in /opt/apps/ch/libch.so
```

### Spark version

None

### Spark configurations

_No response_

### System information

_No response_

### Relevant logs

_No response_

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.