kiszk commented on a change in pull request #28451: URL: https://github.com/apache/spark/pull/28451#discussion_r420204430
########## File path: docs/sql-ref-syntax-ddl-create-table-like.md ########## @@ -25,57 +25,46 @@ The `CREATE TABLE` statement defines a new table using the definition/metadata o ### Syntax -{% highlight sql %} +```sql CREATE TABLE [IF NOT EXISTS] table_identifier LIKE source_table_identifier USING data_source [ ROW FORMAT row_format ] [ STORED AS file_format ] [ TBLPROPERTIES ( key1=val1, key2=val2, ... ) ] [ LOCATION path ] -{% endhighlight %} +``` ### Parameters -<dl> - <dt><code><em>table_identifier</em></code></dt> - <dd> - Specifies a table name, which may be optionally qualified with a database name.<br><br> - <b>Syntax:</b> [ TBLPROPERTIES ( key1=val1, key2=val2, ... ) ] - <code> - [ database_name. ] table_name - </code> - </dd> -</dl> - -<dl> - <dt><code><em>USING data_source</em></code></dt> - <dd>Data Source is the input format used to create the table. Data source can be CSV, TXT, ORC, JDBC, PARQUET, etc.</dd> -</dl> - -<dl> - <dt><code><em>ROW FORMAT</em></code></dt> - <dd>SERDE is used to specify a custom SerDe or the DELIMITED clause in order to use the native SerDe.</dd> -</dl> - -<dl> - <dt><code><em>STORED AS</em></code></dt> - <dd>File format for table storage, could be TEXTFILE, ORC, PARQUET,etc.</dd> -</dl> - -<dl> - <dt><code><em>TBLPROPERTIES</em></code></dt> - <dd>Table properties that have to be set are specified, such as `created.by.user`, `owner`, etc. - </dd> -</dl> - -<dl> - <dt><code><em>LOCATION</em></code></dt> - <dd>Path to the directory where table data is stored,Path to the directory where table data is stored, which could be a path on distributed storage like HDFS, etc. Location to create an external table.</dd> -</dl> +* **table_identifier** + + Specifies a table name, which may be optionally qualified with a database name. + + **Syntax:** `[ database_name. ] table_name` + +* **USING data_source** + + Data Source is the input format used to create the table. Data source can be CSV, TXT, ORC, JDBC, PARQUET, etc. + +* **ROW FORMAT** + + SERDE is used to specify a custom SerDe or the DELIMITED clause in order to use the native SerDe. + +* **STORED AS** + + File format for table storage, could be TEXTFILE, ORC, PARQUET,etc. Review comment: ditto ---------------------------------------------------------------- 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: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: reviews-unsubscr...@spark.apache.org For additional commands, e-mail: reviews-h...@spark.apache.org