Return-Path: X-Original-To: apmail-hive-user-archive@www.apache.org Delivered-To: apmail-hive-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id A5D9619228 for ; Wed, 9 Mar 2016 06:46:52 +0000 (UTC) Received: (qmail 10718 invoked by uid 500); 9 Mar 2016 06:46:51 -0000 Delivered-To: apmail-hive-user-archive@hive.apache.org Received: (qmail 10653 invoked by uid 500); 9 Mar 2016 06:46:51 -0000 Mailing-List: contact user-help@hive.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@hive.apache.org Delivered-To: mailing list user@hive.apache.org Received: (qmail 10642 invoked by uid 99); 9 Mar 2016 06:46:51 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd3-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 09 Mar 2016 06:46:51 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd3-us-west.apache.org (ASF Mail Server at spamd3-us-west.apache.org) with ESMTP id 9947A180114 for ; Wed, 9 Mar 2016 06:46:50 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd3-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 2.179 X-Spam-Level: ** X-Spam-Status: No, score=2.179 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, FREEMAIL_REPLY=1, HTML_MESSAGE=2, RCVD_IN_DNSWL_LOW=-0.7, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01, SPF_PASS=-0.001] autolearn=disabled Authentication-Results: spamd3-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=gmail.com Received: from mx1-lw-us.apache.org ([10.40.0.8]) by localhost (spamd3-us-west.apache.org [10.40.0.10]) (amavisd-new, port 10024) with ESMTP id nB9OSBVB3aHJ for ; Wed, 9 Mar 2016 06:46:48 +0000 (UTC) Received: from mail-ob0-f169.google.com (mail-ob0-f169.google.com [209.85.214.169]) by mx1-lw-us.apache.org (ASF Mail Server at mx1-lw-us.apache.org) with ESMTPS id 7CC795FB2B for ; Wed, 9 Mar 2016 06:46:48 +0000 (UTC) Received: by mail-ob0-f169.google.com with SMTP id ts10so37863602obc.1 for ; Tue, 08 Mar 2016 22:46:48 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:date:message-id:subject:from:to; bh=fraOGpuuFkId5c/R321DqkPtti8JYuwOeUQR2CBWCFM=; b=bU0t8vPsx2xrnvD0bPeyAV4Enl7fIxDr7WhWj64xAD4KtXU/Fyg5JSevC5PynFKd1b E+OoUPXr5PM6P6NtnmzV7NtH+LFYW2cxCjOrc/jdlPucE1SwbWZewxqrEaealm5pkznw n6QS5Jo4a6+rftTfuAPDxZ1XZC6Cpot1bXwEiuwCuTQHjvrmEBOcdpMH034qh48PGTps 94Ke75GIftz/2fRDzzjVWmqig5DHDMcd3aDvTnUPhqtbtAMKCGJE4EFR99oRrCt7iTwc VLPxGfiMHhiTCDYwSlmYzMWXOWlf10svydN1SIkrXpXc3J3Eb/10s3QPYxhewuI6PzGh I+Kw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:mime-version:in-reply-to:references:date :message-id:subject:from:to; bh=fraOGpuuFkId5c/R321DqkPtti8JYuwOeUQR2CBWCFM=; b=K0gbqmMpYTXtG9vMmCG/UiRlPu+xCTRBgLbKwnVVuNKh9TkOCyTG+qn22TvXrVNfEo atwdbXyOspDYy7gHDjhS9coURBVXvL1tphPz23ldDuSfdDR9roPayNNNbgHvLae2vZ0p CJtkb6AqX9CexvaNOm6Y6q+7k6MghJalOUsTekPjeERvKwnG/Pkx7+c8QJk0SdIAP4Q6 4rUfvw0OqJROheVW7t5Zk1I4DHvtYv+0tyS0kYIhQ2NfoOTHurYPUDoreeDV+HKLxXQg MX5OLvEnw2/YSOsyWcG3QmRq+EuQHduevbSWlvWUgmKK5FgiBL+bXuJZlnyKQ4r8dMz6 eyMQ== X-Gm-Message-State: AD7BkJI3Y7O0GTH4AGj88UFhLtve8uW8KIFgJ9YtdA8wIsOByqkji/+Ru0lMq6kNAB1Oi7ysHYcnYgizGYLZfA== MIME-Version: 1.0 X-Received: by 10.182.242.4 with SMTP id wm4mr20173654obc.85.1457506007864; Tue, 08 Mar 2016 22:46:47 -0800 (PST) Received: by 10.202.49.200 with HTTP; Tue, 8 Mar 2016 22:46:47 -0800 (PST) Received: by 10.202.49.200 with HTTP; Tue, 8 Mar 2016 22:46:47 -0800 (PST) In-Reply-To: References: Date: Wed, 9 Mar 2016 12:16:47 +0530 Message-ID: Subject: Re: read-only mode for hive From: Sabarish Sasidharan To: user@hive.apache.org Content-Type: multipart/alternative; boundary=e89a8ff24ea3db5ca7052d980ffb --e89a8ff24ea3db5ca7052d980ffb Content-Type: text/plain; charset=UTF-8 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 you implying >> to put one of these databases in READ ONLY mode? >> >> Dr Mich Talebzadeh >> >> >> >> LinkedIn * https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw >> * >> >> >> >> http://talebzadehmich.wordpress.com >> >> >> >> On 8 March 2016 at 20: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 read-only mode? >>> Can I take a lock at database level to serve purpose? What will happen >>> to existing transaction? My guess is it will not grant a lock until all >>> transactions are complete. >>> >>> I read to change owner ship of /user/hive/warehouse/, but it is not full >>> proof solution. >>> >>> Thank you. >>> >>> - PG User >>> >> >> > --e89a8ff24ea3db5ca7052d980ffb Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable

Does views solve your purpose?

Regards
Sab

On 09-Mar-2016 6:23 am, "PG User" <= pguser1982@gmail.com> wrote:=
Ye= s, putting any database or any table to read-only mode will serve my purpos= e.

On Tue, M= ar 8, 2016 at 3:15 PM, Mich Talebzadeh <mich.talebzadeh@gmail.com<= /a>> wrote:
Hi= ve much like MSSQL or SAP ASE has multiple databases. Are you implying to p= ut one of these databases in READ ONLY mode?


On 8 March 2016 at 20:09, PG User <pgus= er1982@gmail.com> wrote:
Hi All,
I have one question about putting hive in read-o= nly mode.

What are the ways of putting hive in rea= d-only mode?
Can I take a lock at database level to serve purpose= ? What will happen to existing transaction? My guess is it will not grant a= lock until all transactions are complete.

I read = to change owner ship of /user/hive/warehouse/, but it is not full proof sol= ution.

Thank you.

- PG User


--e89a8ff24ea3db5ca7052d980ffb--