DOCSUP-2954: Documented the view function #15881

sevirov · 2020-10-12T21:41:56Z

I hereby agree to the terms of the CLA available at: https://yandex.ru/legal/cla/?lang=en

Changelog category:

Documentation for table function view #12567

Создал файл view.md и сделал описание функции view.

BayoNet · 2020-10-13T16:07:50Z

docs/en/sql-reference/table-functions/view.md

@@ -0,0 +1,61 @@
+## View {#view}


Suggested change

## View {#view}

## view {#view}

BayoNet · 2020-10-13T16:12:18Z

docs/en/sql-reference/table-functions/view.md

@@ -0,0 +1,61 @@
+## View {#view}
+
+Turns an subquery into a table object.


This function works similarly to the view table engine. There is no much information, but it can help to make the description more informative.

BayoNet · 2020-10-13T16:13:40Z

docs/en/sql-reference/table-functions/view.md

+
+**Parameters**
+
+-   `subquery` — An example: SELECT a, b, c FROM table_name.


Subquery can be only of the SELECT type.

BayoNet · 2020-10-13T16:14:56Z

docs/en/sql-reference/table-functions/view.md

+
+**Returned value**
+
+-   A table object.


"Table object" is the internal term. For users it's just "A table".

BayoNet · 2020-10-13T16:17:47Z

docs/en/sql-reference/table-functions/view.md

+└──────────┘
+```
+
+The function view helps passing queries around. For instance, it can be used in remote/cluster table functions:


What does it mean "passing queries around"?

I made changes.

Changed parametrs.

BayoNet · 2020-10-15T10:48:51Z

docs/en/sql-reference/table-functions/view.md

+
+**Parameters**
+
+-   `subquery` — Subquery of the `SELECT` type only.


Suggested change

- `subquery` — Subquery of the `SELECT` type only.

- `subquery` — `SELECT` query.

BayoNet · 2020-10-15T10:50:29Z

docs/en/sql-reference/table-functions/view.md

+└──────────┘
+```
+
+Function `view` can be used in `remote` or `cluster` table functions:


Suggested change

Function `view` can be used in `remote` or `cluster` table functions:

You can use the `view` function as a parameter of the `remote` and `cluster` table functions:

Also, missing links to the remote and cluster table functions.

BayoNet · 2020-10-15T10:58:01Z

docs/en/sql-reference/table-functions/view.md

+
+## view {#view}
+
+Turns an subquery into a table. Used for implementing views (for more information, see the `CREATE VIEW query`). It does not store data, but only stores the specified `SELECT` query. When reading from a table, it runs this query (and deletes all unnecessary columns from the query).


Suggested change

Turns an subquery into a table. Used for implementing views (for more information, see the `CREATE VIEW query`). It does not store data, but only stores the specified `SELECT` query. When reading from a table, it runs this query (and deletes all unnecessary columns from the query).

Turns a subquery into a table. The function implements views (for more information, see the `CREATE VIEW query`). The resulting table doesn't store data, but only the specified `SELECT` query. when When reading from the table, ClickHouse executes the query and and deletes all unnecessary columns from the result.

Missing link to CREATE VIEW.

Changed by comments.

Перевел на русский язык.

BayoNet · 2020-10-16T16:09:20Z

docs/en/sql-reference/table-functions/view.md

