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.
Using generate series as a function should create a list data type
The `LIST` aggregation type allows the values in each group to be collected and complex aggregations (i.e. ones that require more than one function call, or the output to be...
Table information Size File type https://dev.mysql.com/doc/refman/8.0/en/show-tables.html
We spend time and memory building lists to compare against, and then discard all except the first entry. Example: ~~~python elif operator == "NotLike": # MODIFIED FOR OPTERYX - see...
Although PIVOT looks like a nightmare to use, so may not implement as it's unlikely the skill to use it is prevalent in the existing user community. https://docs.microsoft.com/en-us/sql/t-sql/queries/from-using-pivot-and-unpivot?view=sql-server-ver16
introduce a class to help manage schema management and visibility to reduce the ad hoc code in the binder.
we have - cross_join => join_cross - hash_join => join_outer_hash - inner_join => join_inner_hash (integrate the type-specific variation in here) add - join_inner_sorted (prefer for non equi joins)
### 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...