You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@phoenix.apache.org by Pariksheet Barapatre <pb...@gmail.com> on 2014/09/29 09:08:07 UTC
Phoenix View creation error
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
Re: Phoenix View creation error
Posted by Eli Levine <el...@gmail.com>.
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 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
>