You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "Hudson (JIRA)" <ji...@apache.org> on 2014/10/14 08:12:34 UTC
[jira] [Commented] (PHOENIX-619) Support DELETE over table with
immutable index when possible
[ https://issues.apache.org/jira/browse/PHOENIX-619?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14170562#comment-14170562 ]
Hudson commented on PHOENIX-619:
--------------------------------
SUCCESS: Integrated in Phoenix | Master #422 (See [https://builds.apache.org/job/Phoenix-master/422/])
PHOENIX-619 Support DELETE over table with immutable index when possible (jtaylor: rev 8f2a76d60ba1452466133da8e1dc3de8d1140ed2)
* phoenix-core/src/main/java/org/apache/phoenix/execute/MutationState.java
* phoenix-core/src/main/java/org/apache/phoenix/compile/PostIndexDDLCompiler.java
* phoenix-core/src/main/java/org/apache/phoenix/compile/DeleteCompiler.java
* phoenix-core/src/it/java/org/apache/phoenix/end2end/index/ViewIndexIT.java
* phoenix-core/src/main/java/org/apache/phoenix/compile/UpsertCompiler.java
* phoenix-core/src/test/java/org/apache/phoenix/compile/TenantSpecificViewIndexCompileTest.java
* phoenix-core/src/main/java/org/apache/phoenix/exception/SQLExceptionCode.java
* phoenix-core/src/test/java/org/apache/phoenix/compile/QueryCompilerTest.java
* phoenix-core/src/it/java/org/apache/phoenix/end2end/TenantSpecificTablesDMLIT.java
* phoenix-core/src/main/java/org/apache/phoenix/query/ConnectionQueryServicesImpl.java
* phoenix-core/src/main/java/org/apache/phoenix/compile/MutatingParallelIteratorFactory.java
* phoenix-core/src/main/java/org/apache/phoenix/optimize/QueryOptimizer.java
* phoenix-core/src/it/java/org/apache/phoenix/end2end/index/ImmutableIndexIT.java
* phoenix-core/src/main/java/org/apache/phoenix/schema/MetaDataClient.java
* phoenix-core/src/it/java/org/apache/phoenix/end2end/BaseTenantSpecificTablesIT.java
* phoenix-core/src/main/java/org/apache/phoenix/util/IndexUtil.java
* phoenix-core/src/main/java/org/apache/phoenix/jdbc/PhoenixResultSet.java
> Support DELETE over table with 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
> Attachments: PHOENIX-619.patch
>
>
> 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.3.4#6332)