Uploaded image for project: 'Cassandra'
  1. Cassandra
  2. CASSANDRA-10428

cqlsh: Include sub-second precision in timestamps by default

    XMLWordPrintableJSON

    Details

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

      OSX 10.10.2

      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>

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                stefania Stefania Alborghetti
                Reporter:
                reach.nchan Chandran Anjur Narasimhan
                Authors:
                Stefania Alborghetti
                Reviewers:
                Paulo Motta (Deprecated)
              • Votes:
                0 Vote for this issue
                Watchers:
                7 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: