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_r358498282
 
 

 ##########
 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;
+{% endhighlight %}
+
+We support partition table too, Consider there is a myparttable table with 
four columns: name, age, my_type and my_date. Column my_type and column my_date 
are the partition columns.
 
 Review comment:
   ```suggestion
   We support partitioned table too, Consider there is a partitioned table 
named myparttable with four columns: name, age, my_type and my_date, in types 
...... my_type and my_date are the partition keys.
   ```

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