hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mich Talebzadeh" <m...@peridale.co.uk>
Subject RE: 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 09:17:59 GMT
No mine is on Oracle database on Oracle 11g and says the same. Notice the bold line do you
have that?

 

hive --service metatool -listFSRoot

Initializing HiveMetaTool..

2016-02-10 09:24:44,784 INFO  [main] metastore.ObjectStore: ObjectStore, initialize called

2016-02-10 09:24:44,963 INFO  [main] DataNucleus.Persistence: Property datanucleus.cache.level2
unknown - will be ignored

2016-02-10 09:24:44,964 INFO  [main] DataNucleus.Persistence: Property hive.metastore.integral.jdo.pushdown
unknown - will be ignored

2016-02-10 09:24:45,877 INFO  [main] metastore.ObjectStore: Setting MetaStore object pin classes
with hive.metastore.cache.pinobjtypes="Table,StorageDescriptor,SerDeInfo,Partition,Database,Type,FieldSchema,Order"

2016-02-10 09:24:49,608 INFO  [main] DataNucleus.Datastore: The class "org.apache.hadoop.hive.metastore.model.MFieldSchema"
is tagged as "embedded-only" so does not have its own datastore table.

2016-02-10 09:24:49,609 INFO  [main] DataNucleus.Datastore: The class "org.apache.hadoop.hive.metastore.model.MOrder"
is tagged as "embedded-only" so does not have its own datastore table.

2016-02-10 09:24:51,958 INFO  [main] DataNucleus.Datastore: The class "org.apache.hadoop.hive.metastore.model.MFieldSchema"
is tagged as "embedded-only" so does not have its own datastore table.

2016-02-10 09:24:51,958 INFO  [main] DataNucleus.Datastore: The class "org.apache.hadoop.hive.metastore.model.MOrder"
is tagged as "embedded-only" so does not have its own datastore table.

2016-02-10 09:24:54,182 INFO  [main] DataNucleus.Query: Reading in results for query "org.datanucleus.store.rdbms.query.SQLQuery@0"
since the connection used is closing

2016-02-10 09:24:54,183 INFO  [main] metastore.MetaStoreDirectSql: Using direct SQL, underlying
DB is ORACLE

2016-02-10 09:24:54,185 INFO  [main] metastore.ObjectStore: Initialized ObjectStore

Listing FS Roots..

hdfs://rhes564:9000/user/hive/warehouse

hdfs://rhes564:9000/user/hive/warehouse/oraclehadoop.db

hdfs://rhes564:9000/user/hive/warehouse/asehadoop.db

hdfs://rhes564:9000/user/hive/warehouse/test.db

hdfs://rhes564:9000/user/hive/warehouse/iqhadoop.db

 

Dr Mich Talebzadeh

 

LinkedIn  https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw

 

http://talebzadehmich.wordpress.com

 

NOTE: The information in this email is proprietary and confidential. This message is for the
designated recipient only, if you are not the intended recipient, you should destroy it immediately.
Any information in this message shall not be understood as given or endorsed by Peridale Technology
Ltd, its subsidiaries or their employees, unless expressly so stated. It is the responsibility
of the recipient to ensure that this email is virus free, therefore neither Peridale Technology
Ltd, its subsidiaries nor their employees accept any responsibility.

 

 

 

-----Original Message-----
From: Margus Roo [mailto:margus@roo.ee] 
Sent: 10 February 2016 09:05
To: user@hive.apache.org
Subject: Re: hive --service metatool -listFSRoot Unable to open a test connection to the given
database. JDBC url = jdbc:mysql://hostnamehive?createDatabaseIfNotExist=true, username = hive

 

Does thous lines meaning that I have embedded metastore?

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.

 

 

Margus (margusja) Roo

 <http://margus.roo.ee> http://margus.roo.ee

skype: margusja

+372 51 48 780

 

On 10/02/16 10:53, Margus Roo wrote:

> 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. 


Mime
View raw message