Hi,
I want to pass different configuration variables for different users in
hive. I have tested this by putting hive-site.xmls in user's home directory
and for that user it grabs the hive-site.xml from his home directory and
executes hive accordingly.
This works for CLI but it doesn't from JDBC/ODBC tools.
For example : Tom has access to certain s3 buckets/data compared to john.
So i put hive-site.xml in his home directory(
/home/tom/hive-site.xml) with necessary access to tom but john will not
have that access keys inside his hive-site.xml in his home directory.
It would look like /home/tom/hive-site.xml
<property><name>fs.s3.awsAccessKeyId</name><value>xxxxxx</value></property>
<property><name>fs.s3.awsSecretAccessKey</name><value>xxxxxxxxx</value></property>
<property><name>hive.metastore.uris</name><value>thrift:<ipaddress:9083></value>
Whereas /home/john/hive-site.xml looks like without any
keys
<property><name>hive.metastore.uris</name><value>thrift:<ipaddress:9083></value>
So this worked from CLI , when tom login he is having
access to necessary data but not john. When tom logged in using JDBC/ODBC
tools using ldap authentication he is not able to access the data since it
is not able to read hive-site.xml.Is there anyway that hive-site.xml can be
invoked when connection is made to hiveserver2 so that it works similar to
CLI.
I know we can use 'set command' after connection is made
to pass the variables for that user.
Need some advise on this. Let me know if you have any questions. Thanks in
Advance.
Thanks,
SAI
