Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cassandra.apache.org
From: Jeff Jirsa <Jeff.Jirsa@crowdstrike.com>
To: "user@cassandra.apache.org" <user@cassandra.apache.org>, "yhqruc@sina.com"
	<yhqruc@sina.com>
Subject: Re: What's the format of Cassandra's timestamp, microsecond or
 millisecond?
Thread-Topic: What's the format of Cassandra's timestamp, microsecond or
 millisecond?
Thread-Index: AQHQ0y8qfSeTN3L2a0e6HLCg8QlSb54FZPWA
Date: Mon, 10 Aug 2015 16:00:23 +0000
Message-ID: <F36C3DCE-F12A-4B8B-A7CA-F6B302C1A511@crowdstrike.com>
References: <20150810054009.E391845EE81@webmail.sinamail.sina.com.cn>
In-Reply-To: <20150810054009.E391845EE81@webmail.sinamail.sina.com.cn>
Accept-Language: en-US
Content-Language: en-US
Content-Type: multipart/signed; protocol="application/pkcs7-signature";
	micalg=sha256; boundary="B_3522042024_1382594012"
MIME-Version: 1.0

--B_3522042024_1382594012
Content-type: multipart/alternative;
	boundary="B_3522042023_849218036"


--B_3522042023_849218036
Content-type: text/plain;
	charset="UTF-8"
Content-transfer-encoding: quoted-printable

The timestamp is arbitrary precision, selected by the client. If you=E2=80=99re s=
eeing milliseconds on some data and microseconds on others, then you have on=
e client that=E2=80=99s using microseconds and another on milliseconds =E2=80=93 adjust =
your clients.


From:  "yhqruc@sina.com"
Reply-To:  "user@cassandra.apache.org", "yhqruc@sina.com"
Date:  Sunday, August 9, 2015 at 10:40 PM
To:  user
Subject:  What's the format of Cassandra's timestamp, microsecond or millis=
econd?

Hi, All:

    When I use cassandra.thrift API to manipulate the data, the timestamp i=
s in millisecond. It can be verified in cli:

