[
https://issues.apache.org/jira/browse/CASSANDRA-13694?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16092942#comment-16092942
]
Varun Barala commented on CASSANDRA-13694:
------------------------------------------
After this patch output will look like:-
[
{
"partition" : {
"key" : [ "1234", "TEST EVENT" ],
"position" : 0
},
"rows" : [
{
"type" : "row",
"position" : 38,
"clustering" : [ "1970-01-18 16:16:13.000183+0730" ],
"liveness_info" : { "tstamp" : "2017-07-18T09:19:55.623Z" },
"cells" : [
{ "name" : "ack_time", "value" : "1970-01-18 16:16:13.000003+0730" }
]
}
]
}
]
> sstabledump does not show full precision of timestamp columns
> -------------------------------------------------------------
>
> Key: CASSANDRA-13694
> URL: https://issues.apache.org/jira/browse/CASSANDRA-13694
> Project: Cassandra
> Issue Type: Bug
> Components: Tools
> Environment: Ubuntu 16.04 LTS
> Reporter: Tim Reeves
> Labels: patch
> Fix For: 3.7
>
> Attachments: CASSANDRA-13694.patch
>
>
> Create a table:
> CREATE TABLE test_table (
> unit_no bigint,
> event_code text,
> active_time timestamp,
> ack_time timestamp,
> PRIMARY KEY ((unit_no, event_code), active_time)
> ) WITH CLUSTERING ORDER BY (active_time DESC)
> Insert a row:
> INSERT INTO test_table (unit_no, event_code, active_time, ack_time)
> VALUES (1234, 'TEST EVENT', toTimestamp(now()),
> toTimestamp(now()));
> Verify that it is in the database with a full timestamp:
> cqlsh:pentaho> select * from test_table;
> unit_no | event_code | active_time | ack_time
> ---------+------------+---------------------------------+---------------------------------
> 1234 | TEST EVENT | 2017-07-14 14:52:39.919000+0000 | 2017-07-14
> 14:52:39.919000+0000
> (1 rows)
> Write file:
> nodetool flush
> nodetool compact pentaho
> Use sstabledump:
> treeves@ubuntu:~$ sstabledump
> /var/lib/cassandra/data/pentaho/test_table-99ba228068a311e7ac30953b79ac2c3e/mb-2-big-Data.db
> [
> {
> "partition" : {
> "key" : [ "1234", "TEST EVENT" ],
> "position" : 0
> },
> "rows" : [
> {
> "type" : "row",
> "position" : 38,
> "clustering" : [ "2017-07-14 15:52+0100" ],
> "liveness_info" : { "tstamp" : "2017-07-14T14:52:39.888701Z" },
> "cells" : [
> { "name" : "ack_time", "value" : "2017-07-14 15:52+0100" }
> ]
> }
> ]
> }
> ]
> treeves@ubuntu:~$
> The timestamp in the cluster key, and the regular column, are both truncated
> to the minute.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
