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