[default@ks_wwapp] get cf_user['100031'];
=3D> (super_column=3D01#uid#,

     (name=3D0#d#, value=3Dbf86010000000000, timestamp=3D1438689394196))


   When I use cli to set a column, the timestamp is in microseconds. Such a=
s:

[default@ks_wwapp] get cf_user['100049'];
=3D> (super_column=3Dsc_name,

     (name=3Dc_name, value=3D635f76616c7565, timestamp=3D1439184495344000))


Now, I can't use cassandra.thrift API to update the key 100049.=20

What's wrong with cassandra?


Thanks!


--B_3522042023_849218036
Content-type: text/html;
	charset="UTF-8"
Content-transfer-encoding: quoted-printable

<html><head></head><body style=3D"word-wrap: break-word; -webkit-nbsp-mode: s=
pace; -webkit-line-break: after-white-space; color: rgb(0, 0, 0); font-size:=
 14px; font-family: Calibri, sans-serif;"><div><div><div>The timestamp is ar=
bitrary precision, selected by the client. If you&#8217;re seeing millisecon=
ds on some data and microseconds on others, then you have one client that&#8=
217;s using microseconds and another on milliseconds &#8211; adjust your cli=
ents.</div><div><br></div><div><br></div><div><div id=3D"MAC_OUTLOOK_SIGNATURE=
"></div></div></div></div><div><br></div><span id=3D"OLK_SRC_BODY_SECTION"><di=
v style=3D"font-family:Calibri; font-size:12pt; text-align:left; color:black; =
BORDER-BOTTOM: medium none; BORDER-LEFT: medium none; PADDING-BOTTOM: 0in; P=
ADDING-LEFT: 0in; PADDING-RIGHT: 0in; BORDER-TOP: #b5c4df 1pt solid; BORDER-=
RIGHT: medium none; PADDING-TOP: 3pt"><span style=3D"font-weight:bold">From: <=
/span> "<a href=3D"mailto:yhqruc@sina.com">yhqruc@sina.com</a>"<br><span style=
=3D"font-weight:bold">Reply-To: </span> "<a href=3D"mailto:user@cassandra.apache=
.org">user@cassandra.apache.org</a>", "<a href=3D"mailto:yhqruc@sina.com">yhqr=
uc@sina.com</a>"<br><span style=3D"font-weight:bold">Date: </span> Sunday, Aug=
ust 9, 2015 at 10:40 PM<br><span style=3D"font-weight:bold">To: </span> user<b=
r><span style=3D"font-weight:bold">Subject: </span> What's the format of Cassa=
ndra's timestamp, microsecond or millisecond?<br></div><div><br></div><div><=
meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Dutf-8"><div><p>Hi=
, All:</p><p>&nbsp;&nbsp;&nbsp; When I use cassandra.thrift API to manipulat=
e the data, the timestamp is in millisecond. It can be verified in cli:</p><=
p>[default@ks_wwapp] get cf_user['100031'];<br>
=3D&gt; (super_column=3D01#uid#,<br></p><p>&nbsp;&nbsp;&nbsp;&nbsp; (name=3D0#d#,=
 value=3Dbf86010000000000, timestamp=3D<font color=3D"#cc0000">1438689394196</font=
>))</p><p><br></p><p>&nbsp;&nbsp; When I use cli to set a column, the timest=
amp is in microseconds. Such as:</p><p>[default@ks_wwapp] get cf_user['10004=
9'];<br>
=3D&gt; (super_column=3Dsc_name,<br></p><p>&nbsp;&nbsp;&nbsp;&nbsp; (name=3Dc_nam=
e, value=3D635f76616c7565, timestamp=3D<font color=3D"#cc0000"><span style=3D"backgr=
ound-color: rgb(255, 255, 255);">1439184495344000</span></font>))</p><p><br>=
</p><p>Now, I can't use cassandra.thrift API to update the key 100049. <br><=
/p><p>What's wrong with cassandra?</p><p><br></p><p>Thanks!<br></p><p><br></=
p></div></div></span></body></html>

--B_3522042023_849218036--

--B_3522042024_1382594012
Content-Type: application/pkcs7-signature; name="smime.p7s"
Content-Transfer-Encoding: base64
Content-Disposition: attachment; filename="smime.p7s"

MIISYAYJKoZIhvcNAQcCoIISUTCCEk0CAQExDzANBglghkgBZQMEAgEFADALBgkqhkiG9w0B
BwGggg8wMIIJlTCCB32gAwIBAgIKJGjoIQAAAAACYjANBgkqhkiG9w0BAQsFADBQMRMwEQYK
CZImiZPyLGQBGRYDc3lzMRswGQYKCZImiZPyLGQBGRYLY3Jvd2RzdHJpa2UxHDAaBgNVBAMT
E2Nyb3dkc3RyaWtlLVJPT1QtQ0EwHhcNMTUwNTE4MTcwNTU4WhcNMjMwNTE2MTcwNTU4WjCB
nTETMBEGCgmSJomT8ixkARkWA3N5czEbMBkGCgmSJomT8ixkARkWC2Nyb3dkc3RyaWtlMRAw
DgYDVQQLEwdDU1VzZXJzMRQwEgYDVQQLEwtFbmdpbmVlcmluZzEWMBQGA1UEAxMNSmVmZiBS
LiBKaXJzYTEpMCcGCSqGSIb3DQEJARYaSmVmZi5KaXJzYUBjcm93ZHN0cmlrZS5jb20wggIi
MA0GCSqGSIb3DQEBAQUAA4ICDwAwggIKAoICAQDz/juPunY45nC7cetdyhafX455PB0ps4zm
rZ/jR7NZfNWK11qq4CsWu9Agifcx7KlsmWSjn1EMopttM8axhSpgZOEKaiKSUI7NkihHKcpd
ITBmx3XyhU2Dj5wBoftLbp54W+6AC5NYmsrlsqb1sw9CbRQRiALR+amfwzeZZOTKIpl2MYUJ
0qGkikpcl1wGQ1pXZYM4Bi3fa36IACgzgosONucxKMF9uOX8MUYaxdcU2wOpxvh3P4xw/CHO
SQJsTaijjLDz+cZ7osYZmBlLdbHN2A55JxzMYlbNEb7xuOp7e3ooV8TV5I7LaD6ewPqu3B9Y
nJnXoF+rNuf14D1tZWnT6BUBHIxNk1OTloOihowRaItAsSCUoY+KkRSFPWfwEOUEiynoSCUa
gwyqIov+QP/KsGUf1J22yajmH9zexvkqoLohN56qhrAa+v3fZF0UyGk5V+EKeK4zxfu7tFwH
Y9KJOPIl9jN5EBRiEpbe+j+6w8FO6+hOf3Pmr2R/IbQl9AP+saDqHGrCJrOUHZnNx+9YZ1pU
TvUd/3qgQODgO28z/XqXmqqXefiwiqT9Ubmoiz7T//u069y3zquTD3PKoRnJLJuV4UIfnEdP
HBIpClo9OQ2iz3CPGen+eTZprtaOlM926uweNTwDdsrjX3KiV2+bqLoLcAT2lzAFv1pSHp7O
kQIDAQABo4IEITCCBB0wDgYDVR0PAQH/BAQDAgWgMD4GCSsGAQQBgjcVBwQxMC8GJysGAQQB
gjcVCITk0CKH/Pdpg9mDAoHlqxCG+PJlgW6Gi7JugryReAIBZAIBFTCBlAYJKoZIhvcNAQkP
BIGGMIGDMA4GCCqGSIb3DQMCAgIAgDAOBggqhkiG9w0DBAICAIAwBwYFKw4DAgcwCgYIKoZI
hvcNAwcwCwYJYIZIAWUDBAEqMAsGCWCGSAFlAwQBLTALBglghkgBZQMEARYwCwYJYIZIAWUD
BAEZMAsGCWCGSAFlAwQBAjALBglghkgBZQMEAQUwHQYDVR0OBBYEFFeyMg1s94zEmeUrFyUT
1gtu/8mqMB8GA1UdIwQYMBaAFAnL7V4xGc1Nowmrlmwbj20X638YMIIBEwYDVR0fBIIBCjCC
AQYwggECoIH/oIH8hoG6bGRhcDovLy9DTj1jcm93ZHN0cmlrZS1ST09ULUNBLENOPWRjMSxD
Tj1DRFAsQ049UHVibGljJTIwS2V5JTIwU2VydmljZXMsQ049U2VydmljZXMsQ049Q29uZmln
dXJhdGlvbixEQz1jcm93ZHN0cmlrZSxEQz1zeXM/Y2VydGlmaWNhdGVSZXZvY2F0aW9uTGlz
dD9iYXNlP29iamVjdENsYXNzPWNSTERpc3RyaWJ1dGlvblBvaW50hj1odHRwOi8vZGMxLmNy
b3dkc3RyaWtlLnN5cy9DZXJ0RW5yb2xsL2Nyb3dkc3RyaWtlLVJPT1QtQ0EuY3JsMIIBKgYI
KwYBBQUHAQEEggEcMIIBGDCBtgYIKwYBBQUHMAKGgalsZGFwOi8vL0NOPWNyb3dkc3RyaWtl
LVJPT1QtQ0EsQ049QUlBLENOPVB1YmxpYyUyMEtleSUyMFNlcnZpY2VzLENOPVNlcnZpY2Vz
LENOPUNvbmZpZ3VyYXRpb24sREM9Y3Jvd2RzdHJpa2UsREM9c3lzP2NBQ2VydGlmaWNhdGU/
YmFzZT9vYmplY3RDbGFzcz1jZXJ0aWZpY2F0aW9uQXV0aG9yaXR5MF0GCCsGAQUFBzABhlFo
dHRwOi8vZGMxLmNyb3dkc3RyaWtlLnN5cy9DZXJ0RW5yb2xsL2RjMS5jcm93ZHN0cmlrZS5z
eXNfY3Jvd2RzdHJpa2UtUk9PVC1DQS5jcnQwKQYDVR0lBCIwIAYIKwYBBQUHAwIGCCsGAQUF
BwMEBgorBgEEAYI3CgMEMDUGCSsGAQQBgjcVCgQoMCYwCgYIKwYBBQUHAwIwCgYIKwYBBQUH
AwQwDAYKKwYBBAGCNwoDBDBNBgNVHREERjBEoCYGCisGAQQBgjcUAgOgGAwWamppcnNhQGNy
b3dkc3RyaWtlLnN5c4EaSmVmZi5KaXJzYUBjcm93ZHN0cmlrZS5jb20wDQYJKoZIhvcNAQEL
BQADggIBAIso1nTlfRcS3oWoWZ6gtjY0AH91GZpWft+O2kWxDUqzrmfmF+9swJXrk462v/m9
KAUxuch4mLC7j4tQ4FyNV64FZe+tU1fcNlg4wLIOjSoMykjx85sFbzh64YIpbpiX+8dqc/pF
h6YcUU4PUgz7CZ0Q79J6bomV0EP94QUTN1AYLAYQ4xaPyLkO2DCtTiQ5Kef8jnNnrEYzZT62
OdljvhdGdV/VDMHAPr4yRPGgRou4Gf0cWsQNCav0RMEHPyJsgpXFCacLCCpvonXQoLMnClYT
CVf7fWXdR+UtEpjssNMO2icJXNLarC7ngON7nzsqJKs40eKeAlKHlKXC620fCDbn6Icyodwd
w32rkZDann2NAbrf8y2ArrXObRky1h/t8LDhkz/Yvvd5ndsKfQfciyCwIKBIcIgodR4MWobN
qJzFIV5P/H/QGM8QLBdOwqEgwfqJjovgosxDXjb/aLbEuyCxgSTjZP6yv+90MFfs8ojV+0o2
Ir3q/H24u42nCD4gpGtb/+X16O1FV65QYlDPQyOomLnxBiuRji9BrazPvU4yIsHpJsZ5iTvG
AvddQXQM4P7fNh+3esHBbvEwadPTOpUi/IfjQFsdDDaQw2QX6TjD5qT9vKimX2BpZmJIPvhi
9xXnmae7etpkBJ1Xrc8ysgpBRcZ0aKI4nyYmtGqNoov9MIIFkzCCA3ugAwIBAgIQHHI69IfK
ebRHYrS5//qdkTANBgkqhkiG9w0BAQsFADBQMRMwEQYKCZImiZPyLGQBGRYDc3lzMRswGQYK
CZImiZPyLGQBGRYLY3Jvd2RzdHJpa2UxHDAaBgNVBAMTE2Nyb3dkc3RyaWtlLVJPT1QtQ0Ew
HhcNMTIwMzE4MDA1NjU4WhcNMzIwMzE4MDEwNjU0WjBQMRMwEQYKCZImiZPyLGQBGRYDc3lz
MRswGQYKCZImiZPyLGQBGRYLY3Jvd2RzdHJpa2UxHDAaBgNVBAMTE2Nyb3dkc3RyaWtlLVJP
T1QtQ0EwggIiMA0GCSqGSIb3DQEBAQUAA4ICDwAwggIKAoICAQCqrDGWg7do3ZjG04CVNLL6
voCUzmip/CbqyuCBAF3XNHjLsQnIhqQ+4sYkvozZVvR0CG3rvSe4YbSzOcHTsmK5bPiatuXB
iUBO8rwHm5tzMUnjGk+XomeOGJzwemYsGIDJupLekvSrcm9dXX4H+GK97J42EkM8UAzsAGwn
7qpWo/bPrn7AM8kdua7DVbZbeJXjoid1NzFG4gjwdmtOtcwBx3DCs7io7C/R5Aep5APq4nmT
gA7/whOpkxtThZCqiG8QprBRAktnmS2gMn3Kw1O0amPHtJr/O6FldgoK6Dkb9hKDftVFX9Te
D7AlOVaZfltscXksnPxFBP0A6Bjw92hqR6QzRDqcWO+v1kswkd01jRrPPc410scWN7vX2QHv
kCku8APiSIOGAvaLS/EtzcmjeJhCgkC6HVt5gjXXJBOMq9C2g82s8UiUnhj7D5/loaZffTyY
5y9mnZaxMbJavjmRV/vj0/Uuy+r1Z7WqIZ/0EhttmE+404YX4lAX/FtFjK0Ns5tpQgSxoIy2
ZUPTWmWsvwSiTud3Ek16IqxbPoQejuVhYnggjonpShvOeXAGcq+PMeQOIDoYl2fjlLTvUUvR
LOvDse0F1nzo+6/OF+rr+h5iD2H4IAn0f/dasUIi77rU1mWMWWNTmRGP/7itZ2OhKakvxrtM
sdbI4aj8AJPLnQIDAQABo2kwZzATBgkrBgEEAYI3FAIEBh4EAEMAQTAOBgNVHQ8BAf8EBAMC
AYYwDwYDVR0TAQH/BAUwAwEB/zAdBgNVHQ4EFgQUCcvtXjEZzU2jCauWbBuPbRfrfxgwEAYJ
KwYBBAGCNxUBBAMCAQAwDQYJKoZIhvcNAQELBQADggIBADP4q4k1ZlMnD9FoC9nanmJsEli3
suYxE3VKFMNMF/g+YTv60ETh3k9op70DUPnowyphLgFAoI2ZmqVyaij5gYxUr9OGYHVUJecG
oc6dYuQQUb6D6QDOJW+kUC/bSTJI5ICOGCQobSRuFPJKswbcq7QxA008+bq/S93zoH/afBgG
VUMqGt/kiwvBra+ClRMu8m5RlpBmkLLy76zcznsWFaJNKnU4N0sWQLrrNh5jiaOT8MVmcoS5
OWfoy3Bp9zHEpT1zVrFvVDdl9+EIFwOAlfcg1jBIp037XxyxN526VUfowmJa86a+VnQVZH92
33y8qMjU2dGhqdXDFT8iHXbnFh3L6uxEjU6w2n90FXtuBaIvMlVKAOLqQrTkUC/FbTRVsCSh
MzzpgEybnc4kcG0LdcEp4dh3NIArj5N37Tqh7pl2i7WBOfQ2ya4mz7f+G0bv1jImPgDK2I3F
zd5f8uMvuCKbxMuDWdpaVRG8M+pwaVGV+b6nr5uoFno9QWk0VYz5035Yi/S0Bv2xT4jI/DR0
jT/A18fDQPGsp4JEk9/4XL0cndYi1mQSKnoKfNkKJGfv/dwLCNP3yEW9rHBbF5LSOe3apq/X
NFH/7ZIkzRBkjngcXffbaClZdad8QALtQAqafYe7PnzNLyjbfpP4u6w2+9YW+yYx90SiSks/
oHPkRSBuMYIC9DCCAvACAQEwXjBQMRMwEQYKCZImiZPyLGQBGRYDc3lzMRswGQYKCZImiZPy
LGQBGRYLY3Jvd2RzdHJpa2UxHDAaBgNVBAMTE2Nyb3dkc3RyaWtlLVJPT1QtQ0ECCiRo6CEA
AAAAAmIwDQYJYIZIAWUDBAIBBQCgaTAvBgkqhkiG9w0BCQQxIgQgknJJgvqW9zqo1nejpCw6
2hiSdovaIzkcbCM/aLfx4YIwGAYJKoZIhvcNAQkDMQsGCSqGSIb3DQEHATAcBgkqhkiG9w0B
CQUxDxcNMTUwODEwMTYwMDIzWjANBgkqhkiG9w0BAQEFAASCAgBgxu1gTjmPlT4Bw0tMPzX1
54u1+fp6/O2BL4vCxmNa812mlfKH9QZocRDRzvEhAh09kfQVuGnbLCsqo5oVVBzxccEv+RdS
OOp/1qEyNqLGSwFNeKJoHPGxPDu+66aSx4UK4iukdS8w6zAaHbR+XRgiS9HmdOfy+6sZ5UV5
D4FPOHhiQVhEL/0utFDfyNhw05zoM8SuhTHCdQ7fIFcyycejuJdirZsarpeMx8dIwxaKXrx0
p3z0l6YmcA34pq2qx8LXRy46JuRrTfZtiFwzOwGMP920toKzBayXf0Hzme4XKiaiMSVxE/Ij
OJeBhqHfqXODnyxy7E6QoMCIMDoHmuZcFSr+lTbbQSx7oh8DuM95933xWnBVx1LwQMoIgdQ5
2+FkmCCmczRDzjqCKh1fnsC8lxXMj1ZStnbVSAJKZStzXRUi/25Esdl0UgjtzhOpH6d9Kqnj
iy3nqXaAtjNnoN3zyL511QFkkEsbgpaseTwb7cU227WMh7oGRKqDdayW0os32ODWvXFMlxKj
JUgtSxyRVFhEkot01vnxcZnvfGMEEMmjabM/B0nHEATggaMBQ2grNe0KMqL8nFFFTjrLqMm+
fIOrlzq2yBOULkXXBb+uOBi/bHtbK+ApyC4iCrPpPpiYXpLdX42xCFczdJV0AWqugzVgcXvr
azxRKshKWUPArA==

--B_3522042024_1382594012--