apache / apache/druid

Reconcile SQL MV function behavior on SQL arrays

Open
#10,052 0 comments 0 reactions 0 assignees View on GitHub
Area - SQL
Dominant language
Java
Stars
14.1k
Forks
3.8k
Avg merge
2d 58m
Merged PRs (30d)
233

Description

The docs say that SQL MV_* functions all work on arrays:

> All 'array' references in the multi-value string function documentation can refer to multi-value string columns or ARRAY literals.

But it isn't true. Many of them (MV_SLICE, MV_CONCAT, others) have signatures that do not accept SQL ARRAY types. We should either make these functions work on SQL ARRAYs, or update the docs to say that they do not.

Contributor guide

Open the contributing guide

Research direction

Start by comparing the multi-value string function documentation with the SQL signatures for MV_SLICE, MV_CONCAT, and the other affected MV_* functions. Determine whether the documented ARRAY behavior or the function support should change; done means the documentation and SQL ARRAY behavior consistently describe the same supported set.

Written by the indexing model from the issue text.

Assessment

Tech stack
java, sql
Domain
databases, documentation
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
40/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.