Return-Path: X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by cust-asf2.ponee.io (Postfix) with ESMTP id B46A0200C82 for ; Sat, 13 May 2017 06:07:21 +0200 (CEST) Received: by cust-asf.ponee.io (Postfix) id B2E5E160BC8; Sat, 13 May 2017 04:07:21 +0000 (UTC) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id ABE21160BB8 for ; Sat, 13 May 2017 06:07:20 +0200 (CEST) Received: (qmail 26832 invoked by uid 500); 13 May 2017 04:07:19 -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 26814 invoked by uid 99); 13 May 2017 04:07:19 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd1-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 13 May 2017 04:07:19 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd1-us-west.apache.org (ASF Mail Server at spamd1-us-west.apache.org) with ESMTP id A4EE8C87A6 for ; Sat, 13 May 2017 04:07:18 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd1-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 2.379 X-Spam-Level: ** X-Spam-Status: No, score=2.379 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, HTML_MESSAGE=2, RCVD_IN_DNSWL_NONE=-0.0001, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01, RCVD_IN_SORBS_SPAM=0.5, SPF_PASS=-0.001] autolearn=disabled Authentication-Results: spamd1-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=klarna.com Received: from mx1-lw-eu.apache.org ([10.40.0.8]) by localhost (spamd1-us-west.apache.org [10.40.0.7]) (amavisd-new, port 10024) with ESMTP id SG2lSIkH98Lw for ; Sat, 13 May 2017 04:07:16 +0000 (UTC) Received: from mail-qt0-f174.google.com (mail-qt0-f174.google.com [209.85.216.174]) by mx1-lw-eu.apache.org (ASF Mail Server at mx1-lw-eu.apache.org) with ESMTPS id 496395F202 for ; Sat, 13 May 2017 04:07:15 +0000 (UTC) Received: by mail-qt0-f174.google.com with SMTP id f55so13096816qta.3 for ; Fri, 12 May 2017 21:07:15 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=klarna.com; s=google; h=mime-version:references:in-reply-to:from:date:message-id:subject:to; bh=e8rUeoGvIyfkmj//gi0LuXRoCqDrKC3YTpA6NOVFzFU=; b=E+CwAp19KTlx0D3KVKkpiYwTdgjOYd2KMTXs6qjWJOIht87bPeg3g0SUbwNbfScSbD i+T7uHerEdWgrwrkhJo1gM0yuwazAFIFpr7sgikgVJ+Dyefjc47v7S5cHML7xBUdzHLq +yD4Y1v+mh1685WgQ6pWn57Y4T1aY1YHVM69l/00FUiGfxoPpWEIc0D/jzGMGI4ESkah kj0mlNQVCMtMWDtOCCvz10nVSYJNho09ATpI1mXaihemgwgiU+rVM2ae/PzVD2t7D0Gd i5cj5hVoNhqZuFqrOdmvt7Pin5FA076ySh9yhPliX+1ecTcJS5VWBpnfRn2+Mdr5HmMd ybAQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to; bh=e8rUeoGvIyfkmj//gi0LuXRoCqDrKC3YTpA6NOVFzFU=; b=luujSZPyzqcqWLUyBpGHVwQ6yiIwb6YDgqGP8lPVzeAT6Q1+3lhaQXU/HzthFcf/W7 cg11t2VvT7LfLKy8qCqJ/3BbbTHFLfbC921wdATUP2SIkcdj2Vs0JPFsrKlnBFR2Ewdi lUDKssWpy+KnK6l0v3Bf3OVPDBCcwUV16tlxiUUYYmUzgdh4P+DSi19EfVbewAWokHNp tUeH+sQeU9qisPHYM7EBh3Sfn3MNs5Dj938TJGaS2fJYXgb8oJbDGBU4+X5+R3CSKVNj CALMO7TL4o/eKpveevF+zvsu5kTa3QlMZLs19jDTaAutqmyK+gZOORprOk5RRgxJzFdN PFbg== X-Gm-Message-State: AODbwcCBg9T/0pONgNIB9Iq33vtWkCmrpVFw8DklfD2eSN9M6j5B5si/ 70b0WcMcDmxICyqBS8sdU+GWIOyiwzMYGOk= X-Received: by 10.200.35.230 with SMTP id r35mr6510583qtr.167.1494648434064; Fri, 12 May 2017 21:07:14 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Per Ullberg Date: Sat, 13 May 2017 04:07:03 +0000 Message-ID: Subject: Re: Unable to retrieve table metadata from hcatalog To: user@hive.apache.org Content-Type: multipart/alternative; boundary="001a11403b70fa24d3054f5ff4ad" archived-at: Sat, 13 May 2017 04:07:21 -0000 --001a11403b70fa24d3054f5ff4ad Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable And you're sure that you have a database and table in hive matching *oraclehadoop.bigtab*? /Pelle On Sat 13 May 2017 at 01:08 Mich Talebzadeh wrote: > I am using GoldenGate to send data real time from Oracle table to Hive. > > It tries to read table metadata using HCat but fails as below: > > *ERROR 2017-05-12 22:45:52,700 [main] Unable to retrieve table matadata. > Table : oraclehadoop.bigtab* > > *org.apache.hive.hcatalog.common.HCatException : 9001 : Exception occurre= d > while processing HCat request : NoSuchObjectException while fetching > table.. Cause : NoSuchObjectException(message:oraclehadoop.bigtab table n= ot > found) **at > org.apache.hive.hcatalog.api.HCatClientHMSImpl.getTable(HCatClientHMSImpl= .java:175)* > > at > oracle.goldengate.mdp.hive.HiveMetaDataProvider.resolve(HiveMetaDataProvi= der.java:91) > > at > oracle.goldengate.datasource.metadata.provider.TargetMetaDataStore.retrie= veMetaData(TargetMetaDataStore.java:73) > > at > oracle.goldengate.datasource.UserExitDataSource.getMetaData(UserExitDataS= ource.java:2133) > > Caused by: NoSuchObjectException(message:oraclehadoop.bigtab table not > found) > > at > org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.get_table_core(= HiveMetaStore.java:1885) > > at > org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.get_table(HiveM= etaStore.java:1838) > > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java= :62) > > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorI= mpl.java:43) > > at java.lang.reflect.Method.invoke(Method.java:497) > > at > org.apache.hadoop.hive.metastore.RetryingHMSHandler.invokeInternal(Retryi= ngHMSHandler.java:138) > > at > org.apache.hadoop.hive.metastore.RetryingHMSHandler.invoke(RetryingHMSHan= dler.java:99) > > at com.sun.proxy.$Proxy13.get_table(Unknown Source) > > at > org.apache.hadoop.hive.metastore.HiveMetaStoreClient.getTable(HiveMetaSto= reClient.java:1228) > > at > org.apache.hive.hcatalog.api.HCatClientHMSImpl.getTable(HCatClientHMSImpl= .java:168) > > > > I am not that familiar with HCat. Any help will be appreciated. > > > thanks > > Dr Mich Talebzadeh > > > > LinkedIn * https://www.linkedin.com/profile/view?id=3DAAEAAAAWh2gBxianrbJ= d6zP6AcPCCdOABUrV8Pw > * > > > > http://talebzadehmich.wordpress.com > > > *Disclaimer:* Use it at your own risk. Any and all responsibility for any > loss, damage or destruction of data or any other property which may arise > from relying on this email's technical content is explicitly disclaimed. > The author will in no case be liable for any monetary damages arising fro= m > such loss, damage or destruction. > > > --=20 *Per Ullberg* Data Vault Tech Lead Odin Uppsala +46 701612693 Klarna AB (publ) Sveav=C3=A4gen 46, 111 34 Stockholm Tel: +46 8 120 120 00 Reg no: 556737-0431 klarna.com --001a11403b70fa24d3054f5ff4ad Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
And you're sure that you have a database and table in hive matchin= g=C2=A0oraclehadoop.bigtab?

