Doris 创建 hive 外表时报错 #20424
Unanswered
CodeCooker17
asked this question in
A - General / Q&A
Doris 创建 hive 外表时报错
#20424
Replies: 1 comment 1 reply
-
|
Now it is recommended to use a catalog instead of External Table. External Table has been marked as deprecated. If your Doris does not support Hive Catalog, you can upgrade to the latest version 1.2.4.1(Stable). |
Beta Was this translation helpful? Give feedback.
1 reply
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Uh oh!
There was an error while loading. Please reload this page.
-
CREATE TABLE
hive_v2(tag_idvarchar(128) ,tag_valuevarchar(128) ,case_idint) ENGINE=HIVE
COMMENT "HIVE"
PROPERTIES (
'hive.metastore.uris' = '',
'database' = 'dm_dmp',
'table' = 'auto_user_is_aiqicha_company_tag_v2',
'dfs.nameservices'='',
'dfs.ha.namenodes.hacluster'='nn1,nn2',
'dfs.namenode.rpc-address.hacluster.n1'='',
'dfs.namenode.rpc-address.hacluster.n2'='',
'dfs.client.failover.proxy.provider.hacluster'='org.apache.hadoop.hdfs.server.namenode.ha.ConfiguredFailoverProxyProvider'
);
通过这种方式创建 hive 外表时报错:Execution failed: Error Failed to execute sql: java.sql.SQLException: (conn=279) Unexpected exception: failed to check if table auto_user_is_aiqicha_company_tag_v2 in db dm_dmp exists. reason: shade.doris.hive.org.apache.thrift.TApplicationException: Invalid method name: 'get_table_req'
hive 版本2.1.2
创建 catalog 是可以指定 hive 版本的,但是创建 hive 外表时不能指定 hive 版本,有什么好的方式解决这个问题吗
Beta Was this translation helpful? Give feedback.
All reactions