One Star

Accessing External tables in Hive

Hi All
I have a Hive Extract Job using tHiveRow and tParseRecordSet component.
Connection to a remote hive server is fine.
Using the connection, I can only access Hive MANAGED tables.
Is there a way to access EXTERNAL tables?
Can anyone help on this?
Regards
Manisha
3 REPLIES
One Star

Re: Accessing External tables in Hive

Hi Manisha
What do you mean External tables?
If the tables are not owned by hive, you have no rights to access them.
Or I misunderstood you?
Regards,
Pedro
One Star

Re: Accessing External tables in Hive

You are right, External tables data is not owned by hive. But it owns its metadata.
In our application, all tables are external.
Is there a workaround to access these tables? Or is anything planned for this functionality in coming releases.

hive is running on a remote server. I am extracting data from a MANAGED hive table that has 2800 rows.
Extract job fails on the last row. Also, it takes a long time to extract data.
I have the same table with same data on local hive also. While extracting from local hive, job does correct extract and that too very fast.
Is this a bug in tHiveRow?
Regards
Manisha
One Star

Re: Accessing External tables in Hive

Hi Manisha
It's a bug. Please report it on BugTracker.
Regards,
Pedro