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 F2D442009E8 for ; Mon, 30 May 2016 19:20:23 +0200 (CEST) Received: by cust-asf.ponee.io (Postfix) id F1B12160A19; Mon, 30 May 2016 17:20:23 +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 43DFC160969 for ; Mon, 30 May 2016 19:20:23 +0200 (CEST) Received: (qmail 85201 invoked by uid 500); 30 May 2016 17:20:22 -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 85172 invoked by uid 99); 30 May 2016 17:20:21 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd4-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 30 May 2016 17:20:21 +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 70985C1921 for ; Mon, 30 May 2016 17:20:21 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd4-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 2.632 X-Spam-Level: ** X-Spam-Status: No, score=2.632 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, HTML_MESSAGE=2, RCVD_IN_DNSWL_NONE=-0.0001, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01, SPF_NEUTRAL=0.652] autolearn=disabled Authentication-Results: spamd4-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=exponea-com.20150623.gappssmtp.com Received: from mx2-lw-eu.apache.org ([10.40.0.8]) by localhost (spamd4-us-west.apache.org [10.40.0.11]) (amavisd-new, port 10024) with ESMTP id 9u1IrZrN2p8a for ; Mon, 30 May 2016 17:20:20 +0000 (UTC) Received: from mail-it0-f46.google.com (mail-it0-f46.google.com [209.85.214.46]) by mx2-lw-eu.apache.org (ASF Mail Server at mx2-lw-eu.apache.org) with ESMTPS id C51615F3A0 for ; Mon, 30 May 2016 17:20:19 +0000 (UTC) Received: by mail-it0-f46.google.com with SMTP id z123so35777310itg.0 for ; Mon, 30 May 2016 10:20:19 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=exponea-com.20150623.gappssmtp.com; s=20150623; h=mime-version:date:message-id:subject:from:to; bh=POOIy9mwnlqlxFf+5KoFtrMaHNuvz/XTqjiej9FQwz4=; b=EdZ5M2RhkFjZyd53lylZDB/woKSKcCtt9ZYwksBgeEF+DJCmURk56hRiqZDkGRi+8y ZK1fRn95y5hBHf836Iq+E77nifom4nOXOhC80DAkq9E5yhZFzn3lmFtXY437Lgl6o9QK 2AWDcR2Wk8hxOg7wZ27iuZTuLRiSY2AmrLDorS5cQeylDVMtmYyYv7Dtny8aaBAjsbyS 9UP/8rRbCEibtDmjR/jF/jH4BjWu+UPHuIkIs5CqR1RomOOvCgCZrBBGzeNb60Z3zM9M JStHJHUQ980o9dKfNAHqu5IZrQDycMODTqjLLOfOChquoANIwGXWrWr0E0IdBQMvqULd XwFg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:mime-version:date:message-id:subject:from:to; bh=POOIy9mwnlqlxFf+5KoFtrMaHNuvz/XTqjiej9FQwz4=; b=LFe9Kk1x83Gcwm84ePVRDEuemXyjOnpVlhZhD64uRELaaq91/qied0iTQpaZ4MIdt8 v+YoBqJV/tpLjDrj3BV9mNr1edefpdgUxci/8krxjKvy0POdOb4IR7a0BIJoJ77wydg1 aGFtZ0jSaTCJ6DH1wU142Rlfa9n8eqvJQ/YIrLPcg+SS7CMuJNdRBRvloiVx7Dq1JW96 lk8or4IGWWSw3Mvdt36Jc11Af4S9F7zW5NmOSFQ7gwadvVDneaoSyNSwhYKStH308zIg XvHKvo8Jb0bzmPaxLmkXEhX/j8c52U8klwn9kbcyjJDNUoNvn4YZbCFEolrF+Y9t3Ao/ ECKQ== X-Gm-Message-State: ALyK8tLHJ10BZIvi+UAefP9qucg5sv9ADW09qI2tWO+Kf1Cm4NhyJsmnJM+rh8QVLMAWHoPHJW5FLpFrDrXrag== MIME-Version: 1.0 X-Received: by 10.36.29.129 with SMTP id 123mr9285866itj.61.1464628812947; Mon, 30 May 2016 10:20:12 -0700 (PDT) Received: by 10.36.63.198 with HTTP; Mon, 30 May 2016 10:20:12 -0700 (PDT) Date: Mon, 30 May 2016 19:20:12 +0200 Message-ID: Subject: SHOW DATABASES/TABLES with SQL standard authorization From: Lukas Lalinsky To: user@hive.apache.org Content-Type: multipart/alternative; boundary=001a114386d21fb97d0534127889 archived-at: Mon, 30 May 2016 17:20:24 -0000 --001a114386d21fb97d0534127889 Content-Type: text/plain; charset=UTF-8 I'm setting up a Hive instance with the SQL standard authorization and it seems to be working great for all normal operations, but for SHOW DATABASES/TABLES it's behaving differently from what I would expect. It always shows all databases/tables, even though I do not have access to those tables. Is that the intended behavior? Or is there something that can be done to filter out items which I can't access? Regards, Lukas --001a114386d21fb97d0534127889 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
I'm setting up a Hive = instance with the=C2=A0SQL standard authorization and it seems to be workin= g great for all normal operations, but for=C2=A0SHOW DATABASES/TABLES it= 9;s behaving differently from what I would expect.

It always shows all = databases/tables, even though I do not have access to those tables. Is that= the intended behavior? Or is there something that can be done to filter ou= t items which I can't access?
=
Regards,

Lukas
--001a114386d21fb97d0534127889--