opteryx
opteryx copied to clipboard
mabel-dev
🦖 A SQL-on-everything Query Engine you can execute over multiple databases and file formats. Query your data, where it lives.
~~~sql SELECT Company, Rocket, COUNT(*) AS NumMissions, CASE WHEN COUNT(*) > 10 THEN 'Frequent' ELSE 'Rare' END FROM $missions GROUP BY ALL; -- CASE statement with GROUP BY ALL ~~~...
Was looking at query plans, looks like correlated filtering isn't sending filters Why isn't there a test for this?
As a contrived example, we should be able to UNNEST on the result of a function: ~~~sql SELECT mission FROM $astronauts CROSS JOIN UNNEST(CAST(missions AS ARRAY)) AS mission ~~~
### Thank you for helping maintain the quality and performance of Opteryx. _We appreciate your efforts — your contribution ensures that Opteryx remains reliable and efficient for everyone._ --- **Is...
Regex Pattern | Optimized Form ----------- | ----------- `^abc$` | col = 'abc' `^abc` | col LIKE 'abc%' `abc$` | col LIKE '%abc' `.*abc.*` | col LIKE '%abc%' `abc` (no...
Write KV backend backed by file/blob storage, the intention being to use this as part of spill/shuffle
We rewrote the bloom filter builder and saved about 75% of the execution time. Although the bugs in the implementation need to be resolved.
# REDUNDANCY RULE We can rewrite an outer join to an inner join if the query contains a filter that would already reject fany null values (which is most filters)...
We should rewrite the LEFT OUTER JOIN to support morsel-by-morsel processing This will look like, performing an INNER JOIN, tracking joined left relation rows, then at EOS, emitting the yet...