You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@phoenix.apache.org by Rafit Izhak-Ratzin <ra...@robinsystems.com> on 2016/02/29 06:49:36 UTC

Can't change ttl of a table using "alter table", get a cache older version warning

Hi all,

I am looking for a way to change the ttl of a table that already exists.
I ran the command below and got the warning message shown below:

0: jdbc:phoenix:localhost> alter table INSTANCE_CPU set ttl=86600;
16/02/28 21:39:40 INFO client.HConnectionManager$HConnectionImplementation:
Closing master protocol: MasterService
16/02/28 21:39:40 INFO client.HConnectionManager$HConnectionImplementation:
Closing zookeeper sessionid=0x1532b79a8260087
16/02/28 21:39:40 WARN query.ConnectionQueryServicesImpl: Attempt to cache
older version of INSTANCE_CPU: current= 0, new=0
No rows affected (6.63 seconds)

My environment: Phoenix version 4.5, Hbase version 0.98

Is there anyway to fix this?
is there any other way to change the TTL of a table?

Thank you in advance,
--Rafit