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 2991E17843 for ; Thu, 12 Mar 2015 22:30:42 +0000 (UTC) Received: (qmail 52347 invoked by uid 500); 12 Mar 2015 22:30:38 -0000 Delivered-To: apmail-hive-user-archive@hive.apache.org Received: (qmail 52283 invoked by uid 500); 12 Mar 2015 22:30:38 -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 52273 invoked by uid 99); 12 Mar 2015 22:30:38 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 12 Mar 2015 22:30:38 +0000 X-ASF-Spam-Status: No, hits=1.5 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of buntudev@gmail.com designates 74.125.82.171 as permitted sender) Received: from [74.125.82.171] (HELO mail-we0-f171.google.com) (74.125.82.171) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 12 Mar 2015 22:30:13 +0000 Received: by wesx3 with SMTP id x3so19548420wes.4 for ; Thu, 12 Mar 2015 15:29:26 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:date:message-id:subject:from:to:content-type; bh=EMSbqobSeTQzq8XbcqFkFPCSbmtBiFrQdYJEZhQAG1k=; b=jhHB1RTI3mLAOVrnI9O4jQTeMSVQWHfiIyW8I/DMQFsx+rHnS1RZYCfNyHBCVlKXPS lYATrq5q7bXgbDedX6TALIh0H8s0ZpAZn/ME3AQo3EKiT84HyF461IKAQhCMPZ7li5zI JQhqnpg+utw+5TOW8zS4MZEtGVPaFH+S1fEJIMwlBOh30wmyGkiHL1fhUf6k50XqRhcb u1DOiF2Rr+kqoUTUzzJaT2lr9dwZflWBXZdf2uB5Br/iC5KrIK71xx0PL4sZYPzcHyUv 1zN8nd1DFO2AnYEnOGggV/5GQvTTiOapX5x3xv8h6T8jk+KdfU9RQjVY8mEpWbkHozy9 pfEA== MIME-Version: 1.0 X-Received: by 10.180.98.131 with SMTP id ei3mr90827926wib.62.1426199366768; Thu, 12 Mar 2015 15:29:26 -0700 (PDT) Received: by 10.27.47.2 with HTTP; Thu, 12 Mar 2015 15:29:26 -0700 (PDT) Date: Thu, 12 Mar 2015 15:29:26 -0700 Message-ID: Subject: Error creating a partitioned view From: Buntu Dev To: user@hive.apache.org Content-Type: multipart/alternative; boundary=f46d041826eca29b0405111eea4b X-Virus-Checked: Checked by ClamAV on apache.org --f46d041826eca29b0405111eea4b Content-Type: text/plain; charset=UTF-8 I got a 'log' table which is currently partitioned by year, month and day. I'm looking to create a partitioned view on top of 'log' table but running into this error: ~~~~ hive> CREATE VIEW log_view PARTITIONED ON (pagename,year,month,day) AS SELECT pagename year,month,day,uid,properties FROM log; FAILED: SemanticException [Error 10093]: Rightmost columns in view output do not match PARTITIONED ON clause ~~~~ How do I go about creating this view? Thanks! --f46d041826eca29b0405111eea4b Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable

I got a 'log' table which is currently partitioned= by year, month and day. I'm looking to create a=C2=A0partitioned view = on top of 'log' table but running into this error:

~~~~

hive> CREATE VIEW log_view PARTITIONED ON= (pagename,year,month,day) AS SELECT pagename=C2=A0year,month,day,ui= d,properties FROM log;=C2=A0

FAILED: SemanticException [Er= ror 10093]: Rightmost columns in view output do not match PARTITIONED ON cl= ause

~~~~

How do I go about creating = this view?

Thanks!

--f46d041826eca29b0405111eea4b--