opteryx
opteryx copied to clipboard
🦖 A SQL-on-everything Query Engine you can execute over multiple databases and file formats. Query your data, where it lives.
("SELECT CONCAT(name, ' is a planet') FROM $planets", 9, 1, None), ("SELECT CONCAT('Astronaut: ', name) FROM $astronauts WHERE LENGTH(name) > 20", 10, 1, None), ("SELECT CONCAT('Hello', ' ', 'World') as...
("SELECT DATE_ADD('2022-01-01', INTERVAL 1 DAY)", 1, 1, None), ("SELECT DATE_SUB('2022-01-01', INTERVAL 1 DAY)", 1, 1, None), ("SELECT DATE_DIFF('2022-01-01', '2021-12-31', DAY)", 1, 1, None),
Updates the requirements on [pyo3](https://github.com/pyo3/pyo3) to permit the latest version. Release notes Sourced from pyo3's releases. PyO3 0.20.3 This is a stability & compatibility release to fix a couple of...
Use Tarchia to get schema, location and format if set locally (existing config approach), use this instead.
Using Tarchia as the catalog, support the INFORMATION_SCHEMA, probably following the MySQL variation as core SQL syntax aligns closer to MySQL than any other variation https://dev.mysql.com/doc/refman/8.0/en/information-schema.html
### 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...
record in Parquet, etc, as BLOB, but parse to dictionary-like field field implement optimizations for the existing `->`, `->>` and `@?` operators implement functions: - [ ] SELECT EXTRACT_PATH(bson_field, 'address.city')...
A remote shuffle service can indeed be implemented using REST APIs, but it generally involves a combination of architectural components to handle the complexity and requirements of distributed data processing....
we should track the selectively and performance of conditions and dynamically reorder at a threshold. E.g. we do x=1 and y like '4', we probably assume the eq should be...
we should partition into 48 partitions, we can feed this to 1,2,3,4,6,8,12,16,24 or 48 workers