Oliver Kennedy

OFFSET queries are painfullly slow / do not complete

1

``` mimir> LOAD 'https://raw.githubusercontent.com/thebuffalonews/shootings/master/data_cleanup/old_data/shootings_geo_dirty.csv' into shootings with staging; ``` The following query is super fast ``` mimir> select * from shootings limit 1; ``` **Warm (after loading)**: 323 ms **Cold...

https://nlp.johnsnowlabs.com/docs/en/annotators#datematcher

Current behavior: `INSERT`, `UPDATE`, `DELETE`, and `ALTER TABLE` are not supported. Desired behavior: These operations are supported. As per the discussion in #321, the most straightforward way to do this...

At some point, we should migrate the implementation of Vizier's spreadsheet-versioning language, Vizual into Mimir. Benefits - Operations in Vizual correspond mostly to simple DDL/DML operations, and many are already...

Current behavior: The Missing Value lens must impute values that do not satisfy the constraints. Desired behavior: Optionally allow users to simply delete values that do not satisfy constraints.

This should have gone away already.

Add documentation for MimirSQL

JSON Type

4

Spark natively supports nested data a'la JSON. There's enough going on in Mimir that uses JSON that it might make sense to add native support for Json (i.e., `TJson()`, `JsonPrimitive(scala.play.json.JsValue)`...

https://github.com/UBOdin/mimir/blob/master/src/main/scala/mimir/data/staging/RawFileProvider.scala