Powpow Shen created PHOENIX-2778:
------------------------------------
Summary: DELETE by specifying dynamic columns
Key: PHOENIX-2778
URL: https://issues.apache.org/jira/browse/PHOENIX-2778
Project: Phoenix
Issue Type: New Feature
Reporter: Powpow Shen
Say we create "test" table with schema below:
```
create table "test" ("id" INTEGER not null primary key, "staticColumn" VARCHAR);
```
search can be done by specifying dynamic columns:
```
select * from "test"("dynamicColumn" VARCHAR) where "dynamicColumn" =
'dynamic';
```
but delete can only done by specifying static columns:
```
delete from "test" where "staticColumn" = 'static';
```
NOT by specifying dynamic columns:
```
delete from "test"("dynamicColumn" VARCHAR) where "dynamicColumn" = 'dynamic';
```
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
