bowenli86 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_r358497799
 
 

 ##########
 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:
   are "append mode" and "overwrite mode" official names? 
   
   maybe just say "insert new values by appending to existing table" and 
"insert new values by overwriting the whole existing table"
   

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

Reply via email to