zhanghaicheng1 opened a new issue, #10331:
URL: https://github.com/apache/doris/issues/10331

   ### Search before asking
   
   - [X] I had searched in the 
[issues](https://github.com/apache/incubator-doris/issues?q=is%3Aissue) and 
found no similar issues.
   
   
   ### Description
   
   【hive】创建的外部表
   ```
   CREATE EXTERNAL TABLE default.emp_ext(
   empno INT,
   ename STRING,
   job STRING,
   mgr INT,
   hiredate STRING,
   sal DOUBLE,
   comm DOUBLE,
   deptno INT
   )
   ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t'
   LOCATION '/user/hive/warehouse/default/emp_ext';
   ```
   
   [Hive of Doris]
   ```
   CREATE TABLE emp_ext(
   empno INT,
   ename STRING,
   job STRING,
   mgr INT,
   hiredate STRING,
   sal DOUBLE,
   comm DOUBLE,
   deptno INT
   )ENGINE=HIVE
   COMMENT "测试表"
   PROPERTIES (
   'hive.metastore.uris' = 'thrift://centos4:9083',
   'database' = 'default',
   'table' = 'emp_ext'
   );
   ```
   
   提示的错误信息:
   ```
   2022-06-22 13:45:21,385 WARN (doris-mysql-nio-pool-11|442) 
[CreateTableStmt.analyzeEngineName():497] create hive table without keyword 
external
   2022-06-22 13:45:22,007 WARN (doris-mysql-nio-pool-11|442) 
[HiveMetaStoreClientHelper.tableExists():146] Hive metastore thrift exception: 
Invalid method name: 'get_table_req'
   2022-06-22 13:47:02,377 WARN (doris-mysql-nio-pool-12|448) 
[CreateTableStmt.analyzeEngineName():497] create hive table without keyword 
external
   2022-06-22 13:47:02,445 WARN (doris-mysql-nio-pool-12|448) 
[HiveMetaStoreClientHelper.tableExists():146] Hive metastore thrift exception: 
Invalid method name: 'get_table_req'
   2022-06-22 13:55:34,924 WARN (doris-mysql-nio-pool-14|453) 
[HiveMetaStoreClientHelper.tableExists():146] Hive metastore thrift exception: 
Invalid method name: 'get_table_req'
   2022-06-22 13:57:39,921 WARN (doris-mysql-nio-pool-15|459) 
[CreateTableStmt.analyzeEngineName():497] create hive table without keyword 
external
   2022-06-22 13:57:39,978 WARN (doris-mysql-nio-pool-15|459) 
[HiveMetaStoreClientHelper.tableExists():146] Hive metastore thrift exception: 
Invalid method name: 'get_table_req'
   2022-06-22 14:00:45,461 WARN (doris-mysql-nio-pool-16|473) 
[HiveMetaStoreClientHelper.tableExists():146] Hive metastore thrift exception: 
Invalid method name: 'get_table_req'
   ```
   
   ### Use case
   
   _No response_
   
   ### Related issues
   
   _No response_
   
   ### Are you willing to submit PR?
   
   - [ ] Yes I am willing to submit a PR!
   
   ### Code of Conduct
   
   - [X] I agree to follow this project's [Code of 
Conduct](https://www.apache.org/foundation/policies/conduct)
   


-- 
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: commits-unsubscr...@doris.apache.org.apache.org

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


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org

Reply via email to