impala无法连接到远程元存储

qvtsj1bj  于 2021-06-04  发布在  Hadoop
关注(0)|答案(0)|浏览(195)

我正在尝试使用亚马逊电子病历 Impala 。我可以用hive读取s3数据。但我不能用 Impala 壳。我尝试了“使元数据无效”。远程元存储在rds中。但impala可能会在emr主节点上使用metastore。如何将远程元存储与impala一起使用?
我用amazonemr命令行界面像这样启动了emr。

./elastic-mapreduce \
--create \
--name "Impala" \
--alive \
--enable-debugging \
--log-uri "s3n://hoge/hoge.log" \
--key-pair "hoge" \
--instance-group master --instance-type m1.large --instance-count 1\
--instance-group core --instance-type m1.large --instance-count 1\
--ami-version 3.0.2 \
--impala-interactive \
--hive-interactive \
--hive-site "s3n://hoge/hive-site.xml"

hive-site.xml是这样的。这与http://docs.aws.amazon.com/elasticmapreduce/latest/developerguide/emr-dev-create-metastore-outside.html

<configuration>
  <property>
    <name>javax.jdo.option.ConnectionURL</name>
    <value>jdbc:mysql://hostname:3306/hive?createDatabaseIfNotExist=true</value>
    <description>JDBC connect string for a JDBC metastore</description>
  </property>
  <property>
    <name>javax.jdo.option.ConnectionDriverName</name>
    <value>com.mysql.jdbc.Driver</value>
    <description>Driver class name for a JDBC metastore</description>
  </property>
  <property>
    <name>javax.jdo.option.ConnectionUserName</name>
    <value>username</value>
    <description>Username to use against metastore database</description>
  </property>
  <property>
    <name>javax.jdo.option.ConnectionPassword</name>
    <value>password</value>
    <description>Password to use against metastore database</description>
  </property>
</configuration>

暂无答案!

目前还没有任何答案,快来回答吧!

相关问题