Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cassandra.apache.org
MIME-Version: 1.0
Sender: burtonator2011@gmail.com
From: Kevin Burton <burton@spinn3r.com>
Date: Tue, 4 Aug 2015 19:22:33 -0700
Message-ID: 
 <CAAZU44n2yTt2KmnsgmWBsE8_xkyNTa+z=HbN2bEm1bu7-RwAog@mail.gmail.com>
Subject: TTLs on tables with *only* primary keys?
To: "user@cassandra.apache.org" <user@cassandra.apache.org>
Content-Type: multipart/alternative; boundary=001a11331030707eba051c871480

--001a11331030707eba051c871480
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

I have a table which just has primary keys.

basically:

create table foo (

    sequence bigint,
    signature text,
    primary key( sequence, signature )
)

I need these to eventually get GCd however it doesn=E2=80=99t seem to work.

If I then run:

select ttl(sequence) from foo;

I get:

Cannot use selection function ttl on PRIMARY KEY part sequence

=E2=80=A6

I get the same thing if I do it on the second column .. (signature).

And the value doesn=E2=80=99t seem to be TTLd.

What=E2=80=99s the best way to proceed here?


--=20

Founder/CEO Spinn3r.com
Location: *San Francisco, CA*
blog: http://burtonator.wordpress.com
=E2=80=A6 or check out my Google+ profile
<https://plus.google.com/102718274791889610666/posts>

--001a11331030707eba051c871480
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">I have a table which just has primary keys.<div><br></div>=
<div>basically:</div><div><br></div><div><div>create table foo (</div><div>=
<br></div><div>=C2=A0 =C2=A0 sequence bigint,</div><div>=C2=A0 =C2=A0 signa=
ture text,</div><div>=C2=A0 =C2=A0 primary key( sequence, signature )</div>=
<div>)</div><div><br></div><div>I need these to eventually get GCd however =
it doesn=E2=80=99t seem to work.</div><div><br></div><div>If I then run:</d=
iv><div><br></div><div>select ttl(sequence) from foo;<br></div><div><br></d=
iv><div>I get:</div><div><br></div><div>Cannot use selection function ttl o=
n PRIMARY KEY part sequence<br></div><div><br></div><div>=E2=80=A6=C2=A0</d=
iv><div><br></div><div>I get the same thing if I do it on the second column=
 .. (signature).</div><div><br></div><div>And the value doesn=E2=80=99t see=
m to be TTLd.</div><div><br></div><div>What=E2=80=99s the best way to proce=
ed here?</div><div><br></div><div><br></div>-- <br><div class=3D"gmail_sign=
ature"><div dir=3D"ltr"><div><div dir=3D"ltr"><div><div><p style=3D"margin-=
top:0px;margin-right:0px;margin-bottom:12pt;margin-left:0px"></p><div>Found=
er/CEO=C2=A0<a href=3D"http://Spinn3r.com" target=3D"_blank">Spinn3r.com</a=
><br></div><div>Location:=C2=A0<b>San Francisco, CA</b><br></div><div><font=
 color=3D"#2c2c2c" face=3D"Helvetica, Arial, sans-serif"><span style=3D"lin=
e-height:19px">blog:<b>=C2=A0</b></span></font><a href=3D"http://burtonator=
.wordpress.com" target=3D"_blank">http://burtonator.wordpress.com</a></div>=
<div>=E2=80=A6 or check out my <a href=3D"https://plus.google.com/102718274=
791889610666/posts" target=3D"_blank">Google+ profile</a></div><div><img><b=
r></div><div></div><p></p></div></div></div></div></div></div>
</div></div>

--001a11331030707eba051c871480--