topic Re: Accessing External tables in Hive in Talend Studio

Accessing External tables in Hive

Anonymous — Thu, 22 Mar 2012 14:12:59 GMT

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

Re: Accessing External tables in Hive

Anonymous — Fri, 23 Mar 2012 03:18:24 GMT

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

Re: Accessing External tables in Hive

Anonymous — Fri, 23 Mar 2012 10:04:02 GMT

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

Re: Accessing External tables in Hive

Anonymous — Mon, 26 Mar 2012 03:30:03 GMT

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