[ https://issues.apache.org/jira/browse/PHOENIX-3624?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Thomas D'Silva resolved PHOENIX-3624. ------------------------------------- Resolution: Fixed > Empty array element returned with immutable encoding scheme > ----------------------------------------------------------- > > Key: PHOENIX-3624 > URL: https://issues.apache.org/jira/browse/PHOENIX-3624 > Project: Phoenix > Issue Type: Sub-task > Reporter: Mujtaba Chohan > Assignee: Samarth Jain > Attachments: PHOENIX-3624.patch, PHOENIX-3624_v2.patch > > > {noformat} > CREATE TABLE regions (region_name VARCHAR PRIMARY KEY,zip VARCHAR ARRAY[10]) > IMMUTABLE_ROWS=true; > UPSERT INTO regions(region_name,zip) VALUES('SF Bay > Area',ARRAY['94115','94030','94125']); > {noformat} > Selecting any element of zip array doesn't work for immutable encoded table > (works fine with mutable encoding) > {noformat} > SELECT zip[2] FROM regions; > +---------------------+ > | ARRAY_ELEM(ZIP, 2) | > +---------------------+ > | | > +---------------------+ > {noformat} -- This message was sent by Atlassian JIRA (v6.3.15#6346)