You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "James Taylor (JIRA)" <ji...@apache.org> on 2014/08/11 20:58:12 UTC
[jira] [Updated] (PHOENIX-619) Support DELETE for immutable index
when possible
[ https://issues.apache.org/jira/browse/PHOENIX-619?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
James Taylor updated PHOENIX-619:
---------------------------------
Priority: Major
Issue Type: Improvement (was: Task)
Summary: Support DELETE for immutable index when possible (was: Support DELETE for immutable index with non PK columns)
> Support DELETE for immutable index when possible
> ------------------------------------------------
>
> Key: PHOENIX-619
> URL: https://issues.apache.org/jira/browse/PHOENIX-619
> Project: Phoenix
> Issue Type: Improvement
> Reporter: Artur Denysenko
> Labels: enhancement
>
> I try to delete rows in this table:
> ```sql
> CREATE TABLE test.date2(
> id BIGINT NOT NULL PRIMARY KEY,
> d DATE NOT NULL
> ) IMMUTABLE_ROWS=true;
> CREATE INDEX idx_d ON test.date2(d);
> DELETE FROM test.date2;
> ```
> I do not understand why we have this limitation.
> DELETE works fine in tables with "IMMUTABLE_ROWS=false" and no "PK column in index".
> It's must be also reflected in "Phoenix Language Reference".
--
This message was sent by Atlassian JIRA
(v6.2#6252)