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
即可
加载中,请稍候......