dilipbiswal commented on a change in pull request #25543:
[SPARK-28795][DOC][SQL] Document CREATE VIEW statement in SQL Reference
URL: https://github.com/apache/spark/pull/25543#discussion_r321911765
##########
File path: docs/sql-ref-syntax-ddl-create-view.md
##########
@@ -19,4 +19,69 @@ license: |
limitations under the License.
---
-**This page is under construction**
+### Description
+Views are based on result-set of complex base `SQL` queries that are hard to
+maintain or understand. `CREATE VIEW` constructs a virtual table that has no
+physical data therefore other operations like `ALTER VIEW` and `DROP VIEW`
+only change metadata.
+
+### Syntax
+{% highlight sql %}
+CREATE [OR REPLACE] [[GLOBAL] TEMPORARY] VIEW [IF NOT EXISTS]
[db_name.]view_name
+ [(column_name [COMMENT column_comment], ...) ]
+ create_view_clauses
+ AS SELECT ...;
+
+ create_view_clauses (order insensitive):
Review comment:
Can we treat `create_view_clauses` a parameter ?
Also the query portion can be made a parameter as well ..
Could we please check some of the earlier prs that went in for format ? For
example: the INSERT pr has the format for how to describe the query parameter.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
[email protected]
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
