diff options
author | alextarazanov <alextarazanov@yandex-team.com> | 2022-10-11 10:37:29 +0300 |
---|---|---|
committer | alextarazanov <alextarazanov@yandex-team.com> | 2022-10-11 10:37:29 +0300 |
commit | 69b2ac8429dc147401c2bdffef088b09a169bbcc (patch) | |
tree | 0bacd3b59a923686645929c1c046e3dcc6303b07 | |
parent | 0a1cad3a38e0df480eb17194b64ff1965cab487e (diff) | |
download | ydb-69b2ac8429dc147401c2bdffef088b09a169bbcc.tar.gz |
[review] [YDB] Small fixes check translate
-rw-r--r-- | ydb/docs/en/core/yql/reference/yql-core/syntax/_includes/create_table.md | 16 |
1 files changed, 7 insertions, 9 deletions
diff --git a/ydb/docs/en/core/yql/reference/yql-core/syntax/_includes/create_table.md b/ydb/docs/en/core/yql/reference/yql-core/syntax/_includes/create_table.md index 429102c139..d6224b26f8 100644 --- a/ydb/docs/en/core/yql/reference/yql-core/syntax/_includes/create_table.md +++ b/ydb/docs/en/core/yql/reference/yql-core/syntax/_includes/create_table.md @@ -39,7 +39,6 @@ For the key and non-key columns, you can only use [primitive](../../types/primit {% if feature_not_null == true %} Without additional modifiers, a column gets an [optional type](../../types/optional.md) and allows `NULL` values to be written. To create a non-optional type, use `NOT NULL`. {% else %} - {% if feature_not_null_for_pk %} All columns are [optional](../../types/optional.md) by default and can be assigned NULL values. The `NOT NULL` limit can only be specified for columns that are part of the primary key.. {% else %} @@ -50,7 +49,6 @@ All columns allow writing `NULL` values, that is, they are [optional](../../type It is mandatory to specify the `PRIMARY KEY` with a non-empty list of columns. Those columns become part of the key in the listed order. {% endif %} - **Example** CREATE TABLE my_table ( @@ -71,9 +69,9 @@ It is mandatory to specify the `PRIMARY KEY` with a non-empty list of columns. T The INDEX construct is used to define a {% if concept_secondary_index %}[secondary index]({{ concept_secondary_index }}){% else %}secondary index{% endif %} in a table: ```sql -CREATE TABLE table_name ( +CREATE TABLE table_name ( ... - INDEX <Index_name> GLOBAL [SYNC|ASYNC] ON ( <Index_columns> ) COVER ( <Cover_columns> ), + INDEX <index_name> GLOBAL [SYNC|ASYNC] ON ( <index_columns> ) COVER ( <cover_columns> ), ... ) ``` @@ -86,14 +84,14 @@ where: **Example** -```sql +``` sql CREATE TABLE my_table ( a Uint64, b Bool, c Uft8, d Date, - INDEX idx_a GLOBAL ON (d), - INDEX idx_ca GLOBAL ASYNC ON (b, a) COVER ( c ), + INDEX idx_d GLOBAL ON (d), + INDEX idx_ba GLOBAL ASYNC ON (b, a) COVER (c), PRIMARY KEY (a) ) ``` @@ -115,7 +113,7 @@ WITH ( Here, key is the name of the parameter and value is its value. -For a list of possible parameter names and their values, see the [{{ backend_name }} table description]({{ concept_table }}). +For a list of valid parameter names and values, see the [{{ backend_name }} table description]({{ concept_table }}). For example, this code will create a table with enabled automatic partitioning by partition size and the preferred size of each partition is 512 MB: @@ -172,4 +170,4 @@ Available types of storage devices depend on the {{ ydb-short-name }} cluster co -{% endif %}
\ No newline at end of file +{% endif %} |