Issues

• Import and Export substrait plans

  Improvement

  mabel-dev/opteryx#2925 · Filter by author joocer opened on Nov 15, 2025

• aggregates without groups cannot reference aggregates in SELECT clause

  Bug

  mabel-dev/opteryx#2782 · Filter by author joocer opened on Sep 10, 2025

• Rewrite expression engine core in cython

  Improvement

  mabel-dev/opteryx#2734 · Filter by author joocer opened on Aug 5, 2025

• [OPTIMIZER] Rewrite chains of ARRAY_CONTAINS to list ops (@>)

  Good First Issue
  Improvement

  mabel-dev/opteryx#2717 · Filter by author joocer opened on Aug 2, 2025

• [LIB] Would roaring bitmaps be faster that abseil sets for DISTINCT and FILTER joins?

  Improvement

  mabel-dev/opteryx#2715 · Filter by author joocer opened on Aug 1, 2025

• Resolve aggregations from statistics

  Improvement

  mabel-dev/opteryx#2705 · Filter by author joocer opened on Jul 27, 2025

• can't reference views in CTEs?

  Bug

  mabel-dev/opteryx#2696 · Filter by author joocer opened on Jul 25, 2025

• Cannot aggregate on complex expressions

  Bug

  mabel-dev/opteryx#2684 · Filter by author joocer opened on Jul 16, 2025
  1

• SIMD the null bitmask checks used by INNER JOIN

  Improvement

  mabel-dev/opteryx#2645 · Filter by author joocer opened on Jun 28, 2025

• [Optimizer] Function to pushable ops

  Improvement

  mabel-dev/opteryx#2639 · Filter by author joocer opened on Jun 26, 2025

• Mermaid chart should report the rows, columns and time of the resultset

  Good First Issue
  Improvement

  mabel-dev/opteryx#2638 · Filter by author joocer opened on Jun 26, 2025

• Restore INNER CROSS JOIN

  Bug

  mabel-dev/opteryx#2584 · Filter by author joocer opened on May 13, 2025

• DECIMAL remembers scale and precision

  Bug

  mabel-dev/opteryx#2571 · Filter by author joocer opened on May 7, 2025

• chained UNIONs erroring

  Bug

  mabel-dev/opteryx#2522 · Filter by author joocer opened on Mar 21, 2025

• ORDER BY and LIMIT 1 -> MAX/MIN

  Good First Issue⚙️ Query Optimizer
  Improvement

  mabel-dev/opteryx#2515 · Filter by author joocer opened on Mar 19, 2025

• Extract Types from arrow (iceberg?) STRUCT types

  Improvement

  mabel-dev/opteryx#2511 · Filter by author joocer opened on Mar 18, 2025

• Throw more meaningful error when trying to ARRAY_AGG an ARRAY column

  Improvement

  mabel-dev/opteryx#2499 · Filter by author joocer opened on Mar 9, 2025

• ✨ CROSS JOIN UNNEST on functions

  Improvement

  mabel-dev/opteryx#2492 · Filter by author joocer opened on Mar 8, 2025

• ✨ Rewrite RLIKE operations to LIKE and INSTR where possible

  Good First Issue
  Improvement

  mabel-dev/opteryx#2486 · Filter by author joocer opened on Mar 5, 2025

• 🪲 CASE in SELECT error

  Bug

  mabel-dev/opteryx#2473 · Filter by author joocer opened on Feb 28, 2025

• ✨ STAR Queries

  ⚙️ Query Optimizer
  Improvement

  mabel-dev/opteryx#2448 · Filter by author joocer opened on Feb 21, 2025

• [Optimizer] Rewrite LEFT JOIN to INNER JOIN When Filter Removes NULL-Extended Rows

  ⚙️ Query Optimizer
  mabel-dev/opteryx#2447 · Filter by author joocer opened on Feb 21, 2025

• ✨ when resizing the SQL reader, we should be aware of the LIMITs

  mabel-dev/opteryx#2442 · Filter by author joocer opened on Feb 21, 2025

• ✨ push offset to readers

  mabel-dev/opteryx#2441 · Filter by author joocer opened on Feb 21, 2025

• ✨ ARRAY_CONTAINS should be rewritten to ANY and marked as deprecated

  mabel-dev/opteryx#2440 · Filter by author joocer opened on Feb 21, 2025