phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Alicia Ying Shu (JIRA)" <j...@apache.org>
Subject [jira] [Comment Edited] (PHOENIX-1240) Add TTL to SYSTEM.TRACING_STATS table
Date Fri, 12 Dec 2014 22:49:14 GMT

    [ 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)

Mime
View raw message