opensearch-project/sql

View on GitHub

Query your data using familiar SQL or intuitive Piped Processing Language (PPL)

Stars: 176
Forks: 229
Open beginner issues: 0
Indexed issues: 280
Avg merge: 2d 21h
Merged PRs (30d): 43

Dominant language: Java
License: Apache-2.0
Last GitHub push: Sep 18, 2026
Latest indexed: Sep 19, 2026
Contributing guide: Contributing guide
Code of conduct: Code of conduct
Beginner labels: good first issue

Beginner friendly Everything

Open All

280 open issues indexed

[BUG][Umbrella] Array values are not treated as atomic values in SQL/PPL operations Open

bug PPL

Difficulty 5/5 Over a week Newbie friendliness 30/100

opensearch-project/sql#5333 · 1 comment · 1 reaction · Opened Apr 10, 2026
[FEATURE] Add JDBC driver integration tests to SQL plugin CI Open

enhancement infrastructure

opensearch-project/sql#5321 · 1 assignee · Opened Apr 7, 2026
Calcite Janino compilation fails when analytics-engine is parent classloader via extendedPlugins Open

calcite

Difficulty 4/5 3-5 days Newbie friendliness 35/100

opensearch-project/sql#5306 · 1 comment · Opened Apr 2, 2026
[RELEASE] Release version 3.7.0 Open

v3.7.0

opensearch-project/sql#5292 · 1 assignee · Opened Mar 31, 2026
[META] Error Handling Enhancements Open

error-experience PPL RFC

opensearch-project/sql#5261 · 1 assignee · Opened Mar 24, 2026
[RFC] PPL `cluster` Command Open

enhancement PPL RFC

opensearch-project/sql#5255 · 2 comments · 1 assignee · Opened Mar 23, 2026
[BUG] Prometheus query API does not support scalar Open

bug prometheus

opensearch-project/sql#5251 · 1 assignee · Opened Mar 19, 2026
[BUG] Unified query API fails with date types Open

bug PPL

opensearch-project/sql#5250 · 5 comments · 1 assignee · Opened Mar 19, 2026
[PERF][Regression: 3.4 -> 3.6] Composite bucket aggregation is expensive Open

performance PPL

Difficulty 5/5 Over a week Newbie friendliness 38/100

opensearch-project/sql#5249 · Opened Mar 18, 2026
[FEATURE] SQL query support for Analytics engine integration Open

enhancement Meta SQL

opensearch-project/sql#5248 · 5 comments · 1 assignee · Opened Mar 18, 2026
[FEATURE] PPL query support for Analytics engine integration Open

enhancement PPL

opensearch-project/sql#5247 · 1 comment · 1 assignee · Opened Mar 18, 2026
[FEATURE] SQL/PPL language support for Analytics engine integration Open

Meta

opensearch-project/sql#5246 · 3 comments · 1 assignee · Opened Mar 18, 2026
[RFC] Reintroduce JSON formats for OpenSearch SQL & PPL Open

feature RFC

Difficulty 5/5 Over a week Newbie friendliness 35/100

opensearch-project/sql#5245 · 2 comments · 2 reactions · Opened Mar 18, 2026
[DOC] Add Getting Started Tutorial Open

documentation PPL

opensearch-project/sql#5200 · 1 reaction · 1 assignee · Opened Mar 4, 2026
RFC: Pluggable SQL Dialect Framework Open

RFC SQL

Difficulty 5/5 Over a week Newbie friendliness 25/100

opensearch-project/sql#5184 · 1 comment · Opened Feb 25, 2026
[FEATURE] `isnotempty` function Open

enhancement good first issue PPL

opensearch-project/sql#5182 · 4 comments · 1 assignee · Opened Feb 24, 2026
[BUG] eventstats/streamstats reject window functions that grammar accepts Open

error-experience PPL

Difficulty 3/5 1-2 days Newbie friendliness 52/100

opensearch-project/sql#5168 · 2 comments · Opened Feb 23, 2026
[FEATURE] PPL Add time modifiers to the multisearch command Open

enhancement PPL

Difficulty 4/5 3-5 days Newbie friendliness 48/100

opensearch-project/sql#5148 · 3 comments · Opened Feb 16, 2026
[RFC] xyseries command implementation in PPL Open

PPL RFC

opensearch-project/sql#5142 · 7 comments · 1 assignee · Opened Feb 12, 2026
[AUTOCUT] Distribution Build Failed for sql-3.5.0 Open

autocut v3.5.0

Difficulty 4/5 3-5 days Newbie friendliness 25/100

opensearch-project/sql#5126 · Opened Feb 7, 2026
[RELEASE] Release version 3.6.0 Open

v3.6.0

opensearch-project/sql#5117 · 1 assignee · Opened Feb 6, 2026
[RFC] 200x faster joins with key pre-filtering Open

calcite performance RFC

Difficulty 5/5 Over a week Newbie friendliness 35/100

opensearch-project/sql#5093 · 4 comments · Opened Jan 30, 2026
Optimizer: Unwrap CAST/SAFE_CAST in binary comparisons to enable filter pushdown (Spark parity) Open

PPL

opensearch-project/sql#5083 · 1 assignee · Opened Jan 29, 2026
[FEATURE] Support pushdown `collect/array_agg` aggregation Open

enhancement PPL pushdown

opensearch-project/sql#5070 · 1 assignee · Opened Jan 26, 2026
[FEATURE] Unify async query PPL processing via unified query API Open

enhancement maintenance

