ClickHouse release 1.1.54310

By Altinity Team on November 2nd, 2017

ClickHouse release 1.1.54310

Altinity Team ClickHouseReleasesRPM


The new deb packages are available from Yandex repo and RPMs from Altinity repo.

New features:

  • Custom partitioning key for the MergeTree family of table engines.
  • Kafka table engine.
  • Added support for loading CatBoost models and applying them to data stored in ClickHouse.
  • Added support for time zones with non-integer offsets from UTC.
  • Added support for arithmetic operations with time intervals.
  • The range of values for the Date and DateTime types is expanded to year 2105.
  • Added the CREATE MATERIALIZED VIEW x TO y query (allows specifying an existing table for storing data of a materialized view).
  • Added the ATTACH TABLE query without arguments.
  • The processing logic for Nested columns with names ending with -Map in a SummingMergeTree table was extracted to the sumMap aggregate function. You can now specify such columns explicitly.
  • Max size of the IP trie dictionary is increased to 128M entries.
  • Added the getSizeOfEnumType function.
  • Added the sumWithOverflow aggregate function.
  • Added support for the Cap’n Proto input format.
  • You can now customize compression level when using the zstd algorithm.

Backwards incompatible changes:

  • Creation of temporary tables with an engine other than Memory is forbidden.
  • Explicit creation of tables with the View or MaterializedView engine is forbidden.
  • It is now checked during the creation of a table that the sampling key expression is included in the primary key.

Bug fixes:

  • Fixed hangups when synchronously inserting into a Distributed table.
  • Fixed nonatomic adding and removing of parts in Replicated tables.
  • Data inserted into a materialized view is not subjected to unnecessary deduplication.
  • Executing a query to a Distributed table for which the local replica is lagging and remote replicas are unavailable does not result in an error anymore.
  • Users don’t need access permissions to the default database to create temporary tables anymore.
  • Fixed crashing when specifying the Array type without arguments.
  • Fixed hangups when the disk volume containing server logs is full.
  • Fixed an overflow in the toRelativeWeekNum function for the first week of the Unix epoch.

Build improvements:

  • Several third-party libraries (notably Poco) were updated and converted to git submodules.

Leave a Reply

Your email address will not be published. Required fields are marked *