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

PPL (Calcite/v3): valid Unicode string literals and invalid function arguments return HTTP 500 instead of 4xx Open

untriaged

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

opensearch-project/sql#5773 · Opened Sep 15, 2026
[FEATURE] PPL Partial Results Open

enhancement PPL

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

opensearch-project/sql#5765 · 1 comment · Opened Sep 11, 2026
[BUG] Binary fields return 500 or silently wrong results when a pushdown references them Open

bug

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

opensearch-project/sql#5757 · Opened Sep 9, 2026
[RFC] Integration tests should cover the command x data-type matrix Open

enhancement PPL RFC testing

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

opensearch-project/sql#5754 · Opened Sep 8, 2026
[BUG] Janino compile failures return the query plan in the error response Open

bug error-experience good first issue PPL

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

opensearch-project/sql#5753 · Opened Sep 8, 2026
[BUG] Object-vs-scalar mapping conflict across a wildcard resolves nondeterministically (last-write-wins) Open

bug PPL

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

opensearch-project/sql#5752 · Opened Sep 8, 2026
[BUG] Projecting a nested subfield returns only the first child Open

bug PPL

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

opensearch-project/sql#5748 · Opened Sep 3, 2026
[BUG] Filters on nested fields return wrong results due to uncorrelated predicates Open

bug PPL

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

opensearch-project/sql#5747 · Opened Sep 3, 2026
[BUG] Duplicate fields returned when disable_objects set Open

bug PPL

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

opensearch-project/sql#5746 · 1 comment · Opened Sep 3, 2026
[TEST] Add a multi-shard integration test CI lane Open

PPL testing

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

opensearch-project/sql#5738 · Opened Sep 2, 2026
[BUG] plugins.ppl.values.max.limit cannot be honored on the Analytics Engine route (no binding for array_agg(DISTINCT x, limit)) Open

analytic-engine bug PPL

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

opensearch-project/sql#5736 · Opened Sep 1, 2026
[BUG] PPL subsearch maxout settings do not apply on the Analytics Engine path (diverges at defaults) Open

analytic-engine bug design PPL

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

opensearch-project/sql#5735 · Opened Sep 1, 2026
[BUG] plugins.calcite.all_join_types.allowed guardrail is inactive on the Analytics Engine path Open

analytic-engine bug PPL

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

opensearch-project/sql#5734 · Opened Sep 1, 2026
[BUG] PPL FIRST/LAST/TAKE appear to ignore a preceding sort on multi-shard indices Open

bug

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

opensearch-project/sql#5716 · 1 comment · Opened Aug 24, 2026
[RFC] Extend Analytics Engine execution to regular indices for analytical SQL/PPL queries Open

RFC

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

opensearch-project/sql#5713 · 1 comment · Opened Aug 21, 2026
[FEATURE] Enable Calcite-only PPL commands (join, lookup, etc.) for Prometheus datasources Open

enhancement

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

opensearch-project/sql#5705 · 3 comments · Opened Aug 19, 2026
[FEATURE] Storing OpenTelemetry map<string, AnyValue> fields in OpenSearch Open

enhancement PPL

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

opensearch-project/sql#5704 · 1 comment · Opened Aug 19, 2026
[FEATURE] Improve PIT usage for large queries over wildcard index patterns Open

enhancement

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

opensearch-project/sql#5698 · 2 comments · Opened Aug 13, 2026
[RELEASE] Release version 3.9.0 Open

v3.9.0

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

opensearch-project/sql#5693 · Opened Aug 8, 2026
Integration test suite duration (~5 hours 40 minutes) - identify optimization opportunities Open

infrastructure

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

opensearch-project/sql#5690 · 2 comments · Opened Aug 7, 2026
[BUG] PPL returns HTTP 200 with silently partial results when shards fail (no _shards failure surfaced) Open

bug PPL

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

opensearch-project/sql#5687 · Opened Aug 6, 2026
[BUG] PromQL queries fail with InvalidTypeIdException when metric has a label named "type" Open

bug

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

opensearch-project/sql#5684 · 4 comments · Opened Aug 6, 2026
[BUG] Date range filter on a date field falls back to a per-document script instead of a native range when the field is wrapped in timestamp() / CAST(... AS TIMESTAMP) Open

bug PPL

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

opensearch-project/sql#5680 · 1 comment · Opened Aug 5, 2026
[FEATURE] Integrate SQL/PPL with query-insights plugin for query source tracking Open

enhancement feature

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

opensearch-project/sql#5677 · Opened Aug 5, 2026
[BUG] Simple `top` queries on high-cardinality fields are very slow Open

bug calcite performance PPL pushdown

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

opensearch-project/sql#5673 · 1 comment · Opened Aug 3, 2026
[BUG] Mustang Profile API Inconsistencies Open

