phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Karthik Palanisamy (JIRA)" <j...@apache.org>
Subject [jira] [Created] (PHOENIX-5301) Doc: Fix incorrect DDL and DML (In ARRAY Type page)
Date Fri, 24 May 2019 22:05:01 GMT
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)

Mime
View raw message