wyb opened a new issue #3787:
URL: https://github.com/apache/incubator-doris/issues/3787
1. Create an external hive table, including schema, hive db name, hive table
name and load required properties (hive.metastore.uris).
Implement load from external hive table first, and report an error when
querying from external hive table.
```sql
CREATE EXTERNAL TABLE example_db.broker_table (
k1 DATE,
k2 INT
)
ENGINE=hive
PROPERTIES (
"hive.metastore.uris" = "thrift://127.0.0.1:9083"
)
```
2. Load from external hive table
```sql
LOAD LABEL label0
(DATA FROM TABLE hive_external_table
INTO TABLE table0
(k1,k2,k3,v))
WITH RESOURCE "spark0"
```
----------------------------------------------------------------
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]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
