Octosql Versions Save

OctoSQL is a query tool that allows you to join, analyse and transform data from multiple databases and file formats using SQL.

v0.9.0

1 year ago

Changelog

  • (feature) Allow querying from stdin (using stdin.<format> file name).
  • (feature) Add support for the tsv format.
  • (feature) Add file tailing support to the json and lines datasources, using the option file.json?tail=true.
  • (feature) Don't print field name qualifiers in user-visible output.

v0.8.1

1 year ago

Changelog

  • (Feature) Print records live even if no watermarks are sent, as long as all records have zero event times.
  • (Feature) Add object explosion operator.
  • (Feature) Add shorthand flag for output format.
  • (Feature) Rename ln to log. Add more snapshot test for functions.
  • (Performance) Fix short-circuiting of outer LIMIT.
  • (Performance) If no retractions are possible and we have an ORDER BY ... LIMIT ... clause, only store the top N records.
  • (Performance) Use the generic implementation of google/btree for group by's.
  • (Bug) Fix panic in docs datasource, when selecting no fields (i.e. COUNT(1) or COUNT(*)).

v0.8.0

1 year ago

Changelog

  • Add LEFT, RIGHT and OUTER joins.
  • Rewrite ORDER BY and LIMIT handling, fixing multiple bugs and improving how they work in nested queries.

v0.7.4

1 year ago

Changelog

  • Add dual table.
  • Add position function.

v0.7.3

1 year ago

Changelog

  • Flush logs on exit.

v0.7.2

1 year ago

Changelog

  • Fix batch order by with live_table output format resulting in panic.
  • Fix bug in stream join on event timed streams dropping record buffer too early.
  • Fix bug related to removing unused fields from filter nodes.
  • Use btree PathHints for slightly improved performance.
  • Improve performance of distinct by using a generic btree implementation.

v0.7.1

1 year ago

Changelog

  • Add purego build tag to fix Parquet datasource crash on amd64 systems without AVX2.

v0.7.0

1 year ago

Changelog

  • Add initial Parquet file support.
  • Fix file extension table naming regression.
  • Switch to generic btree for Stream Join.
  • Add stream join optimization eliminating buffering of the bigger one of the two input tables.
  • Introduce a faster and simpler GroupBy node for common and simple use cases. (Used automatically when possible.)
  • Add time_to_unix function.
  • Use faster library for JSON output.
  • Add built-in profiling available behind the profile flag.

v0.6.2

2 years ago

Changelog

  • Switch to fastjson for JSON processing, resulting in a huge performance improvement when querying JSON files.
  • Add lines datasource for analyzing arbitrary text files.
  • Fix custom file extension handling for plugins.

v0.6.0

2 years ago

Changelog

  • Add short-circuiting LIMIT and eagerly printed JSON and CSV formats.
  • Add support for plugins handling file extensions.
  • Add support for table options.
  • Treat empty fields as NULL in CSV datasource.