v.1.1.54337
Backward Incompatible Changes
8- Format Change for Log Type Tables with Nullable Columns
- Removed experimental setting for extended storage definition syntax
- Function Name Change for Clarity
- Removed FROM ARRAY JOIN syntax without table in ARRAY JOIN usage
- Removed BlockTabSeparated Format for Demonstration Use Only
- Changed State Format for Aggregate Functions: varSamp, varPop, stddevSamp, stddevPop, covarSamp, covarPop, corr
- Undocumented AggregateFunction Feature to Be Reintroduced in Future Releases
- Enum Data Types in Min/Max Functions to be Reintroduced in Next Release
Bug Fix
36- Fixed Data Deduplication for DROP and DETACH PARTITION Queries
- Fixed Bug in WHERE Clause Interpretation for CREATE MATERIALIZED VIEW Queries
- Fixed Bug in root_path Parameter of zookeeper_servers Configuration
- Fixed Date Argument Issues in toStartOfDay Function
- Fix Month Arithmetic Functions and INTERVAL Handling
- Missing Support Added for UUID Data Type in Various Functions
- Fixed SummingMergeTree Behavior for Zero-Sum Rows
- Various Fixes for Kafka Engine
- Fixed Join Table Engine Behavior
- Fixed Allocator Behavior on FreeBSD and OS X
- extractAll Function Now Supports Empty Matches
- Fixed Error Preventing libressl Usage Instead of OpenSSL
- Fixed CREATE TABLE AS SELECT Query from Temporary Tables
- Fixed Replication Queue Non-Atomicity Issue
- Fixed Overflow Issues in gcd, lcm, and Modulo Functions
- -preprocessed Files Created After umask Change
- Fixed Bug in MergeTreePartChecker Background Check with Custom Partition Key
- Fixed Tuple Parsing in Text Formats
- Improved Error Messages for Incompatible Types in Functions
- Redesign and Bug Fixes for Nullable Types Support
- Fixed Internal Data Type Bugs in SummingMergeTree and Pretty Formats
- Stricter Checks for Composite Column Combinations
- Fixed Overflow Issue for Large FixedString Parameters
- Fixed Bug in topK Aggregate Function
- Added Size Equality Check for n-ary Aggregate Functions
- Fixed bug in --pager for clickhouse-client
- Fixed Precision in exp10 Function
- Fixed visitParamExtract Function for Documentation Compliance
- Fixed Crash for Incorrect Data Types
- Fixed DISTINCT Behavior with Constant Columns
- Fixed Query Formatting for Tuple Indexing with Complex Constants
- Fixed bug in Dictionary tables for range_hashed dictionaries
- Fixed Excessive Rows in FULL and RIGHT JOIN Results
- Fixed Server Crash During Config Reload in config.d Directories
- Fixed DNS Cache Query for Cluster Node Address Update
- Fixed MATERIALIZED VIEW Behavior After DETACH TABLE Execution
Build/Testing/Packaging Improvement
11- Pbuilder Tool Overview
- Single Build Compatible with Multiple Linux OS Versions
- Added clickhouse-test Package for Functional Testing
- Source Tarball Now Available for Repository Publishing
- Limited Travis CI Integration with Debug Build Testing
- Added Cap'n'Proto Support in Default Build
- Changed Documentation Format from Restricted Text to Markdown
- Added support for systemd, disabled by default due to OS compatibility issues
- Dynamic Code Generation with Embedded Clang and LLD in ClickHouse
- Removed GNU Extensions and Changed Default C++ Library in Build Process
- Extracted clickhouse_parsers and clickhouse_common_io Libraries for Faster Tool Builds
New Feature
28- Support for Multi-Dimensional Arrays and Tuples in Tables
- Support for Table Functions in DESCRIBE and INSERT Queries
- Improved Time Zone Support for DateTime Data Type
- New Date Functions and Case Sensitivity Update
- Added toStartOfFifteenMinutes Function
- Added clickhouse format tool for query formatting
- Added format_schema_path Configuration for Cap'n Proto Schema Files
- Added Support for Configuration Substitutions in External Dictionaries and Models
- Added Documentation Column to system.settings Table
- Added system.parts_columns Table for MergeTree Column Size Information
- Added system.models Table for CatBoost Model Information
- Added MySQL and ODBC Table Functions for Remote Database Access (Beta)
- Enhancement: Support AggregateFunction Argument in groupArray
- Removed Restrictions on Aggregate Function Combinators
- Extension of -ForEach Combinator for Multi-Argument Aggregate Functions
- Added Support for Aggregate Functions with Nullable Arguments
- Added max_client_network_bandwidth for clickhouse-client
- Users with readonly = 2 Can Work with TEMPORARY Tables
- Support for Multiple Consumers in Kafka Engine
- Added intExp3 and intExp4 Functions
- Added sumKahan Aggregate Function
- Added to Number OrNull Functions for Numeric Types
- Added WITH Clause Support for INSERT SELECT Query
- Added HTTP Timeout Settings for Improved Replication Failover
- Added ALTER Support for Null Type Tables
- Extension of `reinterpretAsString` Function for Contiguous Data Types
- Added --silent Option to clickhouse-local Tool
- Added Single-Digit Date Format Support
Performance Improvement
6- Improved Performance of Aggregate Functions for String Arguments
- Improved Function Performance for isInfinite, isFinite, isNaN, and roundToExp2
- Improved Date and DateTime Parsing and Formatting Performance
- Improved Floating Point Number Parsing Performance and Precision
- Lowered Memory Usage for JOIN with Identical Column Names
- Improved Performance of Statistical Aggregate Functions