phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Perko, Ralph J" <Ralph.Pe...@pnnl.gov>
Subject Re: TTL
Date Wed, 11 Feb 2015 17:51:09 GMT
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<mailto:jean-marc@spaggiari.org>>
Reply-To: "user@phoenix.apache.org<mailto:user@phoenix.apache.org>" <user@phoenix.apache.org<mailto:user@phoenix.apache.org>>
Date: Wednesday, February 11, 2015 at 9:34 AM
To: "user@phoenix.apache.org<mailto:user@phoenix.apache.org>" <user@phoenix.apache.org<mailto: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<mailto: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