/
4.6.0.rst
136 lines (82 loc) · 3.99 KB
/
4.6.0.rst
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
.. _version_4.6.0:
=============
Version 4.6.0
=============
Released on 2021-07-13.
.. NOTE::
If you are upgrading a cluster, you must be running CrateDB 4.0.2 or higher
before you upgrade to 4.6.0.
We recommend that you upgrade to the latest 4.3 release before moving to
4.6.0.
A rolling upgrade from 4.5.x to 4.6.0 is supported.
Before upgrading, you should `back up your data`_.
.. _back up your data: https://crate.io/docs/crate/reference/en/latest/admin/snapshots.html
.. rubric:: Table of Contents
.. contents::
:local:
Deprecations
============
- Deprecated the ``node.max_local_storage_nodes`` setting.
Changes
=======
Performance Improvements
------------------------
- Improved the performance of the :ref:`hyperloglog_distinct
<aggregation-hyperloglog-distinct>` aggregation function.
- Improved the performance of ``SELECT`` statements with ``WHERE`` conditions
that are in the form of ``WHERE COL=COL``.
- Improved the performance of ``INSERT FROM query`` statements where the
``query`` contains a ``GROUP BY`` clause.
- Improved the internal throttling mechanism used for ``INSERT FROM QUERY`` and
``COPY FROM`` operations. This should lead to these queries utilizing more
resources if the cluster can spare them.
- Added an optimization that improves the performance of ``count()``
aggregations on object columns that have at least one inner column with a
``NOT NULL`` constraint.
SQL Statements and Compatibility
--------------------------------
- Added the :ref:`bit(n) <data-type-bit>` data type.
- CrateDB now accepts the ``START TRANSACTION`` statement for :ref:`PostgreSQL
wire protocol <interface-postgresql>` compatibility. However, CrateDB does
not support transactions and will silently ignore this statement.
- Added support for directory-level wild card expansion for URIs passed to
``COPY FROM`` statements.
New Scalars
-----------
- Added :ref:`array_to_string <scalar-array_to_string>` scalar function
that concatenates array elements into a single string using a separator and
an optional null-string.
- Added :ref:`array_min <scalar-array_min>` and :ref:`array_max
<scalar-array_max>` scalar functions returning the minimal and maximal
element in array respectively.
- Added the :ref:`array_sum <scalar-array_sum>` scalar function
that returns the sum of all elements in an array.
- Added the :ref:`array_avg <scalar-array_avg>` scalar function that returns
the average of all elements in an array.
Administration and Operations improvements
------------------------------------------
- Users can now read tables within the ``pg_catalog`` schema without explicit
``DQL`` permission. They will only see records the user has privileges on.
- Users with AL privileges (or DDL on both tables) can now run the following
ALTER CLUSTER commands:
``ALTER CLUSTER SWAP TABLE source TO target``,
``ALTER CLUSTER REROUTE RETRY FAILED``,
``ALTER CLUSTER GC DANGLING ARTIFACTS``.
- Added support for encrypting node-to-node communication.
- Changed the privileges model to allow users with ``DDL`` privileges on a
table to use the :ref:`OPTIMIZE TABLE <sql-optimize>` statement.
- Included the shard information for closed tables in ``sys.shards`` table.
- Added a ``closed`` column to :ref:`sys-shards <sys-shards>` exposing
the state of the table associated with the shard.
- Added support for reading ``cgroup`` information in the ``cgroup v2`` format.
- Added support of hostnames in HBA configuration.
Administration Console
----------------------
- Removed all analytics (UDC, Segment)
- Removed the "Notifications" section in the status bar
- Removed min-width for columns in console to reduce scrolling
- Changed syntax highlighting in console. Keywords in double quotes are now longer
highlighted. Types are highlighted with a different color.
- Activated ``codemirror`` code hints for keywords.
- Changed the look of the scroll bar to appear more modern.
- Added length limit for ``varchar(n)`` and ``bit(n)`` types in table view.