Created PHOENIX-5301 <https://issues.apache.org/jira/browse/PHOENIX-5301>.
Thank you, Thomas. On Fri, May 24, 2019 at 2:18 PM Thomas D'Silva <[email protected]> wrote: > 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 <[email protected]> > 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 <[email protected]> > > 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 > > > -- Thank you, *Karthik Palanisamy* Mobile : +1 669 292 7106 Skype : karthik.p01
