JingsongLi commented on a change in pull request #10590:
[FLINK-15205][hive][document] Update hive partition and orc for read_write_hive
URL: https://github.com/apache/flink/pull/10590#discussion_r358596893
##########
File path: docs/dev/table/hive/read_write_hive.md
##########
@@ -111,16 +111,44 @@ __________ __________
## Writing To Hive
-Similarly, data can be written into hive using an `INSERT INTO` clause.
+Similarly, data can be written into hive using an `INSERT` clause. Consider
there is a mytable table with two columns: name, age.
{% highlight bash %}
-Flink SQL> INSERT INTO mytable (name, value) VALUES ('Tom', 4.72);
+# ------ Insert with append mode ------
+Flink SQL> INSERT INTO mytable SELECT 'Tom', 25;
+
+# ------ Insert with overwrite mode ------
+Flink SQL> INSERT OVERWRITE mytable SELECT 'Tom', 25;
Review comment:
Will modify to:
```
INSERT INTO will append to the table or partition, keeping the existing data
intact.
INSERT OVERWRITE will overwrite any existing data in the table or partition.
```
----------------------------------------------------------------
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
With regards,
Apache Git Services
