apache / apache/gluten

[CH] Insert error when the partition value contains space letter

Open
#3,678 0 comments 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

`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"`
![image](https://github.com/oap-project/gluten/assets/18643308/099f471b-83b1-49ee-b78e-dc3cf9f906c3)
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

Open the contributing 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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.