+
+## view {#view}
+
+Turns a subquery into a table. The function implements views (for more information, see the [CREATE VIEW](https://clickhouse.tech/docs/en/sql-reference/statements/create/view/#create-view). The resulting table doesn't store data, but only stores the specified `SELECT` query. When reading from the table, ClickHouse executes the query and deletes all unnecessary columns from the result.


"the CREATE VIEW query" or "CREATE VIEW"

"For more information" is a redundant phrase with zero use. Please delete it.

BayoNet · 2020-10-16T16:10:05Z

docs/ru/sql-reference/table-functions/view.md

+
+**Входные параметры**
+
+-   `subquery` — `SELECT` запрос.


Suggested change

- `subquery` — `SELECT` запрос.

- `subquery` — запрос `SELECT`.

Changed by comments.

Changed links.

* master: (719 commits) Revert "scipy" DOCSUP-3478: Documented the iLike function (ClickHouse#15880) DOCSUP-2954: Documented the view function (ClickHouse#15881) DOCSUP-2861: Translate on Russian (ClickHouse#16042) fix for floats tests for nullable_aggregate_states Update settings.md Update replication.md Update replication.md Update replication.md Update settings.md test for the bug 8580 test for the bug ClickHouse#8490 test for the bug ClickHouse#8425 Update run.sh done remove warnings in integration tests reset error code in ast fuzzer fix segfault with wrong aggregation in lambdas restart the tests ... # Conflicts: # src/Access/IAccessStorage.cpp # src/Access/IAccessStorage.h # src/Access/LDAPAccessStorage.cpp # src/Access/LDAPAccessStorage.h # src/Access/LDAPParams.h # src/Access/MultipleAccessStorage.cpp # src/Common/ErrorCodes.cpp # src/Server/HTTPHandler.cpp

Create view.md

b20e2cb

Создал файл view.md и сделал описание функции view.

robot-clickhouse added the pr-documentation Documentation PRs for the specific code PR label Oct 12, 2020

BayoNet added the can be tested label Oct 13, 2020

BayoNet reviewed Oct 13, 2020

View reviewed changes

sevirov added 2 commits October 13, 2020 22:02

Update view.md

78a3aba

I made changes.

Update view.md

14558d3

Changed parametrs.

BayoNet reviewed Oct 15, 2020

View reviewed changes

sevirov added 2 commits October 15, 2020 19:54

Update view.md

21bf02a

Changed by comments.

Create view.md

27bc41b

Перевел на русский язык.

BayoNet reviewed Oct 16, 2020

View reviewed changes

sevirov added 2 commits October 16, 2020 23:40

Update ru and en file view.md

1717685

Changed by comments.

Update en and ru versions view function.

284b76a

Changed links.

BayoNet merged commit 0a764be into ClickHouse:master Oct 19, 2020

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

DOCSUP-2954: Documented the view function #15881

DOCSUP-2954: Documented the view function #15881

sevirov commented Oct 12, 2020

BayoNet Oct 13, 2020

BayoNet Oct 13, 2020

BayoNet Oct 13, 2020

BayoNet Oct 13, 2020

BayoNet Oct 13, 2020

BayoNet Oct 15, 2020

BayoNet Oct 15, 2020 •

edited

BayoNet Oct 15, 2020 •

edited

BayoNet Oct 15, 2020

BayoNet Oct 15, 2020

BayoNet Oct 16, 2020

BayoNet Oct 16, 2020

		@@ -0,0 +1,61 @@
		## View {#view}

		Turns an subquery into a table object.


		Parameters

		- `subquery` — An example: SELECT a, b, c FROM table_name.


		Parameters

		- `subquery` — Subquery of the `SELECT` type only.

	- `subquery` — Subquery of the `SELECT` type only.
	- `subquery` — `SELECT` query.

	Function `view` can be used in `remote` or `cluster` table functions:
	You can use the `view` function as a parameter of the `remote` and `cluster` table functions:


		## view {#view}

		Turns an subquery into a table. Used for implementing views (for more information, see the `CREATE VIEW query`). It does not store data, but only stores the specified `SELECT` query. When reading from a table, it runs this query (and deletes all unnecessary columns from the query).

	Turns an subquery into a table. Used for implementing views (for more information, see the `CREATE VIEW query`). It does not store data, but only stores the specified `SELECT` query. When reading from a table, it runs this query (and deletes all unnecessary columns from the query).
	Turns a subquery into a table. The function implements views (for more information, see the `CREATE VIEW query`). The resulting table doesn't store data, but only the specified `SELECT` query. when When reading from the table, ClickHouse executes the query and and deletes all unnecessary columns from the result.


		Входные параметры

		- `subquery` — `SELECT` запрос.

	- `subquery` — `SELECT` запрос.
	- `subquery` — запрос `SELECT`.

DOCSUP-2954: Documented the view function #15881

DOCSUP-2954: Documented the view function #15881

Conversation

sevirov commented Oct 12, 2020

Choose a reason for hiding this comment

Choose a reason for hiding this comment

Choose a reason for hiding this comment

Choose a reason for hiding this comment

Choose a reason for hiding this comment

Choose a reason for hiding this comment

BayoNet Oct 15, 2020 • edited

Choose a reason for hiding this comment

BayoNet Oct 15, 2020 • edited

Choose a reason for hiding this comment

Choose a reason for hiding this comment

Choose a reason for hiding this comment

Choose a reason for hiding this comment

Choose a reason for hiding this comment

BayoNet Oct 15, 2020 •

edited

BayoNet Oct 15, 2020 •

edited