Timeseries drop

[antioh]

prereq:
arcadedb version 26.3.2
created timeseries type

CREATE TIMESERIES TYPE Ticker TIMESTAMP ts TAGS (name STRING,attr STRING)
                    FIELDS (f1 DOUBLE,f2 LONG....) 
SHARDS 8 RETENTION 1 DAYS

1. According to doc 4.11.3 command

DROP TIMESERIES TYPE Ticker

returns error:
SQL syntax error at line 1, column 5: no viable alternative at input 'DROP TIMESERIES' DROP TIMESERIES TYPE Ticker

however drop correctly works in timeseries page.

2. If excute command create timeseries type Ticker after remove

then
select count() from Ticker will show previously deleted data
If this behavior is correct due to retention policy then should be described in doc

[antioh]

remark for ingesting data;
use inserts like from 4.11.4

-- Single row
INSERT INTO SensorReading
SET ts = '2026-02-20T10:00:00.000Z',
....
and
-- Batch insert
INSERT INTO SensorReading
(ts, sensor_id, location, temperature, humidity)
VALUES
('2026-02-20T10:00:00Z', 'sensor-A', 'building-1', 22.5, 65.0),

container log contains many these records:

2026-04-14 00:26:54.860 SEVER [PostTimeSeriesQueryHandler] <ArcadeDB_0> Error on command execution (PostTimeSeriesQueryHandler): Parallel shard aggregation failed
2026-04-14 00:26:55.716 INFO  [PostCommandHandler] <ArcadeDB_0> Error on transaction execution (PostCommandHandler): Error on executing command
2026-04-14 00:26:55.716 INFO  [PostCommandHandler] <ArcadeDB_0> Error on transaction execution (PostCommandHandler): Error on executing command
2026-04-14 00:26:55.760 INFO  [PostCommandHandler] <ArcadeDB_0> Error on transaction execution (PostCommandHandler): Error on executing command

[lvca]

Fixed