Return-Path: X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by cust-asf2.ponee.io (Postfix) with ESMTP id ACD59200D53 for ; Tue, 5 Dec 2017 22:27:31 +0100 (CET) Received: by cust-asf.ponee.io (Postfix) id AB5C9160C1B; Tue, 5 Dec 2017 21:27:31 +0000 (UTC) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id F0445160BF1 for ; Tue, 5 Dec 2017 22:27:30 +0100 (CET) Received: (qmail 88893 invoked by uid 500); 5 Dec 2017 21:27:30 -0000 Mailing-List: contact user-help@impala.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@impala.apache.org Delivered-To: mailing list user@impala.apache.org Received: (qmail 88883 invoked by uid 99); 5 Dec 2017 21:27:30 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd2-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 05 Dec 2017 21:27:30 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd2-us-west.apache.org (ASF Mail Server at spamd2-us-west.apache.org) with ESMTP id 466A61A0B1A for ; Tue, 5 Dec 2017 21:27:29 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd2-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 2.379 X-Spam-Level: ** X-Spam-Status: No, score=2.379 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, HTML_MESSAGE=2, RCVD_IN_DNSWL_NONE=-0.0001, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01, RCVD_IN_SORBS_SPAM=0.5, SPF_PASS=-0.001] autolearn=disabled Authentication-Results: spamd2-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 (spamd2-us-west.apache.org [10.40.0.9]) (amavisd-new, port 10024) with ESMTP id TupN5kGEVvBo for ; Tue, 5 Dec 2017 21:27:28 +0000 (UTC) Received: from mail-it0-f41.google.com (mail-it0-f41.google.com [209.85.214.41]) by mx1-lw-us.apache.org (ASF Mail Server at mx1-lw-us.apache.org) with ESMTPS id 3239D5F256 for ; Tue, 5 Dec 2017 21:27:28 +0000 (UTC) Received: by mail-it0-f41.google.com with SMTP id b5so4769671itc.3 for ; Tue, 05 Dec 2017 13:27:28 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:from:date:message-id:subject:to; bh=+O+tM1KTGGAqQPLflS3fNVMflgcPCif+/pwGKLyVuew=; b=DzNu0ql7yGOgg4FLtQZ0w5GF4hIrooQXnikGGyMTh0SQcETlsQ+cdSLw6YXKZD5tjp iH+dhcdTPm23XQWGzEE/nlZoUbJ4MhukLnxfjba9kWEtCi+UiUoO1zTSuaHSyEoBUDMP xPiFsRYyo6GPylRHwlRp4aMy8VgKjlNRwrq90wVeiJ7+0ELcX1mH/2280LL6OzqiIs0D z61Pk50bGs1t/YXMKdl8Hg6lCCFyDD/O+GIKcWMKJGa9Xu9sgwbayWNvTto8MY/c3aDz kCqTl2EDHXXQjq8yfWAfMPw+bCgN1Y6Zmlwds5kw5OpcL4Lqk7wq8QEODYYshsD0rgav ktTw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:from:date:message-id:subject:to; bh=+O+tM1KTGGAqQPLflS3fNVMflgcPCif+/pwGKLyVuew=; b=d0aD8heHNWStBn5i48Fbui+Mk95PIg6n4UPNCXhrgfs+xubWAgQ+mtr+0F54Fgy9DM zlj7k6Nz/pjm7djvoxdvRxik81muZ9aSvf/DxndwQsbu/UDaOzzmdPpRs1fGYK6+XmaQ yAdI7E8aHQEIYFXx7OOtc0Ht7/ogso9hk+S2vT4DgUaHcwCXSwVB9zuBT6o5JecBynkP /N5G8BPaleq3XqHE3T07k6K7xE+c/fPAMV1OFA0ZJgx77nDXWhpKugagdkI9Lcr6BMEt jJ4jJKiTV4VgKRVHaPL+zY33p8+R/UNxF+TeON++a0XqvSoQdhKmWXbeDxdOU8eyvz5n QE1g== X-Gm-Message-State: AKGB3mJuUfHjF10uEdBjCVwcOZbFHaI2JzXdKFTb44j+d5lkSxh0SdR4 98nvOsj5yZAOGMFcixSXfQXfRuxCjxlWeCFT6j8= X-Google-Smtp-Source: AGs4zMbyrGuglQ85jHWVJ++mdITKZV7fHyyDsSnlk8sBv1jMJzVqFIMSdLrbZABPW1K+3T1Z74Yj8QKa3eFy10qvuR4= X-Received: by 10.36.70.195 with SMTP id j186mr6059494itb.32.1512509247279; Tue, 05 Dec 2017 13:27:27 -0800 (PST) MIME-Version: 1.0 Received: by 10.79.79.202 with HTTP; Tue, 5 Dec 2017 13:27:06 -0800 (PST) From: Sunil Parmar Date: Tue, 5 Dec 2017 13:27:06 -0800 Message-ID: Subject: INSERT query generated file permissions To: user@impala.apache.org Content-Type: multipart/alternative; boundary="001a11445d06675792055f9e8047" archived-at: Tue, 05 Dec 2017 21:27:31 -0000 --001a11445d06675792055f9e8047 Content-Type: text/plain; charset="UTF-8" Environment CDH 5.12 When running INSERT query on the table all files are always owned by user impala i.e. 744, all for impala read for everyone else . We have externally running compaction process which needs to read/write/replace this files. Is there a way to change this default behavior to have the file permission different than 744 ? I'd prefer if it's 764 ( group read/write ) so we can add the user to the same group as Impala who run the compaction process. Sunil Parmar --001a11445d06675792055f9e8047 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Environment CDH 5.12

When running INSERT= query on the table all files are always owned by user impala i.e. 744, all= for impala read for everyone else . We have externally running compaction = process which needs to read/write/replace this files. Is there a way to cha= nge this default behavior to have the file permission different than 744 ? = I'd prefer if it's 764 ( group read/write ) so we can add the user = to the same group as Impala who run the compaction process.

Sunil Parmar
--001a11445d06675792055f9e8047--