RE: hive server security/authentication

2012-09-27 Thread Manish . Bhoge
Hi, We have been using data from Hive on Tableau. You need to have JDBC connection. I don't remember the exaction menu in Tableau. But having your metadata in MySQL and having JDBC connection on top of MySQL will allow you to access the data from Hive. If you have CDH3 then make sure you don't

RE: hive server security/authentication

2012-09-26 Thread ashok.samal
Hi Chalcy, You can go for OAUTH for security purpose if you want to provide specific authorization flows for web applications with hive. Even Google relay on this. But coming to pentaho and all never tried with them. You can give a try. Regards Ashok S. From: Chalcy Raja [mailto:chalcy.r...@ca

Re: hive server security/authentication

2012-09-26 Thread विनोद सिंह
Hive is poor on user authentication and authorization. But all map reduce jobs launched by Hive follow the Hadoop file permissions while reading and writing data. So best way to enforce security using Hive is to secure your data in HDFS using appropriate permissions. Thanks, Vinod http://blog.vin