Skip to content

Latest commit

 

History

History
318 lines (177 loc) · 13 KB

CHANGELOG.md

File metadata and controls

318 lines (177 loc) · 13 KB
Raw

1.50.7

Improvements

  • Added a configuration field (under the "advanced options", hidden by default) to override certain ClickHouse settings (#272).

1.50.6

Bug fixes

1.50.5

Bug fixes

  • Fixed an error that could occur while setting roles containing hyphens for connection impersonation (#266, sharankow).

1.50.4

Bug fixes

  • Fixed an error while uploading a CSV with an offset datetime column (#263, crisptrutski).

1.50.3

Improvements

  • The driver no longer explicitly sets allow_experimental_analyzer=0 settings on the connection level; the new ClickHouse analyzer is now enabled by default.

1.50.2

Bug fixes

  • Fixed Array inner type introspection, which could cause reduced performance when querying tables containing arrays. (#257)

1.50.1

New features

  • Enabled :set-timezone (docs) Metabase feature in the driver. (#200)
  • Enabled :convert-timezone (docs) Metabase feature in the driver. (#254)

Other

1.50.0

After Metabase 0.50.0, a new naming convention exists for the driver's releases. The new one is intended to reflect the Metabase version the driver is supposed to run on. For example, the driver version 1.50.0 means that it should be used with Metabase v0.50.x or Metabase EE 1.50.x only, and it is not guaranteed that this particular version of the driver can work with the previous or the following versions of Metabase.

New features

  • Added Metabase 0.50.x support.

Improvements

  • Bumped the JDBC driver to 0.6.1.

Bug fixes

  • Fixed the issue where the connection impersonation feature support could be incorrectly reported as disabled.

Other

  • The new ClickHouse analyzer, which is enabled by default in 24.3+, is disabled for the queries executed by the driver, as it shows some compatibilities with the queries generated by Metabase (see this issue for more details).
  • The :window-functions/offset Metabase feature is currently disabled, as the default implementation generates queries incompatible with ClickHouse. See this issue for tracking.

1.5.1

Metabase 0.49.14+ only.

Bug fixes

  • Fixed the issue where the Metabase instance could end up broken if the ClickHouse instance was stopped during the upgrade to 1.5.0. (#242)
  • Fixed variables substitution with Nullable Date, Date32, DateTime, and DateTime64 columns, where the generated query could fail with NULL values in the database due to an incorrect cast call. (#243)

1.5.0

Metabase 0.49.14+ only.

New features

Improvements

  • Proper role setting support on cluster deployments (related issue: #192).
  • Bump the JDBC driver to 0.6.0-patch5.

Bug fixes

  • Fixed missing data for the last day when using filters with DateTime columns. (#202, #229)

1.4.0

New features

  • Metabase 0.49.x support.

Bug fixes

  • Fixed an incorrect substitution for the current day filter with DateTime columns. (#216)

1.3.4

New features

  • If introspected ClickHouse version is lower than 23.8, the driver will not use startsWithUTF8 and fall back to its non-UTF8 counterpart instead. There is a drawback in this compatibility mode: potentially incorrect filtering results when working with non-latin strings. If your use case includes filtering by columns with such strings and you experience these issues, consider upgrading your ClickHouse server to 23.8+. (#224)

1.3.3

Bug fixes

  • Fixed an issue where it was not possible to create a connection with multiple databases using TLS. (#215)

1.3.2

Bug fixes

  • Remove can-connect? method override which could cause issues with editing or creating new connections. (#212)

1.3.1

Bug fixes

  • Fixed incorrect serialization of Array(UInt8) columns (#209)

1.3.0

New features

  • Metabase 0.48.x support

Bug fixes

  • Fixed last/next minutes/hours filters with variables creating incorrect queries due to unnecessary CAST col AS date call.

1.2.5

Metabase 0.47.7+ only.

New features

1.2.4

Metabase 0.47.7+ only.

Bug fixes

  • Fixed UI question -> SQL conversion creating incorrect queries due to superfluous spaces in columns/tables/database names.

1.2.3

Bug fixes

  • Fixed LowCardinality(Nullable) types introspection, where it was incorrectly reported as type/* (#203)

1.2.2

Bug fixes

  • Removed forward slash from serialized IPv4/IPv6 columns. NB: IPv4/IPv6 columns are temporarily resolved as type/TextLike instead of type/IPAddress base type due to an unexpected result in Metabase 0.47 type check.
  • Removed superfluous CAST calls from generated queries that use Date* columns and/or intervals

1.2.1

New features

  • Use HoneySQL2 in the driver

1.2.0

New features

  • Metabase 0.47 support
  • Connection impersonation support (0.47 feature)

Bug fixes

  • More correct general database type -> base type mapping
  • DateTime64 is now correctly mapped to :type/DateTime
  • database-required field property is now correctly set to true if a field is not Nullable

1.1.7

New features

  • JDBC driver upgrade (v0.4.1 -> v0.4.6)
  • Support DateTime64 by @lucas-tubi (#165)
  • Use native startsWith/endsWith instead of LIKE str%/LIKE %str

1.1.6

Bug fixes

  • Fixed temporal bucketing issues (see #155)

1.1.5

Bug fixes

  • Fixed Nippy error on cached questions (see #147)

1.1.4

Bug fixes

  • Fixed sum-where behavior where previously it could not be applied to Int columns (see #156)

1.1.3

New features

  • Hide .inner tables of Materialized Views.
  • Resolve Map base type to type/Dictionary.
  • Database name can now contain multiple schemas in the UI field (space-separated by default), which tells the driver to scan selected databases. Separator can be set in metabase.driver.clickhouse/SEPARATOR. (@veschin)

1.1.2

Bug fixes

  • Now the driver is able to scan and work with SimpleAggregateFunction columns: those were excluded by mistake in 1.0.2.

1.1.1

New features

  • Metabase 0.46.x compatibility.
  • Added cljc.java-time to dependencies, as it is no longer loaded by Metabase.

1.1.0

New features

  • Update JDBC driver to v0.4.1.
  • Use new product_name additional option instead of client_name
  • Replace sql-jdbc.execute/read-column [:clickhouse Types/ARRAY] with sql-jdbc.execute/read-column-thunk [:clickhouse Types/ARRAY] to be compatible with Metabase 0.46 breaking changes once it is released.

Bug fixes

  • Fix sql-jdbc.execute/read-column-thunk [:clickhouse Types/TIME] return type.

1.0.4

New features

  • Adds a new "Scan all databases" UI toggle (disabled by default), which tells the driver to scan all available databases (excluding system and information_schema) instead of only the database it is connected to.
  • Database input moved below host/port/username/password in the UI.

1.0.3

Bug fixes

  • Fixed NPE that could be thrown by the driver in case of empty database name input.

1.0.2

Bug fixes

  • As the underlying JDBC driver version does not support columns with (Simple)AggregationFunction type, these columns are now excluded from the table metadata and data browser result sets to prevent sync or data browsing errors.

1.0.1

Bug fixes

  • Boolean base type inference fix by @s-huk (see #134)

1.0.0

Formal stable release milestone.

New features

  • Added HTTP User-Agent (via clickhouse-jdbc client_name setting) with the plugin info according to the language client spec

0.9.2

New features

  • Allow to bypass system-wide proxy settings #120

It's the first plugin release from the ClickHouse organization.

From now on, the plugin is distributed under the Apache 2.0 License.

0.9.1

New features

  • Metabase 0.45.x compatibility #107
  • Added SSH tunnel option #116

0.9.0

New features

Bug fixes

  • URLs with underscores #23
  • now() timezones issues #81
  • Boolean errors #88

NB: there are messages like this in the Metabase logs

2022-12-07 11:20:58,056 WARN internal.ClickHouseConnectionImpl :: [JDBC Compliant Mode] Transaction is not supported. You may change jdbcCompliant to false to throw SQLException instead.
2022-12-07 11:20:58,056 WARN internal.ClickHouseConnectionImpl :: [JDBC Compliant Mode] Transaction [ce0e121a-419a-4414-ac39-30f79eff7afd] (0 queries & 0 savepoints) is committed.

Unfortunately, this is the behaviour of the underlying JDBC driver now.

Please consider raising the log level for com.clickhouse.jdbc.internal.ClickHouseConnectionImpl to ERROR.

0.8.3

New features

  • Enable additional options for ClickHouse connection

0.8.2

New features

  • Compatibility with Metabase 0.44