From user-return-1457-apmail-phoenix-user-archive=phoenix.apache.org@phoenix.apache.org Mon Sep 29 15:24:36 2014 Return-Path: X-Original-To: apmail-phoenix-user-archive@minotaur.apache.org Delivered-To: apmail-phoenix-user-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id A85DB17492 for ; Mon, 29 Sep 2014 15:24:36 +0000 (UTC) Received: (qmail 34162 invoked by uid 500); 29 Sep 2014 15:24:36 -0000 Delivered-To: apmail-phoenix-user-archive@phoenix.apache.org Received: (qmail 34130 invoked by uid 500); 29 Sep 2014 15:24:36 -0000 Mailing-List: contact user-help@phoenix.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@phoenix.apache.org Delivered-To: mailing list user@phoenix.apache.org Received: (qmail 34117 invoked by uid 99); 29 Sep 2014 15:24:35 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 29 Sep 2014 15:24:35 +0000 X-ASF-Spam-Status: No, hits=2.5 required=5.0 tests=FREEMAIL_REPLY,HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of elilevine@gmail.com designates 209.85.223.176 as permitted sender) Received: from [209.85.223.176] (HELO mail-ie0-f176.google.com) (209.85.223.176) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 29 Sep 2014 15:24:09 +0000 Received: by mail-ie0-f176.google.com with SMTP id ar1so20353442iec.35 for ; Mon, 29 Sep 2014 08:24:08 -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=n7d+vZKL4YZLcMGomyg7BxdV+CKmiCWaMS3bonPnls8=; b=sHkc0EC43lIPJq8MpooaRHmODyKXAU81hL+ayF8cPPBtrmFeA1VjPimDPIbjJkMH49 MsWBnup2kldCVXiyf4VRw3nq8duSV+M4p0yxjOMcOV2jzTV+76U6Vb+vaVv/kEOOkceO /mUHNjJfHZSrm9df50odtLv+gXzPWml69RSAH6BO9xqkIGXxgI7/qmCV6YHKd1DiKlkb KVLXn5l0WVcvC6v/+kMggJf98VHg/MmEIS7ThjPBLL5JIZ2YAIuXgz/P93+n1x2wLGM5 gdxhdLv0+588v2XH7XqXq8avj6QL0Ly6NThQBgPubG0UxydkJYLMNUUSz48TtYWgzMI+ WgEw== MIME-Version: 1.0 X-Received: by 10.42.62.6 with SMTP id w6mr47604397ich.24.1412004248101; Mon, 29 Sep 2014 08:24:08 -0700 (PDT) Received: by 10.64.143.38 with HTTP; Mon, 29 Sep 2014 08:24:08 -0700 (PDT) In-Reply-To: References: Date: Mon, 29 Sep 2014 08:24:08 -0700 Message-ID: Subject: Re: Phoenix View creation error From: Eli Levine To: user@phoenix.apache.org Content-Type: multipart/alternative; boundary=90e6ba614f0ca12946050435dbd2 X-Virus-Checked: Checked by ClamAV on apache.org --90e6ba614f0ca12946050435dbd2 Content-Type: text/plain; charset=UTF-8 Hi Pari, Phoenix supports views in version 3.0 and higher only. Thanks, Eli On Mon, Sep 29, 2014 at 12:08 AM, Pariksheet Barapatre wrote: > Hi All, > > I am trying to create view on table given in phoenix website - > > CREATE TABLE product_metrics ( > metric_type CHAR(1) NOT NULL, > created_by VARCHAR, > created_date DATE, > metric_id INTEGER > CONSTRAINT pk PRIMARY KEY (metric_type)); > > CREATE VIEW mobile_product_metrics (carrier VARCHAR, dropped_calls BIGINT) > AS > SELECT * FROM product_metrics > WHERE metric_type = 'm'; > > But its giving error - > Error: ERROR 602 (42P00): Syntax error. Missing "EOF" at line 1, column > 76. (state=42P00,code=602) > > Any clue, I am using phoenix 2.2.3. > > Many Thanks > Pari > --90e6ba614f0ca12946050435dbd2 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Hi Pari,

Phoenix supports views in = version 3.0 and higher only.

Thanks,

Eli
=

On Mon, Sep= 29, 2014 at 12:08 AM, Pariksheet Barapatre <pbarapatre@gmail.com= > wrote:
=
Hi All,

I am trying to create view on table given in phoe= nix website -

CREATE=C2=A0 TABLE product_metrics (
=C2=A0=C2=A0= =C2=A0 metric_type CHAR(1) NOT NULL,
=C2=A0=C2=A0=C2=A0 created_by VARCH= AR,
=C2=A0=C2=A0=C2=A0 created_date DATE,
=C2=A0=C2=A0=C2=A0 metric= _id INTEGER
=C2=A0=C2=A0=C2=A0 CONSTRAINT pk PRIMARY KEY (metric_type));=

CREATE VIEW mobile_product_metrics (carrier VARCHAR, dropped_calls = BIGINT) AS
SELECT * FROM product_metrics
WHERE metric_type =3D 'm= ';

But its giving error -
Error: ERROR 602 (42P00= ): Syntax error. Missing "EOF" at line 1, column 76. (state=3D42P= 00,code=3D602)

Any clue, I am using phoenix 2.2.3.
Many Thanks
Pari

--90e6ba614f0ca12946050435dbd2--