zhuangchong commented on code in PR #970:
URL: https://github.com/apache/incubator-paimon/pull/970#discussion_r1184895650


##########
docs/content/engines/hive.md:
##########
@@ -213,6 +218,35 @@ OK
 
 ```
 
+* To create paimon tables that do not exist, you can create them as external 
and internal tables in Hive. Run the following Hive SQL in Hive CLI.
+
+```sql
+-- Assume that paimon-hive-connector-{{< version >}}.jar is already in auxlib 
directory.
+-- Let's create a new table that doesn't exist in paimon.
+-- Need to specify the location to the path of table.
+
+CREATE EXTERNAL TABLE hive_test_table(
+    a INT COMMENT 'The a field',
+    b STRING COMMENT 'The b field'
+)
+STORED BY 'org.apache.paimon.hive.PaimonStorageHandler'
+LOCATION '/path/to/table/store/warehouse/default.db/hive_test_table';
+
+-- Insert records into hive_test_table
+
+INSERT INTO hive_test_table VALUES (1, 'Paimon');

Review Comment:
   This table is visible, 
   document link: 
   
https://github.com/apache/incubator-paimon/blob/7ec22998b2d4aa3d97fbc5cfc1683ef3daf29ad3/docs/content/engines/hive.md?plain=1#L135-L163
   
   test case:
   
https://github.com/apache/incubator-paimon/blob/7ec22998b2d4aa3d97fbc5cfc1683ef3daf29ad3/paimon-hive/paimon-hive-connector-common/src/test/java/org/apache/paimon/hive/HiveCatalogITCaseBase.java#L268-L280



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

To unsubscribe, e-mail: issues-unsubscr...@paimon.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org

Reply via email to