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:mar...@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.
