You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cassandra.apache.org by "Ben Boule (JIRA)" <ji...@apache.org> on 2013/08/09 20:20:48 UTC
[jira] [Updated] (CASSANDRA-5870) CQLSH not showing milliseconds in
timestamps
[ https://issues.apache.org/jira/browse/CASSANDRA-5870?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Ben Boule updated CASSANDRA-5870:
---------------------------------
Description:
CQLSH does not include the milliseconds portion of the timestamp when outputting query results. For example on my system a time might be displayed like this:
"2013-08-09 10:55:58-0400" for a time stored in cassandra as: 1376060158267
We've found this extremely annoying when dealing with time series data as it will make records which occurred at different times appear to occur at the same time.
I'm submitting a patch, the existing formatting code already has handling of some versions of python which do not support formatting time zones, I'm not sure which versions of python can format seconds+milliseconds so I attempted to supply something which will work with any time_format string and does not depend on the system library.
The above time with the patch will format like this:
"2013-08-09 10:55:58.267-0400"
was:
CQLSH does not include the milliseconds portion of the timestamp when outputting query results. For example on my system a time might be displayed like this:
"2013-08-09 10:55:58-0400" for a time stored in cassandra as: 1376060158267
We've found this extremely annoying when dealing with time series data as it will make records which occurred at different times appear to occur at the same time.
I'm submitting a patch, the existing formatting code already has handling of some versions of python which do not support formatting time zones, I'm not sure which versions of python can format seconds+milliseconds so I attempted to supply something which will work with any time_format string and does not depend on the system library.
> CQLSH not showing milliseconds in timestamps
> --------------------------------------------
>
> Key: CASSANDRA-5870
> URL: https://issues.apache.org/jira/browse/CASSANDRA-5870
> Project: Cassandra
> Issue Type: Bug
> Components: Tools
> Environment: Linux
> Reporter: Ben Boule
> Priority: Minor
> Fix For: 1.2.5
>
>
> CQLSH does not include the milliseconds portion of the timestamp when outputting query results. For example on my system a time might be displayed like this:
> "2013-08-09 10:55:58-0400" for a time stored in cassandra as: 1376060158267
> We've found this extremely annoying when dealing with time series data as it will make records which occurred at different times appear to occur at the same time.
> I'm submitting a patch, the existing formatting code already has handling of some versions of python which do not support formatting time zones, I'm not sure which versions of python can format seconds+milliseconds so I attempted to supply something which will work with any time_format string and does not depend on the system library.
> The above time with the patch will format like this:
> "2013-08-09 10:55:58.267-0400"
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira