Re: read-only mode for hive

2016-03-09 Thread Mich Talebzadeh
If this is all about a maintenance window, then why not shutdown Hive server2 which stops client access including beeline and use Hive CLI to do the maintenance work effectively in single user mode. Snapshot is another option. HTH Dr Mich Talebzadeh LinkedIn * https://www.linkedin.com/profil

Re: read-only mode for hive

2016-03-09 Thread Andrew Sears
Another option might be to lock using a zookeeper script. Andrew Sent using CloudMagic Email [https://cloudmagic.com/k/d/mailapp?ct=pa&cv=7.4.10&pv=5.1.1&source=email_footer_2] On Wed, Mar 09, 2016 at 7:05 PM, Andrew Sears < andrew.se...@analyticsdream.com [andrew.se...@analyticsdream.com] >

Re: read-only mode for hive

2016-03-09 Thread Andrew Sears
What about renaming the table? To another schema with limited rights? Not sure why just flipping access grant to select only wouldn't also work, provided auth is enabled and not external. An hdfs snapshot could also give you point -in-time copy. Set acls to restrict access if enabled. Cheers, An

Re: read-only mode for hive

2016-03-09 Thread PG User
Thank you all for replies. My usecase is as follows: I want to put a table (or database) in read-only mode. Then do some operations such as taking table definition and hdfs snapshot. I want to put table in read only mode to maintain consistency. After all my operations are done, I will again put h

Re: read-only mode for hive

2016-03-09 Thread David Capwell
Could always set the tables output format to be the null output format On Mar 8, 2016 11:01 PM, "Jörn Franke" wrote: > What is the use case? You can try security solutions such as Ranger or > Sentry. > > As already mentioned another alternative could be a view. > > > On 08 Mar 2016, at 21:09, PG

Re: read-only mode for hive

2016-03-08 Thread Jörn Franke
What is the use case? You can try security solutions such as Ranger or Sentry. As already mentioned another alternative could be a view. > On 08 Mar 2016, at 21:09, PG User wrote: > > Hi All, > I have one question about putting hive in read-only mode. > > What are the ways of putting hive in r

Re: read-only mode for hive

2016-03-08 Thread Sabarish Sasidharan
Does views solve your purpose? Regards Sab On 09-Mar-2016 6:23 am, "PG User" wrote: > Yes, putting any database or any table to read-only mode will serve my > purpose. > > On Tue, Mar 8, 2016 at 3:15 PM, Mich Talebzadeh > wrote: > >> Hive much like MSSQL or SAP ASE has multiple databases. Are y

Re: read-only mode for hive

2016-03-08 Thread PG User
Yes, putting any database or any table to read-only mode will serve my purpose. On Tue, Mar 8, 2016 at 3:15 PM, Mich Talebzadeh wrote: > Hive much like MSSQL or SAP ASE has multiple databases. Are you implying > to put one of these databases in READ ONLY mode? > > Dr Mich Talebzadeh > > > > Link

Re: read-only mode for hive

2016-03-08 Thread Mich Talebzadeh
Hive much like MSSQL or SAP ASE has multiple databases. Are you implying to put one of these databases in READ ONLY mode? Dr Mich Talebzadeh LinkedIn * https://www.linkedin.com/profile/view?id=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw