[HIVE-16057] SchemaTool ignores --passWord argument if hadoop.security.credential.provider.path is configured

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.2.0
• Fix Version/s: 3.0.0
• Assignee: Peter Vary
• Reporter: Peter Vary
• Created: 28/Feb/17 14:03
• Updated: 22/May/18 23:59
• Resolved: 30/Mar/17 18:17

Description

It the hadoop.security.credential.provider.path is defined in command line, but the correct HADOOP_CREDSTORE_PASSWORD is not provided the SchemaTool fails, even if the correct metastore password is provided with --passWord

Could be reproduced if the hive-site.xml contains the following:

  <property>
    <name>hadoop.security.credential.provider.path</name>
    <value>localjceks://file//Users/petervary/tmp/conf/creds.localjceks</value>
  </property>

$ ../schemaTool --dbType=mysql --info --passWord=pwd
Metastore connection URL:	 jdbc:mysql://localhost:3306/hive?useUnicode=true&characterEncoding=UTF-8
Metastore Connection Driver :	 com.mysql.jdbc.Driver
Metastore connection User:	 hive
org.apache.hadoop.hive.metastore.HiveMetaException: Failed to get schema version.
*** schemaTool failed ***

The --passWord argument should override the errors from the credential provider