安装和使用impala出现的问题及解决方法

1、没有成功安装impala-server impala-state-store  impala-catalog：

      修改错误的/etc/yum.repos.d

2、找不到JDO什么FactoryManager类：修改jar包路径

3 、mysql-connector-java-5.1.30-bin.jar 放进/var/lib/impala/中

4、修改hive-site.xml中MySQL连接信息

<property>
  <name>hive.metastore.warehouse.dir</name>
  <value>/user/hive/warehouse</value>
  <description>location of default database for the warehouse</description>
</property>

<property> 
<name>hive.metastore.local</name> 
  <value>false</value> 
</property> 
   
<property> 
<name>javax.jdo.option.ConnectionURL</name> 
  <value>jdbc:mysql://10.61.0.106:3306/hive?createDatabaseIfNotExist=true&amp;useUnicode=true&amp;characterEncoding=UTF-8</value> 
</property> 
   
<property> 
<name>javax.jdo.option.ConnectionDriverName</name> 
  <value>com.mysql.jdbc.Driver</value> 
</property> 
   
<property>  
  <name>javax.jdo.option.ConnectionUserName</name>  
  <value>hive</value>  
</property>  
     
<property>  
  <name>javax.jdo.option.ConnectionPassword</name>  
  <value>hive</value>  
</property>

<property>
<name>hive.metastore.uris</name>
<value>thrift://127.0.0.1:9083</value>
</property>

重启mysql  ： sudo service mysqld restart

4、这两个服务要先启动：

    hive --service metastore &
     hive --service hiveserver &

然后再启动hive

5、问题：

在impala-shell中运行show databases后报错：

Running on machine: node1
Log line format: [IWEF]mmdd hh:mm:ss.uuuuuu threadid file:line] msg
E0417 11:05:24.897881  6858 catalog.cc:77] java.lang.IllegalStateException: MetaException(message:Could not connect to meta store using any of the URIs provided. Most recent failure: org.apache.thrift.transport.TTransportException: java.net.ConnectException: Connection refused
        at org.apache.thrift.transport.TSocket.open(TSocket.java:185)
        at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.open(HiveMetaStoreClient.java:277)
        at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.<init>(HiveMetaStoreClient.java:163)
        at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.<init>(HiveMetaStoreClient.java:103)
        at com.cloudera.impala.catalog.MetaStoreClientPool$MetaStoreClient.<init>(MetaStoreClientPool.java:48)
        at com.cloudera.impala.catalog.MetaStoreClientPool$MetaStoreClient.<init>(MetaStoreClientPool.java:41)
        at com.cloudera.impala.catalog.MetaStoreClientPool.addClients(MetaStoreClientPool.java:106)
        at com.cloudera.impala.catalog.Catalog.<init>(Catalog.java:73)
        at com.cloudera.impala.catalog.CatalogServiceCatalog.<init>(CatalogServiceCatalog.java:100)
        at com.cloudera.impala.service.JniCatalog.<init>(JniCatalog.java:75)
Caused by: java.net.ConnectException: Connection refused
        at java.net.PlainSocketImpl.socketConnect(Native Method)
        at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:351)
        at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:213)
        at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:200)
        at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)
        at java.net.Socket.connect(Socket.java:529)
        at org.apache.thrift.transport.TSocket.open(TSocket.java:180)
        ... 9 more

解决方法：

在各个节点上运行：

    hive --service metastore &
     hive --service hiveserver &

再运行

service impala-server restart
service impala-state-store restart
service impala-catalog restart

即可