Re: Unable to retrieve table metadata from hcatalog

2017-05-13 Thread Mich Talebzadeh 
yes I do it is there


Thanks

Dr Mich Talebzadeh



LinkedIn * 
https://www.linkedin.com/profile/view?id=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw
*



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  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 
> 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=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw
>> *
>>
>>
>>
>> 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
>
>

Re: Unable to retrieve table metadata from hcatalog

2017-05-12 Thread Per Ullberg 
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 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=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw
> *
>
>
>
> 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

Unable to retrieve table metadata from hcatalog

2017-05-12 Thread Mich Talebzadeh 
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=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw
*



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.