dilipbiswal commented on a change in pull request #25522:
[SPARK-28787][DOC][SQL]Document LOAD DATA statement in SQL Reference
URL: https://github.com/apache/spark/pull/25522#discussion_r319735674
##########
File path: docs/sql-ref-syntax-dml-load.md
##########
@@ -19,4 +19,63 @@ license: |
limitations under the License.
---
-**This page is under construction**
+### Description
+`LOAD DATA` loads data from a directoy or a file into a table or into a
partition in the table. A partition spec should be specified whenever the
target table is partitioned. The `LOAD DATA` statement can only be used with
tables created using the Hive format.
+
+### Syntax
+{% highlight sql %}
+LOAD DATA [ LOCAL ] INPATH path [ OVERWRITE ] INTO TABLE table_name
+ [ PARTITION ( partition_col_name [ = partition_col_val ] [ , ... ] ) ]
+{% endhighlight %}
+
+### Parameters
+<dl>
+ <dt><code><em>path</em></code></dt>
+ <dd>Path of the file system.</dd>
Review comment:
@huaxingao I was looking up the hive documentation. They mention about load
deleting the data from source directory i.e they do a move operation. I think
this is a important thing to say if that is the behaviour.
----------------------------------------------------------------
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]
