Skip to content

Releases: tesseract-olap/tesseract

v0.7.0

09 Jan 21:10
Compare
Choose a tag to compare

Major Change

  • Bugfix: previous versions had a bug where if two dims shared a table, a cut on one table might be grafted onto the other because dims were compared using table name. This is fixed by removing grafting drills and cuts onto one dim table join, and instead using where clauses and IN in the fact table scan only. Some code cleanup required, but functionality should be fixed.
  • Major change: inner join on dim tables has been changed to right join, to expose cases where there's a row dimension id that doesn't have an equivalent in the dim table.

v0.6.0

08 Jan 20:51
Compare
Choose a tag to compare
  • allow calculations (rca or growth) to be the measure in top.
  • use alias for foreign key, to allow clickhouse cut w/ joining on dim table.
  • improve check, for top, to include rca drilldowns.
  • allow external measures and properties on rca.

v0.5.0

03 Jan 17:51
Compare
Choose a tag to compare
  • MySql support! thanks to @jspeis
  • very basic "standard sql" support for primary aggregation. (no ordering, top, calculations, etc.)
  • rca calculation available (now partly optimized)
  • clickhouse now allows joining tables on differently named cols (uses alias to make the names the same)

v.4.0

26 Dec 19:35
Compare
Choose a tag to compare

BREAKING CHANGE

  • update database configuration to use TESSERACT_DATABASE_URL instead of CLICKHOUSE_DATABASE_URL. Use prefix clickhouse, mysql, etc. to specify db type. e.g. clickhouse://127.0.0.1:9000. if no prefix specified, then clickhouse is the default.
  • tesseract.service is updated with new env var

v0.3.0

21 Dec 16:18
Compare
Choose a tag to compare

features

  • growth calculation
  • top n by group
  • sort
  • order
  • properties
  • clickhouse-rs upgraded to 0.1.5 for connection pool

maintenance/perf

  • refactor sql to have a primary aggregation, and optional wrappers for calculation/filtering
  • where clause in fact table for cuts, to improve query times from 20-100x.
  • clickhouse uses newly pub SqlType for reflection, instead of string
  • fix bug in getting cube's table name
  • use trait object for databases

v0.2.0

07 Dec 23:10
Compare
Choose a tag to compare
  • backend trait refactor
  • update clickhouse-rs to prevent hangs
  • use indexmap for json serialization
  • use cargo_version for index response

v0.1.0

05 Dec 23:56
Compare
Choose a tag to compare
  • json schema
  • metadata query (/cubes)
  • aggregation query
    • support cuts for members which are either string or not
    • support joining on dim table for metadata
    • support drilldowns of multi-level dims
    • support cut by parent
    • support parents in drilldown
    • support inline dims
  • implement formatters
    • csv
    • jsonrecords
  • systemd .service file