v.1.1.54362
Backward Incompatible Changes
3Bug Fix
25- Fixed Subquery Column Removal Issues
- Fixed Merges Bug in ReplacingMergeTree Tables
- Fixed Synchronous Insertions in Distributed Tables
- Fixed Segfault in FULL and RIGHT JOIN with Duplicate Columns in Subqueries
- Fixed Segfault in replace_running_query and KILL QUERY Usage
- Fixed Column Order in system.dictionaries Table
- Fixed Metadata Deletion Bug in DROP DATABASE Query
- Fixed DROP DATABASE Query for Dictionary Databases
- Fixed Low Precision in uniqHLL12 and uniqCombined Functions for Large Cardinalities
- Fixed Implicit Default Value Calculation in INSERT Queries
- Fixed Query Completion Issue in MergeTree Table
- Fixed Crash in CHECK Query for Local Distributed Tables
- Fixed Performance Regression in Regex Functions
- Fixed Performance Regression in Multidimensional Arrays Creation
- Fixed Bug Causing Extra FORMAT Section in SQL Metadata Files
- Fixed Bug with max_table_size_to_drop Limit on MATERIALIZED VIEW Deletion
- Fixed Incompatibility with Old Clients for DateTime Type
- Fixed Bug with Nested Column Elements in Structures for Altered Partitions
- Fixed Bug in Filtering Merge Table Queries by Virtual Columns
- Fixed Bug with ALIAS Columns in Distributed Tables
- Fixed bug in dynamic compilation for aggregate functions
- Fixed Race Condition in Merge Tables with GLOBAL Subqueries
- Fixed Crash in arrayReduce with Variable-Size Arrays
- Prohibition of UNION ALL in MATERIALIZED VIEW Queries
- Fixed Initialization Error of part_log System Table on Server Start
Improvement
13- Limits on Intermediate Data for INSERT SELECT and SELECT Subqueries Removed
- Fewer False Triggers of force_restore_data on Server Start for Replicated Tables
- Added allow_distributed_ddl Option
- Nondeterministic Functions Prohibited in MergeTree Table Keys
- Files Loaded in Alphabetical Order from config.d Directories
- Improved arrayElement function performance for constant multidimensional arrays with empty elements
- Server Startup Speed Improved with Large Configuration File Substitutions
- Table Valued Functions Optimization in Queries
- MkDocs Documentation Generator Usage
- Exception When Deleting Column with Dependent DEFAULT/MATERIALIZED Expressions
- Ability to Parse Empty Lines as 0 for Float Data Types Restored
- Enum Values in Functions Restored in Release 1.1.54337
- Added max_expanded_ast_elements for AST Size Restriction
New Feature
35- Aggregation Behavior Change for Empty Sets in SQL
- Type Conversion for UNION ALL Now Supports Different Alias Names in SELECT Positions
- Support for Arbitrary Expressions in LIMIT BY Clauses
- Using Index of MergeTree Tables with IN on Primary Key Tuples
- Added clickhouse-copier tool for cluster copying and resharding (beta)
- Added Consistent Hashing Functions for Reduced Network Traffic
- Added New Array and Collection Functions
- Added arrayCumSum Function
- Added Functions for Flexible DateTime Parsing
- Partial Data Reloading from External Dictionaries During Updates
- Added cluster table function with remote table compatibility
- Remote and Cluster Table Functions in INSERT Queries
- Added Virtual Columns to system.tables Table
- Added Columns to System Tables
- Added Information on Merges in system.part_log Table
- Arbitrary Partitioning Key for System Query Log Table
- SHOW TABLES Query Updated to Include Temporary Tables
- Added DROP TEMPORARY TABLE and EXISTS TEMPORARY TABLE Queries
- Support SHOW CREATE TABLE for Temporary Tables
- Added system_profile configuration parameter for internal settings
- Support for loading object_id in MongoDB dictionaries
- Reading null as Default Value for External Dictionary with MongoDB Source
- Reading DateTime Values from Unix Timestamp Without Quotes
- Failover Support in Remote Table Functions
- Configuration Override for ClickHouse Server via Command Line
- Implemented Empty Function for FixedString Null Byte Check
- Added listen_try Parameter for Improved Listening Behavior
- Added VersionedCollapsingMergeTree Table Engine
- Support for Rows and Numeric Types in Library Dictionary Source
- Using MergeTree Tables Without a Primary Key
- Nullable Type Casting to Non-Nullable When Not NULL
- RENAME TABLE Can Be Used for VIEW
- Added throwIf Function
- Added odbc_default_field_size Option for ODBC Source Value Size扩大
- Enhancements to system.processes Table and SHOW PROCESSLIST: New Columns Added