opensearch-project/sql#5069 · 1 assignee · Opened Jan 23, 2026
[FEATURE] Unify PPL Calcite V3 processing via unified query API Open

enhancement maintenance

opensearch-project/sql#5068 · 1 comment · 1 assignee · Opened Jan 23, 2026
[BUG] Calcite PPL doesn't handle array value columns if codegen triggered Open

error-experience PPL

Difficulty 4/5 3-5 days Newbie friendliness 55/100

opensearch-project/sql#5065 · 2 comments · Opened Jan 22, 2026
[BUG] Cannot pushdown a nested root as group-by key Open

performance PPL pushdown

Difficulty 4/5 3-5 days Newbie friendliness 35/100

opensearch-project/sql#5006 · Opened Dec 30, 2025
[BUG] dedup pushdown should not change the final output document order if order specified before `dedup` Open

bug pushdown

opensearch-project/sql#5004 · 1 comment · 2 reactions · 1 assignee · Opened Dec 29, 2025
[RFC] PPL `convert` Command Open

PPL RFC

opensearch-project/sql#5001 · 4 comments · 1 reaction · 1 assignee · Opened Dec 26, 2025
[RELEASE] Release version 3.5.0 Open

v3.5.0

Difficulty 5/5 Over a week Newbie friendliness 15/100

opensearch-project/sql#4987 · 3 comments · 1 reaction · Opened Dec 23, 2025
[RFC] Support Schema-on-Read in PPL Open

PPL RFC

opensearch-project/sql#4984 · 8 comments · 1 reaction · 1 assignee · Opened Dec 22, 2025
[BUG] Correct bin command implementation to pass validation Open

feature PPL

Difficulty 4/5 3-5 days Newbie friendliness 45/100

opensearch-project/sql#4973 · 2 comments · 1 reaction · Opened Dec 18, 2025
[BUG] Make return type inferrable for TRANSFORM and other lambda functions Open

enhancement PPL

opensearch-project/sql#4972 · 2 comments · 1 reaction · 1 assignee · Opened Dec 18, 2025
[FEATURE] Enhance patterns command output structure for easy type validation Open

calcite enhancement PPL

Difficulty 5/5 Over a week Newbie friendliness 25/100

opensearch-project/sql#4968 · 1 comment · Opened Dec 17, 2025
[FEATURE] Reduce boilerplate for adding new PPL commands and functions Open

maintenance PPL

Difficulty 5/5 Over a week Newbie friendliness 25/100

opensearch-project/sql#4960 · 5 comments · Opened Dec 15, 2025
Optimize type casting workaround in addtotals/addcoltotals aggregation logic Open

PPL

opensearch-project/sql#4952 · 1 assignee · Opened Dec 12, 2025
[BUG] PPL query return null when access valid inner json object Open

bug PPL

opensearch-project/sql#4906 · 5 comments · 1 assignee · Opened Dec 4, 2025
[FEATURE] Per-request timeouts Open

enhancement

Difficulty 4/5 3-5 days Newbie friendliness 45/100

opensearch-project/sql#4886 · Opened Dec 1, 2025
[FEATURE] Unclear PPL error message: Empty mapping on wildcard indices Open

enhancement error-experience PPL

opensearch-project/sql#4872 · 3 comments · 1 assignee · Opened Nov 26, 2025
[FEATURE] Investigation on enable top-down optimizer in Calcite Open

enhancement wontfix

Difficulty 5/5 Over a week Newbie friendliness 25/100

opensearch-project/sql#4859 · 4 comments · Opened Nov 26, 2025
[FEATURE] Preserve identifier type information in anonymizer Open

enhancement

Difficulty 4/5 3-5 days Newbie friendliness 42/100

opensearch-project/sql#4855 · 2 comments · Opened Nov 24, 2025
[BUG] Cardinality aggregate query failed with Data too large for [<reused_arrays>] Open

bug clickbench dependencies PPL

opensearch-project/sql#4834 · 1 assignee · Opened Nov 20, 2025
[BUG] `doc_count` values for a terms/multi-terms aggregation is approximate Open

aggregation bug clickbench dependencies PPL

opensearch-project/sql#4833 · 3 comments · 1 assignee · Opened Nov 20, 2025
[META] Correctness of PPL queries on Clickbench Open

clickbench data-correctness Meta PPL

opensearch-project/sql#4832 · 1 comment · 1 assignee · Opened Nov 20, 2025
[RFC] OLAP—A OS SQL Query Solution Plugin Open

calcite PPL RFC

opensearch-project/sql#4812 · 21 comments · 16 reactions · 1 assignee · Opened Nov 14, 2025
[DOC] Calcite settings documentation missing examples Open

documentation PPL

Difficulty 2/5 1-3 hours Newbie friendliness 72/100

opensearch-project/sql#4806 · 1 comment · Opened Nov 13, 2025
[FEATURE] Scope OpenSearch-only PPL functions to OpenSearch adapter & data sources Open

enhancement feature PPL

Difficulty 5/5 Over a week Newbie friendliness 35/100

opensearch-project/sql#4769 · Opened Nov 10, 2025
[FEATURE] Support pushdown for subaggregation in PPL Open

enhancement PPL

Difficulty 5/5 Over a week Newbie friendliness 30/100

opensearch-project/sql#4762 · Opened Nov 8, 2025
[FEATURE] Enrichment Explain Extended Results Open

enhancement PPL

Difficulty 5/5 Over a week Newbie friendliness 35/100

opensearch-project/sql#4660 · Opened Oct 24, 2025

opensearch-project/sql

Get new issues in your inbox