cql - Cassandra <= on a time column

Question

I have a Cassandra table that looks something like this

  VmwareVirtualMachine | 2020-04-24 02:04:57+0000
  VmwareVirtualMachine | 2020-05-14 06:02:23+0000
  VmwareVirtualMachine | 2020-05-14 06:02:23+0000
  VmwareVirtualMachine | 2020-06-26 13:19:03+0000
  VmwareVirtualMachine | 2020-06-29 06:14:00+0000

My requirement is to print all rows that are less than or equal to 2020-05-14 06:02:23+0000

My query is:

cqlsh -ksd -e "select type, timevalue from table_one where timevalue != null and timevalue<='2020-05-14 06:02:23+0000'"

It prints

 VmwareVirtualMachine | 2020-04-24 02:04:57+0000

Since I gave <= I expected it to print

  VmwareVirtualMachine | 2020-04-24 02:04:57+0000
  VmwareVirtualMachine | 2020-05-14 06:02:23+0000
  VmwareVirtualMachine | 2020-05-14 06:02:23+0000

If I do something like this:

cqlsh -ksd -e "select type, timevalue from table_one where timevalue != null and timevalue<='2020-05-14 06:02:24+0000'"

It prints the first 3 rows if I increase the time by a second. Not sure why less than or not equal to does not work in my statement.

Any help?

question from:https://stackoverflow.com/questions/65843816/cassandra-on-a-time-column

Answer 1

Waitting for answers