Return-Path: X-Original-To: apmail-hive-user-archive@www.apache.org Delivered-To: apmail-hive-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 028C6E1E5 for ; Thu, 29 Nov 2012 13:08:29 +0000 (UTC) Received: (qmail 58604 invoked by uid 500); 29 Nov 2012 13:08:27 -0000 Delivered-To: apmail-hive-user-archive@hive.apache.org Received: (qmail 58477 invoked by uid 500); 29 Nov 2012 13:08:27 -0000 Mailing-List: contact user-help@hive.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@hive.apache.org Delivered-To: mailing list user@hive.apache.org Received: (qmail 58449 invoked by uid 99); 29 Nov 2012 13:08:26 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 29 Nov 2012 13:08:26 +0000 X-ASF-Spam-Status: No, hits=2.5 required=5.0 tests=FREEMAIL_REPLY,HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of edlinuxguru@gmail.com designates 209.85.223.176 as permitted sender) Received: from [209.85.223.176] (HELO mail-ie0-f176.google.com) (209.85.223.176) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 29 Nov 2012 13:08:19 +0000 Received: by mail-ie0-f176.google.com with SMTP id 13so17463734iea.35 for ; Thu, 29 Nov 2012 05:07:58 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type; bh=MMAAUcPX/7B7B4Oj7KDZ3Ktlao0E01GYbM9dFDPAIAA=; b=S+tXelzEv6w1OJmv5Aa2Lfg4CqScGGWOiHQoaBnAYbVgJzP6FbAJIJ4KlLogMOmxQE Srnhg9oFjq0oxm+PQ9Q9tRABDlA4Di2Vi7WR9X69shg6wlUjA8DKCifQ44N0wwqL7K7L mjvstpFSE4pd6TwDEeN4+z4HYziAkDef2WrVjUP0fgqfe+GX8IL1uH7/sPWxIBYs8Vml ejSI1K4tAfRg7+Ov8mU8zfpt2rGKPFJq7g8+HlIKtxw4eGmnuAzqeJ2b01d24kKkXOi9 ouP9Zqe3S919dDv0m3oJqrnCK9NfxU02EargtBSi8rVPrr+Hq6JhDZA4fPxszJthepNK 46Fw== MIME-Version: 1.0 Received: by 10.50.6.169 with SMTP id c9mr22884261iga.24.1354194462831; Thu, 29 Nov 2012 05:07:42 -0800 (PST) Received: by 10.64.97.106 with HTTP; Thu, 29 Nov 2012 05:07:42 -0800 (PST) In-Reply-To: References: <026833C91E2A1146B97EF8B717408EDF2EA7E39E@szxeml534-mbs.china.huawei.com> <026833C91E2A1146B97EF8B717408EDF2EA7F3D1@szxeml534-mbs.china.huawei.com> Date: Thu, 29 Nov 2012 08:07:42 -0500 Message-ID: Subject: Re: is Hive support TTL(time to live) now ? From: Edward Capriolo To: "user@hive.apache.org" Cc: "Zhaojun (Terry)" Content-Type: multipart/alternative; boundary=e89a8f646717e9f46304cfa1f7ac X-Virus-Checked: Checked by ClamAV on apache.org --e89a8f646717e9f46304cfa1f7ac Content-Type: text/plain; charset=ISO-8859-1 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 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 > > --e89a8f646717e9f46304cfa1f7ac Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable
their is a table level property retention it does not do anything but y= ou 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 <nitinpawar432@g= mail.com> wrote:
> hive will not delete anything unless you ask for it
> if your ta= bles 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 complet= e tables, you will need to schedule crons or look at few workflow engines= =A0
> I may be wrong but I never saw anything got auto deleted in hive unles= s asked to be deleted manually=A0
>
> On Thu, Nov 29, 2012 at 5= :27 PM, Hezhiqiang (Ransom) <ransom.hezhiqiang@huawei.com> wrote:
>>
>> Hi Nitin
>>
>> =A0
>>
&g= t;> =A0=A0=A0=A0=A0=A0=A0=A0 TTL for =A0data alive in hive.
>><= br>>> =A0=A0=A0=A0=A0=A0=A0=A0 Can hive automatically delete data whe= n out of date?
>>
>> =A0
>>
>> Regards
>>
>> Ransom
>>
= >> =A0
>>
>> From: Nitin Pawar [mailto:nitinpawar432@gmail.com]
>> Sen= t: Thursday, November 29, 2012 7:53 PM
>> To: user@hive.apache.org
>> Cc: Zhouxunmiao; Zhangjian (Jack); Zhaojun (Terry)
>&g= t; Subject: Re: is Hive support TTL(time to live) now ?
>>
>= > =A0
>>
>> TTL for what ?=A0
>>
>> =A0
>&= gt;
>> for hive queries or hive over thrift or anything else you h= ave in mind?=A0
>>
>> =A0
>>
>> for que= ry execution they can run by default till the time map-reduce runs.=A0
>>
>> =A0
>>
>> On Thu, Nov 29, 2012 at 5:= 09 PM, Hezhiqiang (Ransom) <ransom.hezhiqiang@huawei.com> wrote:
>>
>> Hi = all
>> =A0 =A0 =A0 =A0 Is Hive support TTL(time to live) now?
>>= =A0 =A0 =A0 =A0 I search in JIRA but can't found it , is hive support = it?
>>
>> Regards
>> Ransom
>>
>&= gt; =A0
>>
>> --
>> Nitin Pawar
>
>
> --
> Niti= n Pawar
>
> --e89a8f646717e9f46304cfa1f7ac--