Mailing-List: contact user-help@hbase.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@hbase.apache.org
Received-SPF: pass (nike.apache.org: local policy)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
  s=s1024; d=yahoo.com;
  h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-RocketYMMF:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:In-Reply-To:MIME-Version:Content-Type;
  b=09wyPRctEC5xBubTKxgJ0x1D4Fw07lXE7uxESNqvT0JJiiUOkUPkxhxRR+OcSz/LiFzquCmPPSSQlnd+rc7m0ZTqZhyY3zUHR6dJvFo/fDnMy1GJeMFTgbNQHjwv/gBpp6CfrdfkWSU5kQw/Z74siOkJuelCt0CQzQvBbln61PA=;
References: 
 <CANsfGRk2DihjL9-OZiGrcYt2_TdGjxWU01ev5MjHob376M8Phw@mail.gmail.com>
 <CALte62ytCRg+-cdKERWHw4qsgQKkrRSc9ztV8n6T70jwOs=aJg@mail.gmail.com>
 <CANsfGR=o8CYN+0FQMG5eE1f8LqHQ1B1Uz-mwz7PNmsMjn6Rj7Q@mail.gmail.com>
 <CANsfGRm_D0sKR5wLbEgLs0xhUVCrPHOgRmfdME9Pvu+QK4sLOg@mail.gmail.com>
Message-ID: <1365044851.91652.YahooMailNeo@web140605.mail.bf1.yahoo.com>
Date: Wed, 3 Apr 2013 20:07:31 -0700 (PDT)
From: lars hofhansl <larsh@apache.org>
Reply-To: lars hofhansl <larsh@apache.org>
Subject: Re: HBase Column Family TTL and cell deletions
To: "dev@hbase.apache.org" <dev@hbase.apache.org>,
  "user@hbase.apache.org" <user@hbase.apache.org>
In-Reply-To: 
 <CANsfGRm_D0sKR5wLbEgLs0xhUVCrPHOgRmfdME9Pvu+QK4sLOg@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative;
 boundary="1254654340-1023201483-1365044851=:91652"

--1254654340-1023201483-1365044851=:91652
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

1364928886015 is Tue Apr 02 11:54:46 PDT 2013, no?=0ASo it's less than a da=
y old.=0A=0A(Sorry if I am missing something)=0A=0A=0A-- Lars=0A=0A=0A=0A__=
______________________________=0A From: Ashish Nigam <ashnigamtech@gmail.co=
m>=0ATo: user@hbase.apache.org; dev@hbase.apache.org =0ASent: Wednesday, Ap=
ril 3, 2013 3:19 PM=0ASubject: Re: HBase Column Family TTL and cell deletio=
ns=0A =0AAny thoughts?=0A=0AHere's one cell that should have been deleted (=
 I am putting HBase get=0Arepines in shell)=0A=0Ahbase(main):001:0> get 'se=
rvice_counters','3141',{COLUMN =3D>=0A'stats-hourly:2013032014-C-U-4092276'=
}=0A13/04/03 21:57:17 WARN util.NativeCodeLoader: Unable to load native-had=
oop=0Alibrary for your platform... using builtin-java classes where applica=
ble=0ACOLUMN=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0=
 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 CELL=0A=0A=0A=0A=
=0Astats-hourly:2013032014-C-U-4092276=0Atimestamp=3D1364928886015, value=
=3D\x00\x00\x00\x00\x00\x00\x00\x06=0A=0A=0A=0A1 row(s) in 0.1040 seconds=
=0A=0A=0AOn Wed, Apr 3, 2013 at 12:03 PM, Ashish Nigam <ashnigamtech@gmail.=
com>wrote:=0A=0A> minVersion is set to 0=0A> Here's detailed info on this C=
F -=0A>=0A> {NAME =3D> 'stats-hourly', DATA_BLOCK_ENCODING =3D> 'NONE', BLO=
OMFILTER =3D>=0A> 'NONE', REPLICATION_SCOPE =3D> '0', VERSIONS =3D> '3', CO=
MPRESSION =3D> 'LZO',=0A> MIN_VERSIONS =3D> '0', TTL =3D> '604800', KEEP_DE=
LETED_CELLS =3D> 'false',=0A> BLOCKSIZE =3D> '65536', IN_MEMORY =3D> 'false=
', ENCODE_ON_DISK =3D> 'true',=0A> BLOCKCACHE =3D> 'true'}=0A>=0A> HBase ve=
rsion is 0.94.2-cdh4.2.0,=0A>=0A>=0A>=0A> On Wed, Apr 3, 2013 at 11:48 AM, =
Ted Yu <yuzhihong@gmail.com> wrote:=0A>=0A>> Is it possible that minVersion=
s was set for your column family ?=0A>>=0A>> What version of HBase are you =
using ?=0A>>=0A>> Thanks=0A>>=0A>>=0A>> On Wed, Apr 3, 2013 at 11:34 AM, As=
hish Nigam <ashnigamtech@gmail.com=0A>> >wrote:=0A>>=0A>> > Hi,=0A>> > I ha=
ve a table "service_counters" that has service id as row id.=0A>> > There i=
s a column family "stats-hourly" that stores counters related to=0A>> > tha=
t service per hour.=0A>> > I have set TTL to be 7 days for the column famil=
y.=0A>> >=0A>> > {NAME =3D> 'service_counters', FAMILIES =3D> [{NAME =3D> '=
stats-hourly',=0A>> > COMPRESSION =3D> 'LZO', TTL =3D> '604800'}]}=0A>> >=
=0A>> > Now the problem is that I still see columns that are more than 7 da=
ys=0A>> old.=0A>> > I have also run major compactions but I still see old r=
ows.=0A>> > Any pointers as to why these columns are not being deleted?=0A>=
> >=0A>> > Thanks=0A>> > Ashish=0A>> >=0A>>=0A>=0A>
--1254654340-1023201483-1365044851=:91652--