/Pelle=C2=A0

On Sat 13 May 2017 at 01:08 Mich= Talebzadeh <mich.talebzade= h@gmail.com> wrote:
I am using GoldenGate to send data real time from Oracle table to Hive.

It tries to read table metadata using HCat but fail= s as below:

ERROR 2017-05-12 22:45:52,7= 00 [main] Unable to retrieve table matadata. Table : oraclehadoop.bigtab

org.apache.hive.hcatalog.common.HCatException : 9001 := Exception occurred while processing HCat request : NoSuchObjectException w= hile fetching table.. Cause : NoSuchObjectException(message:oraclehadoop.bi= gtab table not found) at org.apache.hive.hcatalog.api.HCat= ClientHMSImpl.getTable(HCatClientHMSImpl.java:175)

=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 at oracle.goldengate.mdp.hive.HiveMetaDat= aProvider.resolve(HiveMetaDataProvider.java:91)

=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0 at oracle.goldengate.datasource.metadata.provider.Tar= getMetaDataStore.retrieveMetaData(TargetMetaDataStore.java:73)

=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 at oracle.goldengate.datasource.UserEx= itDataSource.getMetaData(UserExitDataSource.java:2133)

Caused by: NoS= uchObjectException(message:oraclehadoop.bigtab table not found)

=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 at org.apache.hadoop.hive.metastore= .HiveMetaStore$HMSHandler.get_table_core(HiveMetaStore.java:1885)

=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 at org.apache.hadoop.hive.metastore= .HiveMetaStore$HMSHandler.get_table(HiveMetaStore.java:1838)

=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 at sun.reflect.NativeMethodAccessorImp= l.invoke0(Native Method)

=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 a= t sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java= :62)

=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 at sun.reflect.Delega= tingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 at java.lang.reflect.Method.invo= ke(Method.java:497)

=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 at org= .apache.hadoop.hive.metastore.RetryingHMSHandler.invokeInternal(RetryingHMS= Handler.java:138)

=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 at org.a= pache.hadoop.hive.metastore.RetryingHMSHandler.invoke(RetryingHMSHandler.ja= va:99)

=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 at com.sun.proxy.$P= roxy13.get_table(Unknown Source)

=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0 at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.getTable(Hiv= eMetaStoreClient.java:1228)

=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0 at org.apache.hive.hcatalog.api.HCatClientHMSImpl.getTable(HCatClientHM= SImpl.java:168)

=C2=A0

I a= m not that familiar with HCat. Any help will be appreciated.


thanks


Dr Mich Talebzadeh

=C2=A0

LinkedIn =C2=A0https://www.linkedin.com/profile/view?id=3DAAEA= AAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw

=C2=A0

http:= //talebzadehmich.wordpress.com


Disclaimer:=C2=A0Use = it=C2=A0at your own risk. Any and all responsibilit= y for any loss, damage or destruction of data or any other property which may arise from relying on this email= 9;s=C2=A0technical=C2=A0content is explicitly disclaimed. The author will in no case be liable for any monetary damages arising from = such loss, damage or destruction.

=C2=A0

<= font color=3D"#000000" face=3D"Times New Roman" size=3D"3">
--

Per Ullb= erg
Data Vault Tech Lead
Odin Uppsala
+46 701612693

Klarna AB=C2=A0(publ)
Sv= eav=C3=A4gen 46, 111 34 Stockholm
Tel:=C2=A0+46 8 120 120 00
Reg no: 556737-0431
klarna.com

--001a11403b70fa24d3054f5ff4ad--