hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Per Ullberg <per.ullb...@klarna.com>
Subject Re: Unable to retrieve table metadata from hcatalog
Date Sat, 13 May 2017 04:07:03 GMT
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 <mich.talebzadeh@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 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 occurred
> while processing HCat request : NoSuchObjectException while fetching
> table.. Cause : NoSuchObjectException(message:oraclehadoop.bigtab table not
> found) **at
> org.apache.hive.hcatalog.api.HCatClientHMSImpl.getTable(HCatClientHMSImpl.java:175)*
>
>         at
> oracle.goldengate.mdp.hive.HiveMetaDataProvider.resolve(HiveMetaDataProvider.java:91)
>
>         at
> oracle.goldengate.datasource.metadata.provider.TargetMetaDataStore.retrieveMetaData(TargetMetaDataStore.java:73)
>
>         at
> oracle.goldengate.datasource.UserExitDataSource.getMetaData(UserExitDataSource.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(HiveMetaStore.java:1838)
>
>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>
>         at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
>
>         at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>
>         at java.lang.reflect.Method.invoke(Method.java:497)
>
>         at
> org.apache.hadoop.hive.metastore.RetryingHMSHandler.invokeInternal(RetryingHMSHandler.java:138)
>
>         at
> org.apache.hadoop.hive.metastore.RetryingHMSHandler.invoke(RetryingHMSHandler.java:99)
>
>         at com.sun.proxy.$Proxy13.get_table(Unknown Source)
>
>         at
> org.apache.hadoop.hive.metastore.HiveMetaStoreClient.getTable(HiveMetaStoreClient.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=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw
> <https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>*
>
>
>
> 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 from
> such loss, damage or destruction.
>
>
>
-- 

*Per Ullberg*
Data Vault Tech Lead
Odin Uppsala
+46 701612693 <javascript:void(0);>

Klarna AB (publ)
Sveavägen 46, 111 34 Stockholm
Tel: +46 8 120 120 00 <javascript:void(0);>
Reg no: 556737-0431
klarna.com

Mime
View raw message