I had asked a similar question earlier - http://mail-archives.apache.org/mod_mbox/hive-user/201110.mbox/%3ccab13a97.2c54%[email protected]%3E.
But I didn't get any responses. This may be a limitation of Hive JDBC. I would also be curious to know if there is a solution to this. Thanks, Sriram From: Gabriel Eisbruch <[email protected]<mailto:[email protected]>> Reply-To: "[email protected]<mailto:[email protected]>" <[email protected]<mailto:[email protected]>> Date: Thu, 27 Oct 2011 05:09:15 -0700 To: "[email protected]<mailto:[email protected]>" <[email protected]<mailto:[email protected]>> Subject: Re: Problem With HDFS USERS using JDBC Really My problem it's a little different, we have created all users that we need, but we can't set this users using jdbc, our system user it's different that we need to use to connect to hive, so when we try to do a LOAD action we saw that hive server try to use the user HIVE instead of the user that we try to use Thanks, Gabriel 2011/10/27 Alexander C.H. Lorenz <[email protected]<mailto:[email protected]>> Depends on your configuration (security in core-site.xml; hadoop.security.authorization). HDFS uses pam-auth, which means the user has to exist. Maybe "su - USERNAME". Or you put the data into hdfs and change the rights as the supergroup-member: hadoop dfs -chown -R USERNAME /path/in/hdfs Did you mean something like that? regards, Alex On Thu, Oct 27, 2011 at 4:23 AM, Steven Wong <[email protected]<mailto:[email protected]>> wrote: It is unclear to me if Hive JDBC and Hive Server support changing the user to a user not used by the Hive Server. Can someone familiar with Hive authentication please comment? From: Gabriel Eisbruch [mailto:[email protected]<mailto:[email protected]>] Sent: Tuesday, October 25, 2011 12:07 PM To: [email protected]<mailto:[email protected]> Subject: Problem With HDFS USERS using JDBC Hello, any body could tell me how can I do to set the hdfs user and group in a LOAD sentence from the JDBC driver? I have tried with many diferents way but ever that I tried the user used by the hive server was HIVE. Thanks Gabriel. -- Alexander Lorenz http://mapredit.blogspot.com
