Karthik Palanisamy created PHOENIX-5301:
-------------------------------------------
Summary: Doc: Fix incorrect DDL and DML (In ARRAY Type page)
Key: PHOENIX-5301
URL: https://issues.apache.org/jira/browse/PHOENIX-5301
Project: Phoenix
Issue Type: Bug
Affects Versions: 5.0.0
Reporter: Karthik Palanisamy
Assignee: Karthik Palanisamy
Attachments: array_type.md
1. Remove multipart PRIMARY KEY constraint since this pk is defined already.
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
2. DML failed because undefined column "zip" is used. Use "zips", instead.
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';
..
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
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
