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 EB7A310B1D for ; Sun, 15 Mar 2015 17:53:38 +0000 (UTC) Received: (qmail 30232 invoked by uid 500); 15 Mar 2015 17:53:37 -0000 Delivered-To: apmail-hive-user-archive@hive.apache.org Received: (qmail 30166 invoked by uid 500); 15 Mar 2015 17:53:37 -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 30155 invoked by uid 99); 15 Mar 2015 17:53:37 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 15 Mar 2015 17:53:37 +0000 X-ASF-Spam-Status: No, hits=3.2 required=5.0 tests=FORGED_YAHOO_RCVD,HTML_MESSAGE,RCVD_IN_DNSWL_NONE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of ququrico@yahoo.com designates 98.136.218.89 as permitted sender) Received: from [98.136.218.89] (HELO nm1-vm10.bullet.mail.gq1.yahoo.com) (98.136.218.89) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 15 Mar 2015 17:53:09 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1426441923; bh=q9Otek0U2jiqmzlt6U2kpjg8pS71UhNYH4SVl5m0C8w=; h=Date:From:Reply-To:To:Subject:From:Subject; b=SRxjEaP86yTS0hwj3pwCbuQP49luKoVmBu4qxK0kNlJT/koMe8mnVlVaWzVwTiO+aHsWcR3EAh3VYmuffdMywLAG/4d0iGjuC4SbaiE5BcaZj/BBmxQ6iD++fzKdas2oG+ITny0Utpv5tXScZE035aZuccywND92kBeZjgUrKqeC3RbO4us3lOKC2ggl3RXzbfIs9KXg2L9JyhgXPK9skpQf0gtJxL33ouzAqGY0YMCR0J1lnMUbNMfmoqIK5Grld+wJBiEe/qFasTTD7xEMeaiED6WFcOrCcCEv1nwj7HPsyhVRusI3Fu9EDmnjsTHL5rWETkEYDPlWKdvYmA32yg== Received: from [98.137.12.188] by nm1.bullet.mail.gq1.yahoo.com with NNFMP; 15 Mar 2015 17:52:03 -0000 Received: from [98.137.12.236] by tm9.bullet.mail.gq1.yahoo.com with NNFMP; 15 Mar 2015 17:52:03 -0000 Received: from [127.0.0.1] by omp1044.mail.gq1.yahoo.com with NNFMP; 15 Mar 2015 17:52:03 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 90552.55606.bm@omp1044.mail.gq1.yahoo.com X-YMail-OSG: 7PxoXnEVM1m34N9MwMLEx3KF8n5bmzJUaR_98kkiaCcBI11lgunc3r6ih6pgB_8 vbGYqgLRQarvA6IRrSY9UBEJssk6oG4zICBa6mzjtAa4f4r0dDURmJN8X2tjn9ZzhkTomCojtLZq gMHzG0XxEx6kPkeX75ZWnx5_wJocw9T6IUUzQuIE_Iz_O08qpJw8jtsAKfsTvUjELPou5TDmVZO8 wSocMbEnCvth0DC5V9iWgWfFULxM_zu.CorPgoZ.C2l.Sj7VL6y9gPmMfhXEjOYrxT9BIFwVrkuw TJBuLfxBFoZZkjy5ikhh1UkcNxmyxPf1nIWhsI4Fk7NeCH2aB_aE_7r36QCT0zXKL5hub6CQ66MK ub6loL0OWoJVvLmlxltAMNDSq_aUaTHzyYN7_Yyw7a5a9pR7qJtNnTyEXdaSHnBm5BKO4wdooqvf FqvUnYpFYfmF_GeEAPs2OzuOk4tI1cbffm3HO0fP4pEBqRT6ox99l19DVwBfofA.ogzft9ilQNgA- Received: by 216.39.60.201; Sun, 15 Mar 2015 17:52:02 +0000 Date: Sun, 15 Mar 2015 17:52:02 +0000 (UTC) From: cobby cohen Reply-To: cobby cohen To: "user@hive.apache.org" Message-ID: <1232394552.751114.1426441922255.JavaMail.yahoo@mail.yahoo.com> Subject: view over partitioned table MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_751113_322648138.1426441922252" X-Virus-Checked: Checked by ClamAV on apache.org ------=_Part_751113_322648138.1426441922252 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit in the following case: create table T1(id string)partitioned by (date date); create view V1(id, date)select id, date from T1 if i do the followingselect id from V1 where date = '2015-04-04'will the query optimize on T1's partitioning? and what if V1 is a bit more complex, further depending on other views (all of which expose the partitioned column as-is)? thx! ------=_Part_751113_322648138.1426441922252 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
in th= e following case:

creat= e table T1(id string)
partitioned by (date date);

create view V1(id, date)
select id, date from T1

if i do the following
select id from V1 where date =3D '2015-04= -04'
will the = query optimize on T1's partitioning?

and what if V1 is a bit more complex, further depending on ot= her views (all of which expose the partitioned column as-is)?

thx!
------=_Part_751113_322648138.1426441922252--