加载中…
个人资料
  • 博客等级:
  • 博客积分:
  • 博客访问:
  • 关注人气:
  • 获赠金笔:0支
  • 赠出金笔:0支
  • 荣誉徽章:
正文 字体大小:

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

(2016-11-22 15:54:41)
标签:

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连接信息

 


  hive.metastore.warehouse.dir
  /user/hive/warehouse
  location of default database for the warehouse

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


hive.metastore.uris
thrift://127.0.0.1:9083

重启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.
        at org.apache.Hadoop.hive.metastore.HiveMetaStoreClient.open(HiveMetaStoreClient.
        at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.(HiveMetaStoreClient.
        at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.(HiveMetaStoreClient.
        at com.cloudera.impala.catalog.MetaStoreClientPool$MetaStoreClient.(MetaStoreClientPool.
        at com.cloudera.impala.catalog.MetaStoreClientPool$MetaStoreClient.(MetaStoreClientPool.
        at com.cloudera.impala.catalog.MetaStoreClientPool.addClients(MetaStoreClientPool.
        at com.cloudera.impala.catalog.Catalog.(Catalog.
        at com.cloudera.impala.catalog.CatalogServiceCatalog.(CatalogServiceCatalog.
        at com.cloudera.impala.service.JniCatalog.(JniCatalog.
Caused by: java.net.ConnectException: Connection refused
        at java.net.PlainSocketImpl.socketConnect(Native Method)
        at
        at
        at
        at
        at
        at org.apache.thrift.transport.TSocket.open(TSocket.
        ... 9 more

解决方法:

在各个节点上运行:

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


再运行


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

即可

0

阅读 收藏 喜欢 打印举报/Report
  

新浪BLOG意见反馈留言板 欢迎批评指正

新浪简介 | About Sina | 广告服务 | 联系我们 | 招聘信息 | 网站律师 | SINA English | 产品答疑

新浪公司 版权所有