You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cassandra.apache.org by "C. Scott Andreas (JIRA)" <ji...@apache.org> on 2019/02/16 20:43:00 UTC
[jira] [Updated] (CASSANDRA-14853) Change default timestamp format
to output only milliseconds, not microseconds
[ https://issues.apache.org/jira/browse/CASSANDRA-14853?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
C. Scott Andreas updated CASSANDRA-14853:
-----------------------------------------
Component/s: (was: Dependencies)
Tool/cqlsh
> Change default timestamp format to output only milliseconds, not microseconds
> -----------------------------------------------------------------------------
>
> Key: CASSANDRA-14853
> URL: https://issues.apache.org/jira/browse/CASSANDRA-14853
> Project: Cassandra
> Issue Type: Improvement
> Components: Tool/cqlsh
> Environment: Reproduced in trunk
> Reporter: Alex Ott
> Priority: Major
> Labels: cqlsh
>
> By default cqlsh outputs the timestamp column with microseconds precision, like this:
> {noformat}
> cqlsh:test> create table t1(tm timestamp primary key, t text);
> cqlsh:test> insert into t1(tm, t) values(toTimestamp(now()), 't');
> cqlsh:test> insert into t1(tm, t) values(toTimestamp(now()), 't2');
> cqlsh:test> SELECT * from t1;
> tm | t
> ---------------------------------+----
> 2018-10-27 18:01:54.738000+0000 | t2
> 2018-10-27 18:01:52.599000+0000 | t
> (2 rows)
> {noformat}
> But if I want to use the value that is output on the screen in my query, I get an error:
> {noformat}
> cqlsh:test> select * from t1 where tm = '2018-10-27 18:01:54.738000+0000';
> InvalidRequest: Error from server: code=2200 [Invalid query] message="Unable to coerce '2018-10-27 18:01:54.738000+0000' to a formatted date (long)"
> {noformat}
> But if I manually round it to milliseconds, then everything works:
> {noformat}
> cqlsh:test> select * from t1 where tm = '2018-10-27 18:01:54.738+0000';
> tm | t
> ---------------------------------+----
> 2018-10-27 18:01:54.738000+0000 | t2
> (1 rows)
> {noformat}
> It would be much easier user's experience if we use the same format for output & input data, because right now this leads to errors, that often not really understandable by novice users.
> P.S. I know about cqlshrc, but not every user has it configured.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@cassandra.apache.org
For additional commands, e-mail: commits-help@cassandra.apache.org