Re: Phoenix Document Access

[Karthik P]

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 <karthikshva...@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