, 19 June 2017 at 17:44
To: Hannu Kröger
Cc: "user@cassandra.apache.org" , Tobias Eriksson
Subject: Re: SASI index on datetime column does not filter on minutes
The + in the date format is necessary to specify timezone
On Mon, Jun 19, 2017 at 5:38 PM, Hannu Kröger
mailto:hkro...@gm
The + in the date format is necessary to specify timezone
On Mon, Jun 19, 2017 at 5:38 PM, Hannu Kröger wrote:
> Hello,
>
> I tried the same thing with 3.10 which I happened to have at hand and that
> seems to work.
>
> cqlsh:test> select lastname,firstname,dateofbirth from individuals where
Hello,
I tried the same thing with 3.10 which I happened to have at hand and that
seems to work.
cqlsh:test> select lastname,firstname,dateofbirth from individuals where
dateofbirth < '2001-01-01T10:00:00' and dateofbirth > '2000-11-18 17:59:18';
lastname | firstname | dateofbirth
--+--
Hi
I have a table like this (Cassandra 3.5)
Table
id uuid,
lastname text,
firstname text,
address_id uuid,
dateofbirth timestamp,
PRIMARY KEY (id, lastname, firstname)
And a SASI index like this
create custom index indv_birth ON playground.individual(dateofbirth) USING
'org.a
