Return-Path: X-Original-To: apmail-hive-user-archive@www.apache.org Delivered-To: apmail-hive-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 083E1180AB for ; Wed, 10 Feb 2016 09:17:30 +0000 (UTC) Received: (qmail 50242 invoked by uid 500); 10 Feb 2016 09:17:28 -0000 Delivered-To: apmail-hive-user-archive@hive.apache.org Received: (qmail 50170 invoked by uid 500); 10 Feb 2016 09:17:28 -0000 Mailing-List: contact user-help@hive.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@hive.apache.org Delivered-To: mailing list user@hive.apache.org Received: (qmail 50155 invoked by uid 99); 10 Feb 2016 09:17:28 -0000 Received: from Unknown (HELO spamd2-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 10 Feb 2016 09:17:28 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd2-us-west.apache.org (ASF Mail Server at spamd2-us-west.apache.org) with ESMTP id F12241A00E6 for ; Wed, 10 Feb 2016 09:17:27 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd2-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 3.11 X-Spam-Level: *** X-Spam-Status: No, score=3.11 tagged_above=-999 required=6.31 tests=[HTML_MESSAGE=2, KAM_COUK=1.1, RCVD_IN_DNSWL_NONE=-0.0001, T_KAM_HTML_FONT_INVALID=0.01] autolearn=disabled Received: from mx1-us-east.apache.org ([10.40.0.8]) by localhost (spamd2-us-west.apache.org [10.40.0.9]) (amavisd-new, port 10024) with ESMTP id QpB0f6lMiefY for ; Wed, 10 Feb 2016 09:17:25 +0000 (UTC) Received: from sulu.netzoomi.net (sulu.netzoomi.net [83.138.144.103]) by mx1-us-east.apache.org (ASF Mail Server at mx1-us-east.apache.org) with ESMTP id F09BB42A02 for ; Wed, 10 Feb 2016 09:17:24 +0000 (UTC) Received: from vulcan.netzoomi.net (unknown [212.100.249.54]) by sulu.netzoomi.net (Postfix) with ESMTP id 90D766A4CE1 for ; Wed, 10 Feb 2016 09:17:17 +0000 (GMT) X-Envelope-From: Received: from w7 (cpc86449-seve24-2-0-cust177.13-3.cable.virginm.net [86.19.59.178]) by vulcan.netzoomi.net (Postfix) with ESMTPA id 741D212482EC for ; Wed, 10 Feb 2016 09:17:17 +0000 (GMT) From: "Mich Talebzadeh" To: References: <56BAFA73.5060404@roo.ee> <56BAFD44.8030907@roo.ee> In-Reply-To: <56BAFD44.8030907@roo.ee> 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 -0000 Message-ID: <09ee01d163e3$efb7a110$cf26e330$@peridale.co.uk> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_09EF_01D163E3.EFB927B0" X-Mailer: Microsoft Outlook 16.0 Thread-Index: AQGNXPF3cu+2S0MthFMP/P8T8PsZggMP8E3Cn5SNyCA= Content-Language: en-gb This is a multipart message in MIME format. ------=_NextPart_000_09EF_01D163E3.EFB927B0 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable No mine is on Oracle database on Oracle 11g and says the same. Notice = the bold line do you have that? =20 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=3D"Table,StorageDescriptor,SerDeInfo,Par= tition,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 =20 Dr Mich Talebzadeh =20 LinkedIn = https://www.linkedin.com/profile/view?id=3DAAEAAAAWh2gBxianrbJd6zP6AcPCCd= OABUrV8Pw =20 http://talebzadehmich.wordpress.com =20 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. =20 =20 =20 -----Original Message----- From: Margus Roo [mailto:margus@roo.ee]=20 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 =3D = jdbc:mysql://hostnamehive?createDatabaseIfNotExist=3Dtrue, username =3D = hive =20 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. =20 =20 Margus (margusja) Roo http://margus.roo.ee skype: margusja +372 51 48 780 =20 On 10/02/16 10:53, Margus Roo wrote: > 16/02/10 03:34:23 INFO DataNucleus.Datastore: The class=20 > "org.apache.hadoop.hive.metastore.model.MFieldSchema" is tagged as=20 > "embedded-only" so does not have its own datastore table. > 16/02/10 03:34:23 INFO DataNucleus.Datastore: The class=20 > "org.apache.hadoop.hive.metastore.model.MOrder" is tagged as=20 > "embedded-only" so does not have its own datastore table. > 16/02/10 03:34:23 INFO DataNucleus.Datastore: The class=20 > "org.apache.hadoop.hive.metastore.model.MFieldSchema" is tagged as=20 > "embedded-only" so does not have its own datastore table. > 16/02/10 03:34:23 INFO DataNucleus.Datastore: The class=20 > "org.apache.hadoop.hive.metastore.model.MOrder" is tagged as=20 > "embedded-only" so does not have its own datastore table.=20 ------=_NextPart_000_09EF_01D163E3.EFB927B0 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable

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=C2=A0 [main] metastore.ObjectStore: ObjectStore, initialize = called

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

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

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

2016-02-10 09:24:49,608 INFO=C2=A0 [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=C2=A0 [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=C2=A0 [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=C2=A0 [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=C2=A0 [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=C2=A0 [main] = metastore.MetaStoreDirectSql: Using direct SQL, underlying DB is ORACLE

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

Listing FS = Roots..

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

hdfs://rhes564:9000/user/hive/warehouse/oraclehadoop.db<= o:p>

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=3DAAEAAAAWh2gBxianrbJd6zP6= AcPCCdOABUrV8Pw

 

http://talebzadehmich.wordpress.com<= o:p>

 

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 =3D = jdbc:mysql://hostnamehive?createDatabaseIfNotExist=3Dtrue, username =3D = 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

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

------=_NextPart_000_09EF_01D163E3.EFB927B0--