Skip to content

Latest commit

 

History

History
349 lines (228 loc) · 14.8 KB

CHANGELOG.md

File metadata and controls

349 lines (228 loc) · 14.8 KB
Raw

2.4.0 (2021-11-29)

Enhancement:

Fixes:

2.3.1 (2021-04-23)

Breaking changes

  • On latest Grafana 7.x releases, template variables SQL queries shall return only scalar types of values, see Altinity#328

Enhancement:

  • add support Apple M1 ;)
  • switch to new grafana plugin Golang SDK, thanks to @bmanth60 and @valeriakononenko for help
  • add BasicAuth support for alerts, see Altinity#267

Fixes:

2.2.3 (2021-02-17)

Enhancement:

  • automate plugin sign process via github actions, fix wrong executable file permissions

2.2.0 (2020-11-30)

Enhancement:

  • add region support to annotation query, try to fix wrong column orders for table format, fix Altinity#303
  • add plugin sign process, fix Altinity#212
  • add DateTime64 support, fix Altinity#292
  • add linux\arm64 backend plugin build
  • improve ARRAY JOIN parsing, fix Altinity#284
  • improve docker-compose.yaml add ability to redefine GRAFANA_VERSION and CLICKHOUSE_VERSION via environment variables latest by default

Fixes:

  • add *.js.map and *.js from src and spec folder to .gitignore
  • don't apply adhoc filters twice when used $adhoc macros, fix Altinity#282
  • fix corner case for table format with wrong columns order between meta and data response section, fix Altinity#281
  • add trickster to docker-compose environment
  • actualize links in README.md

2.1.0 (2020-08-13)

Enhancement:

  • add "Skip comments" checkbox to query editor to pass SQL comments to server, fix Altinity#265
  • add setup notes for Grafana 7.x to README
  • add SQL preprocessing logic on browser side with <% js code subset %>, Altinity#186, thanks @fgbogdan
  • improve alerts query processing for use case when query(query_name, from, to) time range is less than visible dashboard time range, see Altinity#237
  • improve alerts json parsing in golang part for case when we have string fields in response which interprets as series name, see Altinity#230
  • properly parsing POST queries in golang part of plugin, Altinity#228, thanks @it1804

Fixes:

2.0.2 (2020-07-06)

Enhancements:

  • add alerts support for Windows and MacOSX
  • improve ad-hoc filters for query field values as SELECT DISTINCT field AS value FROM db.table LIMIT 300, Altinity#222
  • add ability to multiple JOIN parsing Altinity#206
  • multiple improvements for docker-compose environments, add automatic dashboards and datasource provisions which help to reproduce most of the corner cases which happens in Grafana + ClickHouse

Fixes:

  • apply a workaround for UTC timezone for Date and DateTime columns in grafana dashboards Altinity#117
  • clear documentation about timestamp term for $from and $to Altinity#115
  • fix AST parsing corner case in WHERE [test, 'test'] "," was skipped, fix ah-doc ast FROM recursive parsing Altinity#99
  • fix corner cases for table functions parsing when adhoc filter applied Altinity#130
  • fix multiple grammar issues in README.md
  • fix convert rules for Float, Decimal columns from Clickhouse to Grafana Table plugin Altinity#199
  • fix corner cases when Grafana Template variable value represented as array of strings Altinity#169
  • fix AST parsing corner cases for $macroFunctions correct position for FROM statement Altinity#187

2.0.1 (2020-06-19)

Fixes:

  • fix golang alerts for $columns, $perSecond, $perSecondColumns macros Altinity#200

2.0.0 (2020-06-17)

Enhancements:

  • compatibility with grafana 7.x, please use environment variable GF_PLUGINS_ALLOW_LOADING_UNSIGNED_PLUGINS=vertamedia-clickhouse-datasource or allow_loading_unsigned_plugins=vertamedia-clickhouse-datasource in plugins section of grafana.ini Altinity#192
  • add grafana 7.x alerting support thanks to Brian Thai https://github.com/bmanth60
  • add alias support to $perSecondColumns macro Altinity#193
  • Support custom variable type and empty values for $conditionalTest macro Altinity#178
  • add docker-compose.yaml to improve local development

Fixes:

1.9.5 (2020-01-15)

Fixes:

  • Comments not supported by sql language parser #95

1.9.4 (2019-11-27)

Fixes:

  • Ad Hoc Filters small adjustments for numeric values
  • UI optimizations within Metric builder

1.9.3 (2019-10-18)

Fixes:

  • Ad Hoc Filters improvements for complex usage

1.9.2 (2019-10-10)

Fixes:

  • Compatibility fix to support grafana 6.4.x
  • Ad Hoc Filters fix
  • $conditionalTest ALL value option fix

1.9.0 (2019-08-12)

