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 C4F2318B78 for ; Wed, 29 Jul 2015 20:28:19 +0000 (UTC) Received: (qmail 92669 invoked by uid 500); 29 Jul 2015 20:28:18 -0000 Delivered-To: apmail-hive-user-archive@hive.apache.org Received: (qmail 92599 invoked by uid 500); 29 Jul 2015 20:28:18 -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 92588 invoked by uid 99); 29 Jul 2015 20:28:18 -0000 Received: from Unknown (HELO spamd4-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 29 Jul 2015 20:28:18 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd4-us-west.apache.org (ASF Mail Server at spamd4-us-west.apache.org) with ESMTP id 8D784C0721 for ; Wed, 29 Jul 2015 20:28:17 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd4-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 2.9 X-Spam-Level: ** X-Spam-Status: No, score=2.9 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, HTML_MESSAGE=3, SPF_PASS=-0.001, URIBL_BLOCKED=0.001] autolearn=disabled Authentication-Results: spamd4-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=gmail.com Received: from mx1-us-west.apache.org ([10.40.0.8]) by localhost (spamd4-us-west.apache.org [10.40.0.11]) (amavisd-new, port 10024) with ESMTP id UmXNn4TkWMI1 for ; Wed, 29 Jul 2015 20:28:07 +0000 (UTC) Received: from mail-io0-f170.google.com (mail-io0-f170.google.com [209.85.223.170]) by mx1-us-west.apache.org (ASF Mail Server at mx1-us-west.apache.org) with ESMTPS id C764A205B3 for ; Wed, 29 Jul 2015 20:28:06 +0000 (UTC) Received: by ioii16 with SMTP id i16so33567877ioi.0 for ; Wed, 29 Jul 2015 13:28:06 -0700 (PDT) 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 :content-type; bh=j4GkAxQq+SYGcICbVx9A+HyC40p1eFL0qjrwnAgOf0U=; b=TCEPU9EQe1P30KbMH4j7NijOXJss9lm5Xb+ktaCNJuLbzAWwtIaK6ddhtkZ85yik6A 2qKtRW3ItflDELh1F1IumMt2NblTI5jfT9y2ylAJ0roe81C94EhUHHdl3G7WQ/9g0Jnr dtBVp2exCu1VPFKH3Hjz+u8lQkBx/B5Lbk610m7vIKiOIWXiPPRixx2YOimofyRAqd6a Q3ifsmgb5OyLiP6j4meUJUQ1cCIq+/aLS4hPnkG8OX0O7qdnzddcjHxttmaENOdheDue b3WPAWPFIoLfnDdGn4+VEz/h+I2NuTp/pvKOE3Iae9v4hl4FQx9PpdyGkNchenvQJH+J fCNA== MIME-Version: 1.0 X-Received: by 10.107.9.137 with SMTP id 9mr5084024ioj.50.1438201686297; Wed, 29 Jul 2015 13:28:06 -0700 (PDT) Received: by 10.36.111.148 with HTTP; Wed, 29 Jul 2015 13:28:06 -0700 (PDT) In-Reply-To: <95e7c7bbeae156ec2492b745b89d42c8@cvweb08.wmail.nhnsystem.com> References: <95e7c7bbeae156ec2492b745b89d42c8@cvweb08.wmail.nhnsystem.com> Date: Wed, 29 Jul 2015 13:28:06 -0700 Message-ID: Subject: Re: create db command through hs2 makes a directory owned by hive From: Takahiko Saito To: user@hive.apache.org, Han-Cheol Cho Content-Type: multipart/alternative; boundary=001a113f8f14a09713051c096cee --001a113f8f14a09713051c096cee Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable You should set hive.server2.enable.doAs to 'true' in hive-site.xml and change hadoop.proxyuser.hive.hosts in core-site.xml. On Tue, Jul 28, 2015 at 1:51 AM, Han-Cheol Cho wrote: > Hi, all > > > > Even I user impersonation, running "create database test01" in beeline > > (and hue that uses hs2) makes a directory in HDFS owned by *hive* user. > > However, table directories and files under it are all correctly owned by = a > > user. > > > > For user impersonation, I followed the cloudera documentation by adding > > hadoop.proxy.hive.hosts and hadoop.proxy.hive.hosts to core-site.xml and > > hive.server2.doAs to hive-site.xml. > > > > Is there someone who experienced the same problem? > > I am wonder whether this is a bug or my misconfiguration. > > > > Best wishes, > > > > > *=E8=B6=99=E6=BC=A2=E5=93=B2* CHO, HAN-CHEOL (Ph.D) > =E3=83=87=E3=83=BC=E3=82=BF=E7=A0=94=E7=A9=B6=E5=AE=A4 / =E7=A4=BE=E5=93= =A1 > =E3=80=92105-6322 =E6=9D=B1=E4=BA=AC=E9=83=BD=E6=B8=AF=E5=8C=BA=E8=99=8E= =E3=83=8E=E9=96=80=EF=BC=91=EF=BC=8D23-1 =E8=99=8E=E3=83=8E=E9=96=80=E3=83= =92=E3=83=AB=E3=82=BA=E6=A3=AE=E3=82=BF=E3=83=AF=E3=83=BC22=E9=9A=8E > Email hancheol.cho@nhn-playart.com Messenger > > NHN PlayArt =E6=A0=AA=E5=BC=8F=E4=BC=9A=E7=A4=BE > --=20 Takahiko Saito --001a113f8f14a09713051c096cee Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
You should set hive.server2.enable.doAs to 'true' = =C2=A0in hive-site.xml and change hadoop.proxyuser.hive.hosts in core-site.= xml.

On Tue,= Jul 28, 2015 at 1:51 AM, Han-Cheol Cho <hancheol.cho@nhn-playa= rt.com> wrote:

Hi, all

=C2=A0

Even I user impersonation,= =C2=A0running "create d= atabase test01" in beeline

=C2=A0(and hue that uses hs2) = makes a directory in HDFS owned by *hive* user.

However, table direct= ories and files under it are all correctly owned by a=C2=A0

user.

=

=C2=A0

For user impersonation, I followed the cloudera documentati= on by adding=C2=A0

hadoop.proxy.hive.hosts and=C2=A0hadoop.proxy.hive.hosts to core= -site.xml and

hive.server2.doAs to hive-site.xml.

=C2=A0

Is there someone wh= o experienced the same problem?

I am wonder whether this is a bug or my misc= onfiguration.

=C2=A0

Best wishes,

=C2=A0

=C2=A0

=E8=B6=99=E6=BC=A2=E5=93= =B2 =C2=A0CHO, HAN-CHEOL= (Ph.D)
=E3=83=87=E3= =83=BC=E3=82=BF=E7=A0=94=E7=A9=B6=E5=AE=A4 / =E7=A4=BE=E5=93=A1
=E3=80=92105-6322 =E6=9D=B1=E4= =BA=AC=E9=83=BD=E6=B8=AF=E5=8C=BA=E8=99=8E=E3=83=8E=E9=96=80=EF=BC=91=EF=BC= =8D23-1 =E8=99=8E=E3=83=8E=E9=96=80=E3=83=92=E3=83=AB=E3=82=BA=E6=A3=AE=E3= =82=BF=E3=83=AF=E3=83=BC22=E9=9A=8E
Email=C2=A0 = hancheol.cho@nhn-playart.com = =C2=A0=C2=A0Messenger= =C2=A0

NHN PlayArt =E6=A0= =AA=E5=BC=8F=E4=BC=9A=E7=A4=BE



--
Takahiko Saito
--001a113f8f14a09713051c096cee--