spyql

spyql copied to clipboard

JSON benchmark

17

Leave your comments for the [JSON benchmark](https://colab.research.google.com/github/dcmoura/spyql/blob/master/notebooks/json_benchmark.ipynb) here.

dcmoura

Multiple EXPLODEs

1

Allow multiple explosions in a single EXPLODE statement. Some possible syntaxes: - `EXPLODE json->i_am_an_array[]->i_am_an_object->i_am_another_array[]` - `EXPLODE json->i_am_an_array, json->i_am_an_array->i_am_an_object->i_am_another_array` The 2nd is easier to parse and allows for explosions in different...

dcmoura

LIKE clause

3

Adds a LIKE function to the WHERE clause for easier matching. Closes #17 ### Some notes - Right now it can match not only with strings but also with everything...

ricardocchaves

feat: add * operator EXCEPT modifier

1

Adds the * operator EXCEPT modifier where one can specify the names of one or more columns to exclude from the result. All matching column names are omitted from the...

recharte

Currently explode has the following behaviour: ``` SELECT row.name, row.departments FROM [ {"name": "Alice", "departments": [1,4]}, {"name": "Bob", "departments": [2]}, {"name": "Charles", "departments": []} ] EXPLODE row.departments TO json ```...

dcmoura

Modifiers: - [ ] SELECT * EXCEPT - [ ] SELECT * REPLACE ### SELECT * EXCEPT A SELECT * EXCEPT statement specifies the names of one or more columns...

dcmoura

for handy search on strings

dcmoura

Look at https://fugue-tutorials.readthedocs.io/tutorials/fugue_sql/python.html

dcmoura

Key value json output and key value loader to emulate left joins

1

Allowing to load dictionaries (e.g. key/value from json files), and in the query do dictionaries look-ups. This would cover a kind of LEFT JOIN with an equality condition. e.g. ```...

dcmoura

Utility or keyword that automatically summaries a dataset, e.g. by calculating # of non-null values, # distinct values, average, min, max ...

dcmoura