bug

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

opensearch-project/sql#5672 · Opened Aug 3, 2026
[BUG] PPL query with `mvindex()` fails when `plugins.calcite.pushdown.enabled=true` Open

bug calcite PPL

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

opensearch-project/sql#5660 · 4 comments · Opened Jul 28, 2026
[BUG] Request-level filter is ignored for aggregation queries (`COUNT`) but applied for regular `SELECT` Open

bug

opensearch-project/sql#5649 · 1 comment · 1 assignee · Opened Jul 23, 2026
[BUG] Zombie tasks on PPL cancellation Open

bug

opensearch-project/sql#5647 · 1 assignee · Opened Jul 22, 2026
[FEATURE] Optimization phase caching Open

calcite enhancement performance PPL RFC

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

opensearch-project/sql#5645 · Opened Jul 22, 2026
[RFC] PPL multikv command — extract rows from a field Open

calcite

opensearch-project/sql#5640 · 3 comments · 1 assignee · Opened Jul 21, 2026
[FEATURE] Support field aliases that target text multi-fields in SQL/PPL Open

SQL

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

opensearch-project/sql#5632 · Opened Jul 16, 2026
[RFC] PPL outputlookup command (write search results to a lookup) Open

RFC

opensearch-project/sql#5625 · 1 assignee · Opened Jul 15, 2026
[BUG] Dedup crashes with ClassCastException Open

bug PPL

opensearch-project/sql#5614 · 1 assignee · Opened Jul 10, 2026
[FEATURE] Define a schema-conflict and mismatched-data handling policy for multi-index queries Open

enhancement

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

opensearch-project/sql#5610 · 3 comments · Opened Jul 6, 2026
[PPL] timewrap: support series=exact with time_format for period column naming Open

enhancement PPL

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

opensearch-project/sql#5606 · Opened Jul 2, 2026
[RFC] A scalable way to test PPL command combinations and pushdown Open

enhancement PPL RFC

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

opensearch-project/sql#5598 · 4 comments · Opened Jun 30, 2026
[RFC] PPL `collect` command Open

calcite

opensearch-project/sql#5596 · 1 assignee · Opened Jun 30, 2026
[RELEASE] Release version 3.8.0 Open

v3.8.0

opensearch-project/sql#5595 · 1 assignee · Opened Jun 30, 2026
[RFC] Better Command-Chain Testing with Index Views Open

infrastructure PPL RFC

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

opensearch-project/sql#5505 · 8 comments · Opened Jun 2, 2026
[RFC] Query Insights: Profile and Analyze for PPL/SQL Open

calcite feature performance RFC

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

opensearch-project/sql#5500 · 1 comment · Opened Jun 2, 2026
[Enhancement] Fuse REX_EXTRACT calls that share (field, pattern) to a single Matcher invocation Open

performance PPL

opensearch-project/sql#5499 · 1 assignee · Opened Jun 2, 2026
[BUG/PERF] `LIKE` and relevance-function pushdown gaps on Calcite engine Open

calcite performance PPL

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

opensearch-project/sql#5491 · Opened May 29, 2026
[BUG] eventstats does not push down to OpenSearch (RexOver excluded from aggregation pushdown) Open

bug performance PPL

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

opensearch-project/sql#5483 · 4 comments · Opened May 28, 2026
verifyPPLToSparkSQL pins invalid Spark SQL in CalcitePPLScalarSubqueryTest.testCorrelatedScalarSubqueryInWhere Open

PPL

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

opensearch-project/sql#5470 · 2 comments · Opened May 26, 2026
CVE-2026-7246 (High) detected in click-7.1.2-py2.py3-none-any.whl Open

Mend: dependency security vulnerability

Difficulty 1/5 1-3 hours Newbie friendliness 84/100

opensearch-project/sql#5445 · 3 comments · Opened May 15, 2026
[RFC][FEATURE] PPL/SQL Query Linter & Static Analyzer Open

enhancement feature RFC

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

opensearch-project/sql#5405 · 1 comment · Opened May 5, 2026
[AUTOCUT] Integration Test Failed for sql-3.7.0 Open

autocut v3.7.0

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

opensearch-project/sql#5391 · 14 comments · Opened Apr 28, 2026
[FEATURE] Let `sql-worker` thread pool be resizeable instead of fixed Open

enhancement performance PPL SQL

opensearch-project/sql#5357 · 3 comments · 1 assignee · Opened Apr 15, 2026
[FEATURE] Unified SQL language across OpenSearch, Flint and Spark SQL Open

enhancement SQL

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

opensearch-project/sql#5346 · 3 comments · Opened Apr 14, 2026

opensearch-project/sql

Get new issues in your inbox