Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Write Table now available in Qlik Cloud Analytics: Read Blog
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
Labels (2)
3 Replies
Anonymous
Not applicable
Author

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
Anonymous
Not applicable
Author

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
Anonymous
Not applicable
Author

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