[
https://issues.apache.org/jira/browse/PHOENIX-2778?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Powpow Shen updated PHOENIX-2778:
---------------------------------
Description:
Say we create "test" table with schema below:
{quote}
create table "test" ("id" INTEGER not null primary key, "staticColumn" VARCHAR);
{quote}
search can be done by specifying dynamic columns:
{quote}
select * from "test"("dynamicColumn" VARCHAR) where "dynamicColumn" =
'dynamic';
{quote}
but delete can only done by specifying static columns:
{quote}
delete from "test" where "staticColumn" = 'static';
{quote}
NOT by specifying dynamic columns:
{quote}
delete from "test"("dynamicColumn" VARCHAR) where "dynamicColumn" = 'dynamic';
{quote}
was:
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';
```
> 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:
> {quote}
> create table "test" ("id" INTEGER not null primary key, "staticColumn"
> VARCHAR);
> {quote}
> search can be done by specifying dynamic columns:
> {quote}
> select * from "test"("dynamicColumn" VARCHAR) where "dynamicColumn" =
> 'dynamic';
> {quote}
> but delete can only done by specifying static columns:
> {quote}
> delete from "test" where "staticColumn" = 'static';
> {quote}
> NOT by specifying dynamic columns:
> {quote}
> delete from "test"("dynamicColumn" VARCHAR) where "dynamicColumn" = 'dynamic';
> {quote}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
