You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hive.apache.org by "Hezhiqiang (Ransom)" <ra...@huawei.com> on 2012/11/29 12:39:33 UTC
is Hive support TTL(time to live) now ?
Hi all
Is Hive support TTL(time to live) now?
I search in JIRA but can't found it , is hive support it?
Regards
Ransom
Re: is Hive support TTL(time to live) now ?
Posted by Edward Capriolo <ed...@gmail.com>.
their is a table level property retention it does not do anything but you
can write a program to sweep through the metastore and take action based on
that or other custom properties.
On Thursday, November 29, 2012, Nitin Pawar <ni...@gmail.com> wrote:
> hive will not delete anything unless you ask for it
> if your tables are on hdfs tmp folder, hadoop will wipe them off if you
dont use them for the tmp time period. If you want to delete data from
tables or complete tables, you will need to schedule crons or look at few
workflow engines
> I may be wrong but I never saw anything got auto deleted in hive unless
asked to be deleted manually
>
> On Thu, Nov 29, 2012 at 5:27 PM, Hezhiqiang (Ransom) <
ransom.hezhiqiang@huawei.com> wrote:
>>
>> Hi Nitin
>>
>>
>>
>> TTL for data alive in hive.
>>
>> Can hive automatically delete data when out of date?
>>
>>
>>
>> Regards
>>
>> Ransom
>>
>>
>>
>> From: Nitin Pawar [mailto:nitinpawar432@gmail.com]
>> Sent: Thursday, November 29, 2012 7:53 PM
>> To: user@hive.apache.org
>> Cc: Zhouxunmiao; Zhangjian (Jack); Zhaojun (Terry)
>> Subject: Re: is Hive support TTL(time to live) now ?
>>
>>
>>
>> TTL for what ?
>>
>>
>>
>> for hive queries or hive over thrift or anything else you have in mind?
>>
>>
>>
>> for query execution they can run by default till the time map-reduce
runs.
>>
>>
>>
>> On Thu, Nov 29, 2012 at 5:09 PM, Hezhiqiang (Ransom) <
ransom.hezhiqiang@huawei.com> wrote:
>>
>> Hi all
>> Is Hive support TTL(time to live) now?
>> I search in JIRA but can't found it , is hive support it?
>>
>> Regards
>> Ransom
>>
>>
>>
>> --
>> Nitin Pawar
>
>
> --
> Nitin Pawar
>
>
Re: is Hive support TTL(time to live) now ?
Posted by Nitin Pawar <ni...@gmail.com>.
hive will not delete anything unless you ask for it
if your tables are on hdfs tmp folder, hadoop will wipe them off if you
dont use them for the tmp time period. If you want to delete data from
tables or complete tables, you will need to schedule crons or look at few
workflow engines
I may be wrong but I never saw anything got auto deleted in hive unless
asked to be deleted manually
On Thu, Nov 29, 2012 at 5:27 PM, Hezhiqiang (Ransom) <
ransom.hezhiqiang@huawei.com> wrote:
> Hi Nitin****
>
> ** **
>
> TTL for data alive in hive.****
>
> Can hive automatically delete data when out of date? ****
>
> ** **
>
> Regards****
>
> Ransom****
>
> ** **
>
> *From:* Nitin Pawar [mailto:nitinpawar432@gmail.com]
> *Sent:* Thursday, November 29, 2012 7:53 PM
> *To:* user@hive.apache.org
> *Cc:* Zhouxunmiao; Zhangjian (Jack); Zhaojun (Terry)
> *Subject:* Re: is Hive support TTL(time to live) now ?****
>
> ** **
>
> TTL for what ? ****
>
> ** **
>
> for hive queries or hive over thrift or anything else you have in mind? **
> **
>
> ** **
>
> for query execution they can run by default till the time map-reduce runs.
> ****
>
> ** **
>
> On Thu, Nov 29, 2012 at 5:09 PM, Hezhiqiang (Ransom) <
> ransom.hezhiqiang@huawei.com> wrote:****
>
> Hi all
> Is Hive support TTL(time to live) now?
> I search in JIRA but can't found it , is hive support it?
>
> Regards
> Ransom****
>
>
>
> ****
>
> ** **
>
> --
> Nitin Pawar****
>
--
Nitin Pawar
RE: is Hive support TTL(time to live) now ?
Posted by "Hezhiqiang (Ransom)" <ra...@huawei.com>.
Hi Nitin
TTL for data alive in hive.
Can hive automatically delete data when out of date?
Regards
Ransom
From: Nitin Pawar [mailto:nitinpawar432@gmail.com]
Sent: Thursday, November 29, 2012 7:53 PM
To: user@hive.apache.org
Cc: Zhouxunmiao; Zhangjian (Jack); Zhaojun (Terry)
Subject: Re: is Hive support TTL(time to live) now ?
TTL for what ?
for hive queries or hive over thrift or anything else you have in mind?
for query execution they can run by default till the time map-reduce runs.
On Thu, Nov 29, 2012 at 5:09 PM, Hezhiqiang (Ransom) <ra...@huawei.com>> wrote:
Hi all
Is Hive support TTL(time to live) now?
I search in JIRA but can't found it , is hive support it?
Regards
Ransom
--
Nitin Pawar
Re: is Hive support TTL(time to live) now ?
Posted by Nitin Pawar <ni...@gmail.com>.
TTL for what ?
for hive queries or hive over thrift or anything else you have in mind?
for query execution they can run by default till the time map-reduce runs.
On Thu, Nov 29, 2012 at 5:09 PM, Hezhiqiang (Ransom) <
ransom.hezhiqiang@huawei.com> wrote:
> Hi all
> Is Hive support TTL(time to live) now?
> I search in JIRA but can't found it , is hive support it?
>
> Regards
> Ransom
>
>
--
Nitin Pawar