Delete query deleting all records

Welcome & Getting Started
1

Hi Team,
I am running a delete query which is somehow deleting all records from the measurement.
All details below.

select * from player
name: player
time dept id sal

2021-02-19T19:53:03Z 22 2 2000
2021-02-19T19:53:04Z 22 2 2000
2021-02-19T19:53:05Z 22 2 2000
2071-02-19T19:53:03Z 32 32 32000
2071-02-19T19:53:03Z 33 33 33000
2173-04-16T18:13:07.269009408Z 44 44 44000

name: Demo_2
id database retention_policy shard_group start_time end_time expiry_time owners

253 Demo_2 rp7d 253 2021-02-19T00:00:00Z 2021-02-20T00:00:00Z 2021-02-27T00:00:00Z
254 Demo_2 rp7d 254 2071-02-19T00:00:00Z 2071-02-20T00:00:00Z 2071-02-27T00:00:00Z
255 Demo_2 rp7d 255 2173-04-16T00:00:00Z 2173-04-17T00:00:00Z 2173-04-24T00:00:00Z

delete from player where time > 1613826065
select * from player

if any one trying to do the test below is insert statement:
insert player,dept=22,id=2 sal=2000 1613764383000000000
insert player,dept=22,id=2 sal=2000 1613764384000000000
insert player,dept=22,id=2 sal=2000 1613764385000000000
insert player,dept=32,id=32 sal=32000 3191601183000000000
insert player,dept=33,id=33 sal=33000 3191601183000000000
insert player,dept=44,id=44 sal=44000 6415265587269009408
Here in delete it is deleting all records from the DB. Any thoughts?

2

Hello @oom ,
Have you tried making your timestamp in unix precision or alternatively in this format:

DELETE WHERE time < '2015-08-18T00:00:00Z'
3

Thanks Anais, It helped after adding the trailing 0’s in my timestamps, also the format you gave also worked. However I have doubt on this though I have deleted records.
Now my table looks like below after deleting the 2071 year data.

image

All 2071 and 2073 records are dropped now. But when I see the shards the shard file still exist , Will it drop automatically after some time or any way I have to drop manually.

image
image1368×159 5.49 KB

What is the definition of the Owner column ,last column mentioned in the shard definition.

thanks