diff options
| author | alextarazanov <alextarazanov@yandex-team.com> | 2022-09-05 10:44:39 +0300 |
|---|---|---|
| committer | alextarazanov <alextarazanov@yandex-team.com> | 2022-09-05 10:44:39 +0300 |
| commit | 286a310be3ab04813480a1bd291d618a7bf47d90 (patch) | |
| tree | f2f0bbff053241e1ba22573c01fe18892e07b8ee | |
| parent | 72df838cbfa8ca4828548d82b020dcfa05629c9e (diff) | |
| download | ydb-286a310be3ab04813480a1bd291d618a7bf47d90.tar.gz | |
[review] [YDB] Translate UPSERT and update system requirements
https://a.yandex-team.ru/review/2841353/files/1
https://a.yandex-team.ru/review/2841358/files/1
| -rw-r--r-- | ydb/docs/en/core/cluster/system-requirements.md | 2 | ||||
| -rw-r--r-- | ydb/docs/en/core/yql/reference/yql-core/syntax/_includes/upsert_into.md | 4 |
2 files changed, 4 insertions, 2 deletions
diff --git a/ydb/docs/en/core/cluster/system-requirements.md b/ydb/docs/en/core/cluster/system-requirements.md index 5920601df5a..3c1171a448d 100644 --- a/ydb/docs/en/core/cluster/system-requirements.md +++ b/ydb/docs/en/core/cluster/system-requirements.md @@ -26,6 +26,8 @@ The number of servers and disks is determined by the fault-tolerance requirement {{ ydb-short-name }} health and performance weren't tested on any types of virtual or network storage devices. + When planning space, remember that {{ ydb-short-name }} uses some disk space for its own internal needs. For example, on a medium-sized cluster of 8 nodes, you can expect approximately 100 GB to be consumed for a static group on the whole cluster. On a large cluster with >1500 nodes, this will be about 200 GB. There are also logs of 25.6 GB on each Pdisk and a system area on each Pdisk. Its size depends on the size of the Pdisk, but is no less than 0.2 GB. + ## Software configuration {#software} A {{ ydb-short-name }} server can run on servers with Linux kernel 4.4 or higher. diff --git a/ydb/docs/en/core/yql/reference/yql-core/syntax/_includes/upsert_into.md b/ydb/docs/en/core/yql/reference/yql-core/syntax/_includes/upsert_into.md index 53b3c767f16..3a180141f03 100644 --- a/ydb/docs/en/core/yql/reference/yql-core/syntax/_includes/upsert_into.md +++ b/ydb/docs/en/core/yql/reference/yql-core/syntax/_includes/upsert_into.md @@ -1,6 +1,6 @@ # UPSERT INTO -Adds or updates multiple rows in a table based on primary key matching. Missing rows are added. For the existing rows, the values of the specified columns are updated, but the values of the other columns are preserved. +UPSERT (which stands for UPDATE or INSERT) updates or inserts multiple rows to a table based on a comparison by the primary key. Missing rows are added. For the existing rows, the values of the specified columns are updated, but the values of the other columns are preserved. {% if feature_mapreduce %} The table is searched by name in the database specified by the [USE](../use.md) operator.{% endif %} @@ -16,7 +16,7 @@ Column mapping when using `UPSERT INTO ... SELECT` is done by names. Use `AS` to ```yql UPSERT INTO my_table -SELECT pk_column, data_column1, col24 as data_column3 FROM other_table +SELECT pk_column, data_column1, col24 as data_column3 FROM other_table ``` ```yql |