[CASSANDRA-14853] Change default timestamp format to output only milliseconds, not microseconds

• Type: Improvement
• Status: Resolved
• Priority: Normal
• Resolution: Fixed
• Fix Version/s: 4.0-beta2, 4.0
• Component/s: Tool/cqlsh
• Labels: cqlsh

Environment

Reproduced in trunk

Source Control Link

https://github.com/apache/cassandra/commit/139ad44e8b53ed194ba4b47fbfae3484015034f9

Test and Documentation Plan

docs

• Assignee: Unassigned
• Reporter: Alex Ott

Authors

Adam Holmberg

Reviewers

Brandon Williams

• Created: 28/Oct/18 10:18
• Updated: 03/Jan/21 17:03
• Resolved: 14/Aug/20 15:02

Description

By default cqlsh outputs the timestamp column with microseconds precision, like this:

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)

But if I want to use the value that is output on the screen in my query, I get an error:

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)"

But if I manually round it to milliseconds, then everything works:

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)

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.

Issue Links

• Dependent: CASSANDRA-15976 Incorrect parsing of the timestamp with less than 3 digits in the milliseconds