[CH] Insert error when the partition value contains space letter
- Dominant language
- Scala
- Stars
- 1.6k
- Forks
- 657
- Avg merge
- 2d 14h
- Merged PRs (30d)
- 80
Description
### Backend
CH (ClickHouse)
### Bug description
`insert overwrite ... partition(day='2023-11-09 ')`
e.g., if the partition value contains space letter, the generated partition directory is `"day=2023-11-09 " and
"day=2023-11-09%20"`

the data files exist in `"day=2023-11-09%20"`.
### Spark version
None
### Spark configurations
_No response_
### System information
_No response_
### Relevant logs
_No response_
Contributor guide
Research direction
Start by reproducing the INSERT OVERWRITE case with a partition value containing a trailing space in ClickHouse. Trace how the partition directory is generated and compare the paths shown in the report. Done means the data is written to one consistent partition directory and remains readable; no source files or tests are named in the issue.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- clickhouse
- Domain
- databases
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100