apache / apache/doris-spark-connector

[Bug] query plan failed detailMessage = Unknown column 'null' in 'table list'

Open
#338 1 comment 0 reactions 0 assignees View on GitHub
Dominant language
Java
Stars
107
Forks
126
Avg merge
3d 10h
Merged PRs (30d)
4

Description

### Search before asking

- [x] I had searched in the [issues](https://github.com/apache/incubator-doris/issues?q=is%3Aissue) and found no similar issues.

### Version

25.1.0

### What's Wrong?

CREATE OR REPLACE TEMPORARY VIEW `doris_ddd_ods_v318test_atest01`
using doris OPTIONS(
"table.identifier"="ddd.ods_v318test_atest01",
"fenodes"="xxxx",
"user"="uuuu",
"password"="ppp");

select COALESCE(CAST(`A4` AS STRING),'null') from doris_ddd_ods_v318test_atest01 where COALESCE(CAST(`A4` AS STRING),'null') in ('1');

Image

### What You Expected?

cloud not cause a error

### How to Reproduce?

_No response_

### Anything Else?

_No response_

### Are you willing to submit PR?

- [ ] Yes I am willing to submit a PR!

### Code of Conduct

- [x] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct)

Contributor guide

Open the contributing guide

Research direction

No source files or tests are named. Start by reproducing the query-plan failure with Spark and the Doris connector at version 25.1.0, then trace where the reported Unknown column 'null' detail is produced. Done means the query completes without that error and a regression test covers the reported SQL.

Written by the indexing model from the issue text.

Assessment

Tech stack
java, spark, sql
Domain
data-engineering, database
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.