java 调 hivesever2问题记录

1 拒绝访问：

《1》 Connection reset

     服务没启动，查看端口10000是否监听

     netstat -nltp|grep 10000

     如果未监听，执行 hive/bin/hiveserver2 & 启动服务

《2》 Could not open client transport with JDBC Uri

     验证方式有问题，可考虑使用无验证方式

     修改hive-site.xml

  <property>

    <name>hive.server2.authentication</name>

    <value>NONE</value>

    <description>

      Expects one of [nosasl, none, ldap, kerberos, pam, custom].

      Client authentication types.

        NONE: no authentication check

        LDAP: LDAP/AD based authentication

        KERBEROS: Kerberos/GSSAPI authentication

        CUSTOM: Custom authentication provider

                (Use with property hive.server2.custom.authentication.class)

        PAM: Pluggable authentication module

        NOSASL:  Raw transport

    </description>

  </property>

重启服务hiveserver2

2   User: hadoop is not allowed to impersonate anonymous (state=,code=0)

需要修改集群每一台机器的 hadoop/etc/hadoop/core-site.xml   是每一台机器！！！

增加：

    <property>

        <name>hadoop.proxyuser.hadoop.groups</name>

        <value>*</value>

        <description>Allow the superuser oozie to impersonate any members of the group group1 and group2</description>

    </property>

    <property>

        <name>hadoop.proxyuser.hadoop.hosts</name>

        <value>*</value>

        <description>The superuser can connect only from host1 and host2 to impersonate a user</description>

    </property>

重启hdfs 

hbase/bin/stop-hbase.sh (如果有hbase)

hadoop/sbin/stop-dfs.sh

hadoop/sbin/start-dfs.sh

hbase/bin/start-hbase.sh(如果有hbase)

重启hive/bin/hiveserver2 &