We have a database with only one and default retention policy 7 days… I can select data older than 7 days … why ?
influx
Connected to http://localhost:8086 version 1.3.1
InfluxDB shell version: 1.3.1
auth
username: dbadmin
password:
show retention policies on indicators
name duration shardGroupDuration replicaN default
autogen 168h0m0s 24h0m0s 1 true
select count(*) from MA1 WHERE time < now() -7d
name: MA1
time count_MA_12H count_MA_12_Hour count_MA_2D count_MA_2_Day count_MA_5D count_MA_5_Day count_MA_6H count_MA_6_Hour count_SD_12H count_SD_12_Hour count_SD_2D count_SD_2_Day count_SD_5D count_SD_5_Day count_SD_6H count_SD_6_Hour
0 3 19169 3 19169 3 19169 3 19169 3 18996 3 19057 3 19128 3 18818
exit
when does the data gets removed if at all !