You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Copy file name to clipboardExpand all lines: docs/en/sql-reference/statements/create/table.md
+1-1Lines changed: 1 addition & 1 deletion
Display the source diff
Display the rich diff
Original file line number
Diff line number
Diff line change
@@ -152,7 +152,7 @@ SELECT * FROM test;
152
152
153
153
`MATERIALIZED expr`
154
154
155
-
Materialized expression. Values of such columns are always calculated, they cannot be specified in INSERT queries.
155
+
Materialized expression. Values of such columns are automatically calculated according to the specified materialized expression when rows are inserted. Values cannot be explicitly specified during `INSERT`s.
156
156
157
157
Also, default value columns of this type are not included in the result of `SELECT *`. This is to preserve the invariant that the result of a `SELECT *` can always be inserted back into the table using `INSERT`. This behavior can be disabled with setting `asterisk_include_materialized_columns`.
Copy file name to clipboardExpand all lines: docs/en/sql-reference/table-functions/s3.md
+3-3Lines changed: 3 additions & 3 deletions
Display the source diff
Display the rich diff
Original file line number
Diff line number
Diff line change
@@ -269,9 +269,9 @@ FROM s3(
269
269
270
270
## Virtual Columns {#virtual-columns}
271
271
272
-
-`_path` — Path to the file. Type: `LowCardinalty(String)`.
273
-
-`_file` — Name of the file. Type: `LowCardinalty(String)`.
274
-
-`_size` — Size of the file in bytes. Type: `Nullable(UInt64)`. If the file size is unknown, the value is `NULL`.
272
+
-`_path` — Path to the file. Type: `LowCardinalty(String)`. In case of archive, shows path in a format: "{path_to_archive}::{path_to_file_inside_archive}"
273
+
-`_file` — Name of the file. Type: `LowCardinalty(String)`. In case of archive shows name of the file inside the archive.
274
+
-`_size` — Size of the file in bytes. Type: `Nullable(UInt64)`. If the file size is unknown, the value is `NULL`. In case of archive shows uncompressed file size of the file inside the archive.
275
275
-`_time` — Last modified time of the file. Type: `Nullable(DateTime)`. If the time is unknown, the value is `NULL`.
Copy file name to clipboardExpand all lines: docs/en/sql-reference/window-functions/index.md
+2-2Lines changed: 2 additions & 2 deletions
Display the source diff
Display the rich diff
Original file line number
Diff line number
Diff line change
@@ -80,8 +80,8 @@ These functions can be used only as a window function.
80
80
-`nth_value(x, offset)` - Return the first non-NULL value evaluated against the nth row (offset) in its ordered frame.
81
81
-`rank()` - Rank the current row within its partition with gaps.
82
82
-`dense_rank()` - Rank the current row within its partition without gaps.
83
-
-`lagInFrame(x)` - Return a value evaluated at the row that is at a specified physical offset row before the current row within the ordered frame.
84
-
-`leadInFrame(x)` - Return a value evaluated at the row that is offset rows after the current row within the ordered frame.
83
+
-`lagInFrame(x[, offset[, default]])` - Return a value evaluated at the row that is at a specified physical offset row before the current row within the ordered frame. The offset parameter, if not specified, defaults to 1, meaning it will fetch the value from the next row. If the calculated row exceeds the boundaries of the window frame, the specified default value is returned.
84
+
-`leadInFrame(x[, offset[, default]])` - Return a value evaluated at the row that is offset rows after the current row within the ordered frame. If offset is not provided, it defaults to 1. If the offset leads to a position outside the window frame, the specified default value is used.
0 commit comments