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.
- time preparing - time executing ( work around yields) - records in - records out An executed plan should be available as a tree with execution statistics. Each planning...
Use `ANALYZE TABLE` to write table statistics to storage - this could then be used for `SHOW COLUMNS` and if storage is fast enough, used for query planning. This should...
HIVE example: ~~~sql CREATE TABLE IF NOT EXISTS hive.iris.iris_parquet ( sepal_length DOUBLE, sepal_width DOUBLE, petal_length DOUBLE, petal_width DOUBLE, class VARCHAR ) WITH ( external_location = 's3a://iris/iris_parquet', format = 'PARQUET' );...
When a column has all the same values, rather than pass around the repeated value, use the header (available via the Columns class) to record the column and it's value....
~~~sql GRANT privilageName ON objectName TO {userName | public | roleName } ~~~ In a KV store this would naturally be an adjancy "table", where each resource is a key,...
**Describe the bug** A clear and concise description of what the bug is. **SQL statement** Please submit the SQL statement, or a representative example using the sample datasets. ~~~sql ~~~...
At load time some things are known that weren't known at install time. We can use AST rewriting to rewrite some functions to improve performance. Inspired by https://github.com/brmmm3/fastlogging/blob/master/doc/Optimize.rst
https://github.com/sqlparser-rs/sqlparser-rs/commit/cb397d19f99718b1e76e5cd5eebde93d5dc3a83e
vs CTE which creates a plan which is inserted when called.
**Describe the bug** A clear and concise description of what the bug is. The value in the variable should be returned. **SQL statement** Please submit the SQL statement, or a...