Re: How to get the creation time of a HTable?

2015-08-14 Thread ShaoFeng Shi
We have method to identify which tables will not receive read/write
requests; But to be safe, we will exclude the tables that newly created (as
they might be under creating), say in latest 2 days; If Hbase doesn't have
such metadata, it's okay that we add that during the table creation; But if
it can be implemented in the future HBase release, that is good for the
users (especially the admins) I think;

Thanks for the answers and comments!

2015-08-14 20:51 GMT+08:00 Ted Yu yuzhih...@gmail.com:

 After predetermined number of days, would your table(s) not receive any
 read / write requests ?

 Have you considered using TTL for cleaning old data ?

 Cheers


  On Aug 14, 2015, at 2:54 AM, ShaoFeng Shi shaofeng...@gmail.com wrote:
 
  Hello the community,
 
  In my case, I want to cleanup the HTables that older than certain days;
 so
  we need to get the table's creation time, is there any API to get this?
 If
  not, I may have to add such an attribute when creating the table;
 
  Thanks for any suggestion;
 
  Shaofeng Shi,
  Apache Kylin



RE: How to get the creation time of a HTable?

2015-08-14 Thread ashish singhi
I think we do not have any such attribute for the table but we can implement 
one like we have for Snapshot.

Regards,
Ashish Singhi

-Original Message-
From: Serega Sheypak [mailto:serega.shey...@gmail.com] 
Sent: 14 August 2015 15:28
To: user
Subject: Re: How to get the creation time of a HTable?

Hm... you can check underlying table catalog on HDFS and see time properties 
there?

2015-08-14 11:54 GMT+02:00 ShaoFeng Shi shaofeng...@gmail.com:

 Hello the community,

 In my case, I want to cleanup the HTables that older than certain 
 days; so we need to get the table's creation time, is there any API to 
 get this? If not, I may have to add such an attribute when creating 
 the table;

 Thanks for any suggestion;

 Shaofeng Shi,
 Apache Kylin



Re: How to get the creation time of a HTable?

2015-08-14 Thread Ted Yu
After predetermined number of days, would your table(s) not receive any read / 
write requests ?

Have you considered using TTL for cleaning old data ?

Cheers


 On Aug 14, 2015, at 2:54 AM, ShaoFeng Shi shaofeng...@gmail.com wrote:
 
 Hello the community,
 
 In my case, I want to cleanup the HTables that older than certain days; so
 we need to get the table's creation time, is there any API to get this? If
 not, I may have to add such an attribute when creating the table;
 
 Thanks for any suggestion;
 
 Shaofeng Shi,
 Apache Kylin


How to get the creation time of a HTable?

2015-08-14 Thread ShaoFeng Shi
Hello the community,

In my case, I want to cleanup the HTables that older than certain days; so
we need to get the table's creation time, is there any API to get this? If
not, I may have to add such an attribute when creating the table;

Thanks for any suggestion;

Shaofeng Shi,
Apache Kylin


Re: How to get the creation time of a HTable?

2015-08-14 Thread Serega Sheypak
Hm... you can check underlying table catalog on HDFS and see time
properties there?

2015-08-14 11:54 GMT+02:00 ShaoFeng Shi shaofeng...@gmail.com:

 Hello the community,

 In my case, I want to cleanup the HTables that older than certain days; so
 we need to get the table's creation time, is there any API to get this? If
 not, I may have to add such an attribute when creating the table;

 Thanks for any suggestion;

 Shaofeng Shi,
 Apache Kylin