Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cassandra.apache.org
Received-SPF: pass (athena.apache.org: domain of Andreas.Finke@solvians.com
 designates 193.239.19.161 as permitted sender)
From: Andreas Finke <Andreas.Finke@solvians.com>
To: "user@cassandra.apache.org" <user@cassandra.apache.org>
Subject: RE: Compacted_at timestamp
Thread-Topic: Compacted_at timestamp
Thread-Index: AQHQQ6IIyjgChJSXc0akGkJeiAMNO5znKyiAgADHroY=
Date: Mon, 9 Feb 2015 07:51:27 +0000
Message-ID: 
 <C21F7E078D739246B3E0EC3FDF8B77927B445CFE@MSEX-01-FRA9.corp.solvians.com>
References: 
 <D0FD601B.90848%santhosh_havereshanmukhappa@intuit.com>,<CAE3+PJM4y-+2k27T8dTkb8xgQUjHiSSpqTQxi+thiozoe-A_Ww@mail.gmail.com>
In-Reply-To: 
 <CAE3+PJM4y-+2k27T8dTkb8xgQUjHiSSpqTQxi+thiozoe-A_Ww@mail.gmail.com>
Accept-Language: en-GB, en-US, de-DE
Content-Language: en-GB
Content-Type: multipart/alternative;
	boundary="_000_C21F7E078D739246B3E0EC3FDF8B77927B445CFEMSEX01FRA9corps_"
MIME-Version: 1.0

--_000_C21F7E078D739246B3E0EC3FDF8B77927B445CFEMSEX01FRA9corps_
Content-Type: text/plain; charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable

I created a small script recently converting this timestamp into a human re=
adable string and sort all entries ascending.

nodetool compactionhistory |awk '{timestamp =3D strftime("%a %b %e %H:%M:%S=
 %Z %Y",$4 / 1000);in_m=3D$5/1024/1024;out_m=3D$6/1024/1024; printf("%s\t%s=
\t%s\t%s\t%dM\t%dM\n",$4,timestamp,$2,$3,in_m,out_m)}' |sort -n

Regards
Andi
________________________________
From: Mark Reddy [mark.l.reddy@gmail.com]
Sent: 08 February 2015 21:55
To: user@cassandra.apache.org
Subject: Re: Compacted_at timestamp

Hi Santo,

If you are seeing the compacted_at value as timestamp and want to convert i=
t to a human readable date, this is not possible via nodetool. You will alw=
ays write a script to make the compactionhistory call and then convert the =
output (the fourth column - compacted_at) to a readable date.

If you are seeing something other than an expected timestamp value, can you=
 post an example of what you are getting?


Regards,
Mark

On 8 February 2015 at 13:20, Havere Shanmukhappa, Santhosh <Santhosh_Havere=
Shanmukhappa@intuit.com<mailto:Santhosh_HavereShanmukhappa@intuit.com>> wro=
te:
When I run nodetool compactionhistory command, it displays =91compacted_at=
=92 timestamp in non-readable format. Any way to read that column in readab=
le format? I am using c*2.0.11 version.

Thanks,
Santo


--_000_C21F7E078D739246B3E0EC3FDF8B77927B445CFEMSEX01FRA9corps_
Content-Type: text/html; charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable

<html dir=3D"ltr">
<head>
<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3DWindows-1=
252">
<style type=3D"text/css" id=3D"owaParaStyle"></style><style type=3D"text/cs=
s"></style>
</head>
<body fpstyle=3D"1" ocsi=3D"0">
<div style=3D"direction: ltr;font-family: Tahoma;color: #000000;font-size: =
10pt;">I created a small script recently converting this timestamp into a h=
uman readable string and sort all entries ascending. &nbsp;
<div><br>
</div>
<div>nodetool compactionhistory |awk '{timestamp =3D strftime(&quot;%a %b %=
e %H:%M:%S %Z %Y&quot;,$4 / 1000);in_m=3D$5/1024/1024;out_m=3D$6/1024/1024;=
 printf(&quot;%s\t%s\t%s\t%s\t%dM\t%dM\n&quot;,$4,timestamp,$2,$3,in_m,out_=
m)}' |sort -n</div>
<div><br>
</div>
<div>Regards</div>
<div>Andi<br>
<div style=3D"font-family: Times New Roman; color: #000000; font-size: 16px=
">
<hr tabindex=3D"-1">
<div id=3D"divRpF56835" style=3D"direction: ltr;"><font face=3D"Tahoma" siz=
e=3D"2" color=3D"#000000"><b>From:</b> Mark Reddy [mark.l.reddy@gmail.com]<=
br>
<b>Sent:</b> 08 February 2015 21:55<br>
<b>To:</b> user@cassandra.apache.org<br>
<b>Subject:</b> Re: Compacted_at timestamp<br>
</font><br>
</div>
<div></div>
<div>
<div dir=3D"ltr">Hi&nbsp;Santo,
<div><br>
</div>
<div>If you are seeing the compacted_at value as timestamp and want to conv=
ert it to a human readable date, this is not possible via nodetool. You wil=
l always write a script to make the compactionhistory call and then convert=
 the output (the fourth column -
 compacted_at) to a readable date.</div>
<div><br>
</div>
<div>If you are seeing something other than an expected timestamp value, ca=
n you post an example of what you are getting?&nbsp;</div>
<div><br>
</div>
<div class=3D"gmail_extra"><br clear=3D"all">
<div>
<div class=3D"gmail_signature">Regards,<br>
Mark</div>
</div>
<br>
<div class=3D"gmail_quote">On 8 February 2015 at 13:20, Havere Shanmukhappa=
, Santhosh
<span dir=3D"ltr">&lt;<a href=3D"mailto:Santhosh_HavereShanmukhappa@intuit.=
com" target=3D"_blank">Santhosh_HavereShanmukhappa@intuit.com</a>&gt;</span=
> wrote:<br>
<blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex; border-left:1=
px #ccc solid; padding-left:1ex">
<div style=3D"word-wrap:break-word; color:rgb(0,0,0); font-size:14px; font-=
family:Calibri,sans-serif">
<div>When I run nodetool&nbsp;compactionhistory command, it displays =91com=
pacted_at=92 timestamp in non-readable format. Any way to read that column =
in readable format? I am using c*2.0.11 version.</div>
<div><br>
</div>
<div>Thanks,</div>
<div>Santo</div>
</div>
</blockquote>
</div>
<br>
</div>
</div>
</div>
</div>
</div>
</div>
</body>
</html>

--_000_C21F7E078D739246B3E0EC3FDF8B77927B445CFEMSEX01FRA9corps_--