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 ..
----------------------------------------------------------------
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]
