hive local metastore

Error Scenario: Unable to open a test connection to the given database  or Access denied for user ‘APP’@’localhost’ (using password: YES) This error message (Access denied for user ‘APP’@’localhost’) will be received while trying to connect hive service through MySQL local metastore. [crayon-5c998a57c0b74202710211/] Root Cause: When we don’t provide username (javax.jdo.option.ConnectionUserName) […]

Access denied for user ‘APP’@’localhost’ (using password: YES)

metastore port 4
Hive Metastore: In Hive, metastore is the central repository to store metadata for hive tables/partitions. Any datastore that has a JDBC driver can be used as a metastore. By default, the metastore service runs in the same JVM as the Hive service and contains an embedded Derby database instance backed by the local […]

Hive Metastore Configuration