cannot query hive table from hive catalog #18395
Closed
richetgeek
announced in
Announcements
Replies: 1 comment
-
try use limit 10, if ok, you can set query_timeout, set query_timeout = 600; |
Beta Was this translation helpful? Give feedback.
0 replies
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
1.create hive catalog
CREATE EXTERNAL CATALOG hive PROPERTIES (
'type'='hive',
'hive.metastore.uris' = 'thrift://xxxxx:9083',
'hadoop.username' = 'hive',
'dfs.nameservices'='xxxx',
'dfs.ha.namenodes.bjCluster'='nn1,nn2',
'dfs.namenode.rpc-address.bjCluster.nn1'='xxx',
'dfs.namenode.rpc-address.bjCluster.nn2'='xxxx',
'dfs.client.failover.proxy.provider.bjCluster'='org.apache.hadoop.hdfs.server.namenode.ha.ConfiguredFailoverProxyProvider'
);
2.copy hdfs-site.xml, core-site.xml to be/conf,fe/conf
3.restart fe.be
table meta can show ,but query timiout 300s,not err lg
Beta Was this translation helpful? Give feedback.
All reactions