[CASSANDRA-10428] cqlsh: Include sub-second precision in timestamps by default

• Type: Improvement
• Status: Resolved
• Priority: Normal
• Resolution: Fixed
• Fix Version/s: 3.4
• Component/s: Legacy/Tools
• Labels: cqlsh

Environment

OSX 10.10.2

• Assignee: Stefania Alborghetti
• Reporter: Chandran Anjur Narasimhan

Authors

Stefania Alborghetti

Reviewers

Paulo Motta

• Created: 30/Sep/15 21:58
• Updated: 16/Apr/19 09:30
• Resolved: 02/Feb/16 14:08

Description

Query with >= timestamp works. But the exact timestamp value is not working.

NCHAN-M-D0LZ:bin nchan$ ./cqlsh
Connected to CCC Multi-Region Cassandra Cluster at <host>:<port>.
[cqlsh 5.0.1 | Cassandra 2.1.7 | CQL spec 3.2.0 | Native protocol v3]
Use HELP for help.
cqlsh>

Schema

cqlsh:ccc> desc COLUMNFAMILY ez_task_result ;

CREATE TABLE ccc.ez_task_result (
submissionid text,
ezid text,
name text,
time timestamp,
analyzed_index_root text,
...
...
PRIMARY KEY (submissionid, ezid, name, time)

Working

cqlsh:ccc> select submissionid, ezid, name, time, state, status, translated_criteria_status from ez_task_result where submissionid='760dd154670811e58c04005056bb6ff0' and ezid='760dd6de670811e594fc005056bb6ff0' and name='run-sanities' and time>='2015-09-29 20:54:23-0700';

submissionid | ezid | name | time | state | status | translated_criteria_status
----------------------------------------------------------------------------------------------------------------------------------------------------
760dd154670811e58c04005056bb6ff0 | 760dd6de670811e594fc005056bb6ff0 | run-sanities | 2015-09-29 20:54:23-0700 | EXECUTING | IN_PROGRESS | run-sanities started

(1 rows)
cqlsh:ccc>

Not working

cqlsh:ccc> select submissionid, ezid, name, time, state, status, translated_criteria_status from ez_task_result where submissionid='760dd154670811e58c04005056bb6ff0' and ezid='760dd6de670811e594fc005056bb6ff0' and name='run-sanities' and time='2015-09-29 20:54:23-0700';

submissionid | ezid | name | time | analyzed_index_root | analyzed_log_path | clientid | end_time | jenkins_path | log_file_path | path_available | path_to_task | required_for_overall_status | start_time | state | status | translated_criteria_status | type
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-----

(0 rows)
cqlsh:ccc>

Issue Links

• breaks: CASSANDRA-11135 test_timestamp_output in the cqlshlib tests is failing
• is related to: CASSANDRA-5870 CQLSH not showing milliseconds in timestamps
• supercedes: CASSANDRA-5870 CQLSH not showing milliseconds in timestamps
• links to: dtest pull request
• links to: patch for trunk