New features:

  • Add macro conditionalTest (thx to @TH-HA) #122
  • Add support for connect to Yandex.Cloud ClickHouse (thx to @negasus) #106

Fixes:

  • Fix identifier back quoting when there is a function call
  • Fix AST parser errors for quotes (thx to @Fiery-Fenix) #128
  • Added default database to all requests from datasource options (thx to @Fiery-Fenix) #126
  • Drop lodash fcn composition (thx to @simPod) #110
  • Cleanup build (thx to @simPod) #112

1.8.1 (2019-02-01)

New features:

  • Add timeFilterByColumn macro (thx to @simPod) #68

Fixes:

  • add requestId to queries so that abandoned one are cancelled (thx to @nvartolomei)
  • bug with parentheses in $unescape macros #90
  • bug with treating string as numbers in table view #97

1.8.0 (2018-11-07)

New features

  • new $perSecond and $perSecondColumns macros (thx to @simPod) #78 #80
  • Date column is now optional #48

Fixes:

  • extend queried timerange for queries with round option to provide a graph without gaps in the rightmost and leftmost points #84
  • adhocs: check whether it is possibly to apply filters by comparing with parsed query or query builder settings #86

1.7.0 (2018-09-05)

New Features

  • provide $adhoc macros for using ad-hoc filters in inner queries (thx to @vavrusa)
  • allow to set custom query for ad-hoc filter via adhoc_query_filter variable
  • provide new Round value $step for auto-rounding according to graph resolution changes

1.6.0 (2018-08-07)

New Features

  • annotations support (txh to @atsirin)
  • allow to use $from and $to macroses in variable queries
  • provisioning config example in README

1.5.1 (2018-06-05)

Fixes

  • optimize memory use for range time series (thx to @vavrusa)
  • apply ad-hoc filters on inner subqueries (thx to @vavrusa)

1.5.0 (2018-05-31)

New Features

  • new datasource setting - default database. If set it will be prefilled in the query builder, and used to make ad-hoc filters more convenient (thx to @vavrusa)
  • support wildcard ad-hoc filters for dashboards using multiple tables (thx to @vavrusa)
  • parse dimensions from GROUP BY to simplify querying (see piechart and worldmap examples) (thx to @vavrusa)
  • $timeCol to $dateCol renamed to be more clear with column types (thx to @simPod)

1.4.3 (2018-04-09)

Fixes

  • fix broken AST when using nested SELECT without FROM statement (#45)
  • strict statement matching (#44)
  • rebuild queries from AST only if adhoc filters were applied

1.4.2 (2018-03-18)

Fixes

  • support UNION ALL statements
  • proper format for LIMIT N,M construction (thx to @shankerwangmiao)
  • update Show Help section with $unescape description

1.4.1 (2018-03-12)

New Features

  • $unescape - unescapes variable value by removing single quotes. Used for multiple-value string variables: "SELECT $unescape($column) FROM requests WHERE $unescape($column) = 5"

Fixes

  • labmda-operator -> no more breaks while reformatting query

1.4.0 (2018-03-08)

New Features

Ad-hoc filters support:

  • If there is an Ad-hoc variable, plugin will fetch all columns of all tables of all databases (except system database) as tags. So in dropdown menu will be options like database.table.column
  • If there are ENUM columns, plugin will fetch their options and use them as tag values
  • Plugin will apply Ad-hoc filters to all queries on the dashboard if their settings $database and $table are the same as Ad-hoc's database.table
  • There are no option to apply OR operator for multiple Ad-hoc filters - see grafana/grafana#10918
  • There are no option to use IN operator for Ad-hoc filters due to Grafana limitations

1.3.1 (2018-02-12)

Fixes

  • support array indexing int AST

1.3.0 (2018-02-07)

New Features

  • columns autocompletion in ace-editor

1.2.7 (2018-01-05)

Fixes

  • properly format query with reserved names
  • fix #31

1.2.6 (2017-12-13)

Fixes

  • allow rounding with round option both time filters: $from and $to

1.2.5 (2017-12-05)

Fixes

  • support template variables with different text and value values #27
  • fix visual glitches #29

1.2.4 (2017-11-22)

Fixes

  • apply proper value formatting for table format

1.2.3 (2017-11-20)

Fixes

  • commit generated files

1.2.2 (2017-11-20)

Fixes

  • fix error with absent getCollapsedText #24
  • suppress errors while parsing AST #24
  • show generated SQL in textarea #24
  • do not round timestamp after converting #25
  • increase max-height of query editor

1.2.1 (2017-11-17)

Fixes

  • add forgotten completions
  • process NULL values #19
  • sort by key value in $columns macro #16

1.2.0 (2017-11-15)

New Features

1.1.0 (2017-11-13)

New Features

  • Allow UInt32 as Timestamp column #15
  • Add Format as Table format #17