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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Permissions controls on Hive tables created with Talend

Here is my scenario (using Enterprise 6.1.x)
We have two Hadoop clusters.  One is configured to use Kerberos, the other is not.  (I have not yet been able to test with the Kerberos system).
In using the non-Kerberos authenticated environment I am finding that Hive tables created via Talend are owned by the environment's defined   javax.jdo.option.ConnectionUserName user.  
Allowing these tables to be read by other users would require a permissions change by this user, which we are not allowed direct access to.
I have not found a way to override this setting or to perform an action from Talend to open the table permissions. 
Does anyone have any suggested solutions?
Labels (3)
1 Reply
Anonymous
Not applicable
Author

Hi,
Easier way would be to grant permissions directly on the HDFS directory where the hive DB and tables are stored.
The below URL might help - 
https://cwiki.apache.org/confluence/display/Hive/SQL+Standard+Based+Hive+Authorization

Regards,
~rp