JingsongLi commented on code in PR #970:
URL: https://github.com/apache/incubator-paimon/pull/970#discussion_r1184885633
##########
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(
Review Comment:
Is there an example to create internal tables?
##########
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:
Can this table be visible in Flink Paimon Catalog with hive metastore?
--
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
