yes I do it is there
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. On 13 May 2017 at 05:07, Per Ullberg <per.ullb...@klarna.com> wrote: > 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.talebza...@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 > > Klarna AB (publ) > Sveavägen 46, 111 34 Stockholm > Tel: +46 8 120 120 00 > Reg no: 556737-0431 > klarna.com > >
