hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Margus Roo <mar...@roo.ee>
Subject hive --service metatool -listFSRoot Unable to open a test connection to the given database. JDBC url = jdbc:mysql://hostnamehive?createDatabaseIfNotExist=true, username = hive
Date Wed, 10 Feb 2016 08:53:07 GMT
Hi

I have two servers where are same hive configuration bigdata29 and bigdata2.
 From bigdata29 I can connect successfully with metadata:

[hive@bigdata29 ~]$ hive --service metatool -listFSRoot
WARNING: Use "yarn jar" to launch YARN applications.
Initializing HiveMetaTool..
16/02/10 03:34:21 INFO metastore.ObjectStore: ObjectStore, initialize called
16/02/10 03:34:21 INFO DataNucleus.Persistence: Property 
hive.metastore.integral.jdo.pushdown unknown - will be ignored
16/02/10 03:34:21 INFO DataNucleus.Persistence: Property 
datanucleus.cache.level2 unknown - will be ignored
16/02/10 03:34:22 INFO metastore.ObjectStore: Setting MetaStore object 
pin classes with 
hive.metastore.cache.pinobjtypes="Table,Database,Type,FieldSchema,Order"
16/02/10 03:34:23 INFO DataNucleus.Datastore: The class 
"org.apache.hadoop.hive.metastore.model.MFieldSchema" is tagged as 
"embedded-only" so does not have its own datastore table.
16/02/10 03:34:23 INFO DataNucleus.Datastore: The class 
"org.apache.hadoop.hive.metastore.model.MOrder" is tagged as 
"embedded-only" so does not have its own datastore table.
16/02/10 03:34:23 INFO DataNucleus.Datastore: The class 
"org.apache.hadoop.hive.metastore.model.MFieldSchema" is tagged as 
"embedded-only" so does not have its own datastore table.
16/02/10 03:34:23 INFO DataNucleus.Datastore: The class 
"org.apache.hadoop.hive.metastore.model.MOrder" is tagged as 
"embedded-only" so does not have its own datastore table.
16/02/10 03:34:23 INFO DataNucleus.Query: Reading in results for query 
"org.datanucleus.store.rdbms.query.SQLQuery@0" since the connection used 
is closing
16/02/10 03:34:23 INFO metastore.MetaStoreDirectSql: Using direct SQL, 
underlying DB is MYSQL
16/02/10 03:34:23 INFO metastore.ObjectStore: Initialized ObjectStore
Listing FS Roots..
hdfs://mycluster/apps/hive/warehouse


 From bigdata2:
[hive@bigdata2 ~]$ hive --service metatool -listFSRoot
WARNING: Use "yarn jar" to launch YARN applications.
Initializing HiveMetaTool..
16/02/10 03:45:04 INFO metastore.ObjectStore: ObjectStore, initialize called
16/02/10 03:45:05 INFO DataNucleus.Persistence: Property 
hive.metastore.integral.jdo.pushdown unknown - will be ignored
16/02/10 03:45:05 INFO DataNucleus.Persistence: Property 
datanucleus.cache.level2 unknown - will be ignored
16/02/10 03:45:06 ERROR Datastore.Schema: Failed initialising database.
Unable to open a test connection to the given database. JDBC url = 
jdbc:mysql://bigdata29/hive?createDatabaseIfNotExist=true, username = 
hive. Terminating connection pool (set lazyInit to true if you expect to 
start your database after your app). Original Exception: ------
java.sql.SQLException: Access denied for user 'hive'@'bigdata2' (using 
password: YES)

but I can access using mysql client:
[hive@bigdata2 ~]$ mysql -h bigdata29 -P 3306 -u hive -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 6018367
Server version: 5.6.28-log MySQL Community Server (GPL)

Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input 
statement.


Any hints where do dig ?

Br, Margus




-- 
Margus (margusja) Roo
http://margus.roo.ee
skype: margusja
+372 51 48 780


Mime
View raw message