aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authoralextarazanov <alextarazanov@yandex-team.com>2022-10-11 10:37:29 +0300
committeralextarazanov <alextarazanov@yandex-team.com>2022-10-11 10:37:29 +0300
commit69b2ac8429dc147401c2bdffef088b09a169bbcc (patch)
tree0bacd3b59a923686645929c1c046e3dcc6303b07
parent0a1cad3a38e0df480eb17194b64ff1965cab487e (diff)
downloadydb-69b2ac8429dc147401c2bdffef088b09a169bbcc.tar.gz
[review] [YDB] Small fixes check translate
-rw-r--r--ydb/docs/en/core/yql/reference/yql-core/syntax/_includes/create_table.md16
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 %}