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

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) <
[EMAIL PROTECTED]> 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

Hi Nitin

         TTL for  data alive in hive.
         Can hive automatically delete data when out of date?

Regards
Ransom

From: Nitin Pawar [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 29, 2012 7:53 PM
To: [EMAIL PROTECTED]
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) <[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>> 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

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) <
[EMAIL PROTECTED]> wrote:

>  Hi Nitin****
>
> ** **
>
>          TTL for  data alive in hive.****
>
>          Can hive automatically delete data when out of date? ****
>
> ** **
>
> Regards****
>
> Ransom****
>
> ** **
>
> *From:* Nitin Pawar [mailto:[EMAIL PROTECTED]]
> *Sent:* Thursday, November 29, 2012 7:53 PM
> *To:* [EMAIL PROTECTED]
> *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) <
> [EMAIL PROTECTED]> 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

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 <[EMAIL PROTECTED]> 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) <
[EMAIL PROTECTED]> wrote:
>>
>> Hi Nitin
>>
>>
>>
>>          TTL for  data alive in hive.
>>
>>          Can hive automatically delete data when out of date?
>>
>>
>>
>> Regards
>>
>> Ransom
>>
>>
>>
>> From: Nitin Pawar [mailto:[EMAIL PROTECTED]]
>> Sent: Thursday, November 29, 2012 7:53 PM
>> To: [EMAIL PROTECTED]
>> 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) <
[EMAIL PROTECTED]> 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
>
>