[ 
https://issues.apache.org/jira/browse/PHOENIX-1240?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14223907#comment-14223907
 ] 

Alicia Ying Shu edited comment on PHOENIX-1240 at 11/25/14 1:55 AM:
--------------------------------------------------------------------

Thanks everyone for the comments. Phoenix is a row-based system, it is better 
to expire the whole row rather than a portion of a row. 

The parser takes different parameters for CREATE TABLE and ALTER TABLE. 
CREATE TABLE takes  (p=fam_properties)
ALTER TABLE takes (SET (p=properties))

CREATE table can specify TTL for different column families. ALTER table sets 
TTL for the whole row.


was (Author: aliciashu):
Thanks everyone for the comments. Phoenix is a row-based system, it is better 
to expire the whole row rather than a portion of a row. But to provide 
flexibility, provide a column family TTL should be fine as well. 

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

Reply via email to