phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Thomas D'Silva" <tdsi...@salesforce.com.INVALID>
Subject Re: Phoenix Document Access
Date Fri, 24 May 2019 21:17:59 GMT
Can you please file a JIRA for this and attach the markup change there?

On Thu, May 23, 2019 at 5:22 PM Karthik P <karthikshva123@gmail.com> wrote:

> fyi, Change is made for this,
>
> CREATE TABLE regions (
>     region_name VARCHAR PRIMARY KEY,
>     zips VARCHAR ARRAY[10],
>     CONSTRAINT pk PRIMARY KEY (region_name));
>
> Error: ERROR 510 (42889): The table already has a primary key.
> columnName=REGION_NAME (state=42889,code=510)
> java.sql.SQLException: ERROR 510 (42889): The table already has a primary
> key. columnName=REGION_NAME
>
> SELECT zip[1] FROM regions WHERE region_name = 'SF Bay Area';
>
> SELECT region_name FROM regions WHERE zip[1] = '94030' OR zip[2] =
> '94030' OR zip[3] = '94030';
>
> SELECT region_name FROM regions WHERE '94030' = ANY(zip);
> SELECT region_name FROM regions WHERE '94030' = ALL(zip);
>
> SELECT region_name FROM regions WHERE zip[1] = '94030' OR zip[2] =
> '94030' OR zip[3] = '94030';
>
> SELECT region_name FROM regions WHERE zip[1] = '94030' AND zip[2] =
> '94030' AND zip[3] = '94030';
>
> Error: ERROR 504 (42703): Undefined column. columnName=REGIONS.ZIP
> (state=42703,code=504)
> org.apache.phoenix.schema.ColumnNotFoundException: ERROR 504 (42703):
> Undefined column. columnName=REGIONS.ZIP
>
> Thanks,
> Karthik
>
>
> On Thu, May 23, 2019 at 5:05 PM Karthik P <karthikshva123@gmail.com>
> wrote:
>
> > Team,
> >
> > It looks only phoenix committer can do doc update but not contributors.
> > Am I right?
> >
> > I see there is incorrect DDL and DML statement in the ARRAY Type page.
> > https://phoenix.apache.org/array_type.html
> >
> > I corrected this small change. Can someone please update attached
> markdown
> > file in the Phoenix website?
> >
> > My UserId: kpalanisamy
> >
> >
> > Thanks,
> > Karthik
> >
> >
>
> --
> Thank you,
> *Karthik Palanisamy*
> Mobile : +1 669 292 7106
> Skype : karthik.p01
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message