hive server2 连接mysql认证配置

create table hiveserver2_auth (username varchar(30),password varchar(48), primary key(username));

<property>
  <name>hive.server2.custom.auth.db.driver</name>
  <value>com.mysql.jdbc.Driver</value>
</property>

<property>
  <name>hive.server2.custom.auth.db.url</name>
  <value>jdbc:mysql://127.0.0.1:3306/test?characterEncoding=utf8</value>
</property>

<property>
  <name>hive.server2.custom.auth.db.username</name>
  <value>hello123</value>
</property>

<property>
  <name>hive.server2.custom.auth.db.password</name>
  <value>hello123</value>

</property>

jar 包放置  /usr/hdp/current/hive-server2/lib/hive-app-1.0.0-SNAPSHOT.jar
udf 包

/usr/hdp/current/hive-client/lib/gx-axe-lib-hive-api.jar