有关hive搭建涉及到的bug

启动了hive，再次启动

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:5192)
    at org.apache.hadoop.hive.metastore.HivemetaStore.main(HivemetaStore.java:5134)
    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.main(RunJar.java:212)
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:5192)
    at org.apache.hadoop.hive.metastore.HivemetaStore.main(HivemetaStore.java:5134)
    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.main(RunJar.java:212)

这样需要把hive的runjar进程杀死

jps

kill -9 端口号

重新启动hive

2、报错：

ls: 无法访问/usr/local/spark/lib/spark-assembly-*.jar: 没有那个文件或目录

找到自己hive的安装路径，然后进去

cd /usr/local/hive/bin

vi hive

把sparkAssemblyPath=`ls ${SPARK_HOME}lib/spark-assembly-*.jar`

修改为

sparkAssemblyPath=`ls ${SPARK_HOME}/jars/*.jar`

3、报错

Error: Could not open client transport with JDBC Uri: jdbc:hive2://qianfeng01:10000: java.net.ConnectException: 拒绝连接 (Connection refused) (state=08S01,code=0)

原因没开启hiveserver2

hive  -service hiveserver2 &

再次打开hiveserver的客户端

4、注意重新搭建hive要把mysql中hive数据库删掉

drop database hive

然后再初始化数据库