[
https://issues.apache.org/jira/browse/PHOENIX-1240?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14244924#comment-14244924
]
Alicia Ying Shu edited comment on PHOENIX-1240 at 12/12/14 10:48 PM:
---------------------------------------------------------------------
[~giacomotaylor] Thanks for the suggestions. Just to confirm.
1)
ALTER TABLE set_ttl_test SET b.TTL=30;
ALTER TABLE set_ttl_test SET TTL=100;
If there are four cfs a,b,c d, after the 2nd sql, all four of the cfs' TTL will
be 100 sec.
2)
ALTER TABLE set_ttl_test SET TTL=30;
ALTER TABLE set_ttl_test SET b.TTL=100;
If there are four cfs a,b,c d, after the 2nd sql, b would have TTL of 100, all
the rest three cfs would have TTL of 30 sec.
3)
CREATE TABLE T1 (ID1 VARCHAR(15) NOT NULL,
ID2 VARCHAR(15) NOT NULL,
CREATED_DATE DATE,
CONSTRAINT PK PRIMARY KEY (ID1, ID2)) SALT_BUCKETS = 8;
ALTER TABLE T1 SET CF.TTL=86400;
The ALTER TABLE sql would throw exception because "CF" is not defined. We
should only add new column family through ALTER TABLE ADD (column).
was (Author: aliciashu):
Just to confirm.
1)
ALTER TABLE set_ttl_test SET b.TTL=30;
ALTER TABLE set_ttl_test SET TTL=100;
If there are four cfs a,b,c d, after the 2nd sql, all four of the cfs' TTL will
be 100 sec.
2)
ALTER TABLE set_ttl_test SET TTL=30;
ALTER TABLE set_ttl_test SET b.TTL=100;
If there are four cfs a,b,c d, after the 2nd sql, b would have TTL of 100, all
the rest three cfs would have TTL of 30 sec.
3)
CREATE TABLE T1 (ID1 VARCHAR(15) NOT NULL,
ID2 VARCHAR(15) NOT NULL,
CREATED_DATE DATE,
CONSTRAINT PK PRIMARY KEY (ID1, ID2)) SALT_BUCKETS = 8;
ALTER TABLE T1 SET CF.TTL=86400;
The ALTER TABLE sql would throw exception because "CF" is not defined. We
should only add new column family through ALTER TABLE ADD (column).
> Add TTL to SYSTEM.TRACING_STATS table
> -------------------------------------
>
> Key: PHOENIX-1240
> URL: https://issues.apache.org/jira/browse/PHOENIX-1240
> Project: Phoenix
> Issue Type: Sub-task
> Affects Versions: 5.0.0, 4.1.1
> Reporter: Jesse Yates
> Assignee: Alicia Ying Shu
> Fix For: 5.0.0, 4.1.1
>
> Attachments: PHOENIX-1240.patch
>
>
> Tracing table should have a configurable TTL on it, so the table doesn't fill
> up with too much data.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
