apache / apache/datafusion

Use `_dyn` and `_scalar_dyn` for operations `like`, `ilike`, `nlike`, and `nilike` to support Dictionary and LargeStringArray

Open
#5,222 0 comments 0 reactions 0 assignees View on GitHub
enhancement
Dominant language
Rust
Stars
9.3k
Forks
2.4k
Avg merge
3d 7h
Merged PRs (30d)
344

Description

**Is your feature request related to a problem or challenge? Please describe what you are trying to do.**

DataFusion doesn't allow Dictionaries or LargeStringArrays in like comparison operations. This functionality is already included in Arrow.

**Describe the solution you'd like**

Arrow provides operations on StringArray / LargeStringArray, or DictionaryArray with values StringArray / LargeStringArray, with support for comparisons against another array or a scalar. The current `Like` implementation doesn't support all of these combinations. In addition, the check in the physical expressions doesn't use coercion rules when validating the request.

Contributor guide

Open the contributing guide

Research direction

Locate the current Like implementation and the physical-expression validation for like, ilike, nlike, and nilike. Compare their accepted combinations with Arrow's StringArray, LargeStringArray, and DictionaryArray operations; done means dictionary and large-string values work for array and scalar comparisons with coercion-aware validation.

Written by the indexing model from the issue text.

Assessment

Tech stack
rust
Domain
data
Issue type
Feature
Difficulty
3/5
Estimated time
1-2 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
48/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.