apache / apache/doris-spark-connector
[Bug] query plan failed detailMessage = Unknown column 'null' in 'table list'
- 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');
### 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
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