CDH-HIVE启动 metastore报错 Error creating transactional connection

第一步检查 hive.site.xml的元数据库地址是否正确

第二步检查 $hive_home/lib 是否有数据库驱动包 具体目录根据报错的日志观看

第三步 重启 hive --service metastore启动

若出现
Exception in thread “main” org.apache.thrift.transport.TTransportException: Could not create ServerSocket on address 0.0.0.0/0.0.0.0:9083. at org.apache.thrift.transport.TServerSocket.(TServerSocket.java:93) at org.apache.thrift.transport.TServerSocket.(TServerSocket.java:75) at org.apache.hadoop.hive.metastore.TServerSocketKeepAlive.(TServerSocketKeepAlive.java:34) at org.apache.hadoop.hive.metastore.HiveMetaStore.startMetaStore(HiveMetaStore.java:5706) at org.apache.hadoop.hive.metastore.HiveMetaStore.main(HiveMetaStore.java:5649) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at org.apache.hadoop.util.RunJar.run(RunJar.java:221) at org.apache.hadoop.util.RunJar.main(RunJar.java:136)

则 jps 杀掉runjar的进程

然后重新启动
---------------------hive --service metastore