phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Samarth Jain <samarth.j...@gmail.com>
Subject Re: TTL
Date Wed, 11 Feb 2015 17:58:24 GMT
+1 to what Ralph said.

FWIW, starting with 4.3 (soon to be out) we allow setting HBase properties
like TTL through ALTER TABLE. However, you can't have different TTL for
different column families.


On Wednesday, February 11, 2015, Perko, Ralph J <Ralph.Perko@pnnl.gov>
wrote:

>  That is a great point.  Setting the TTL on the corresponding index
> tables would be necessary as well then, if this approach acceptable.
>
>
>    From: Jean-Marc Spaggiari <jean-marc@spaggiari.org
> <javascript:_e(%7B%7D,'cvml','jean-marc@spaggiari.org');>>
> Reply-To: "user@phoenix.apache.org
> <javascript:_e(%7B%7D,'cvml','user@phoenix.apache.org');>" <
> user@phoenix.apache.org
> <javascript:_e(%7B%7D,'cvml','user@phoenix.apache.org');>>
> Date: Wednesday, February 11, 2015 at 9:34 AM
> To: "user@phoenix.apache.org
> <javascript:_e(%7B%7D,'cvml','user@phoenix.apache.org');>" <
> user@phoenix.apache.org
> <javascript:_e(%7B%7D,'cvml','user@phoenix.apache.org');>>
> Subject: Re: TTL
>
>    Hi Ralph,
>
> Thinking out loud...
>
>  If you have an index on your table, the TTL will remove some data from
> the table but will not clean the references in the index table. So if you
> query using the index, that will return some data which doesn't exist
> anymore on the original table. Therefore you dataset will become
> un-consistent.
>
>  I will let Phoenix experts confirm.
>
> JM
>
> 2015-02-11 12:29 GMT-05:00 Perko, Ralph J <Ralph.Perko@pnnl.gov
> <javascript:_e(%7B%7D,'cvml','Ralph.Perko@pnnl.gov');>>:
>
>>  Hi – I attempted to set the TTL parameter using ALTER TABLE through
>> phoenix and received error 1025: Unsupported property set in ALTER TABLE
>> command
>>
>>  I was, however, able to set this directly through the hbase shell.  Is
>> there any problem with me going this route?
>>
>>  Thanks,
>> Ralph
>>
>>
>

Mime
View raw message