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.
### Thank you for taking the time to report a problem with Opteryx. _To help us to respond to your request we ask that you try to provide the below...
TPCH query 08 ~~~sql select nation, o_year, sum(amount) as sum_profit from ( select n_name as nation, year(o_orderdate) as o_year, l_extendedprice * (1 - l_discount) - ps_supplycost * l_quantity as amount...
**Idempotent Operations** Operations with the same operand on each side can be simplified. `A and A => A` `A or A => A` **Absorption and Reduction** `A or (A and...
~~~sql SELECT * FROM table1 -- This is the "left" table LEFT JOIN table2 -- This is the "right" table ON table1.id = table2.id; ~~~
https://docs.snowflake.com/en/sql-reference/functions/row_number
Morsels are currently the size of the read block, for the exemplar user this is usually blocks of up to 64Mb. Tables that exceed 64Mb are split into multiple morsels...
Allow subqueries to reference values from the outer query.
The pages being processed don't need to be combined until they reach a greedy operation, rather than use the mulri processing in the operation, the execution engine should handle this...
To improve read speed, the reads should be asynchronous, either using ascyncio, threading or multiprocessing. Consider using Plasma to store the data between threads/processes. **discovered** - [ ] Caching needs...