apache / apache/gluten

[CH] Unsupported function overlay and without fallback

Open
#5,194 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

SQL:
```
select overlay(LSTG_FORMAT_NAME PLACING 'abc' FROM 1),
overlay(LSTG_FORMAT_NAME PLACING 'abc' FROM 1 FOR 1)
from test_kylin_fact
```

Error:
![image](https://github.com/apache/incubator-gluten/assets/23639010/b7636572-69f5-4e12-9c69-3ae882cd5d5f)

Sig[Overlay](OVERLAY) is defined in ExpressionMappings, but there is no function mapping defined in CH backend

### 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 inspecting ExpressionMappings and the ClickHouse backend mapping for Overlay. Reproduce the supplied SQL with both overlay forms, then verify that the ClickHouse backend handles the function and its optional FOR clause without the reported unsupported-function error.

Written by the indexing model from the issue text.

Assessment

Tech stack
clickhouse, sql
Domain
databases
Issue type
Bug
Difficulty
3/5
Estimated time
1-2 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.