Simon Bence created NIFI-10451:
----------------------------------
Summary: Update QuestDB based status history repository's clean up
query
Key: NIFI-10451
URL: https://issues.apache.org/jira/browse/NIFI-10451
Project: Apache NiFi
Issue Type: Bug
Components: Core Framework, Extensions
Reporter: Simon Bence
Assignee: Simon Bence
QuestDB 6.X uses a different syntax for dropping partitons (here: cleaning up
old status history information) than 4.x. As the version number has been
bumped, the query must be updated too. The currently expected syntax is the
following:
{{ALTER TABLE measurements DROP PARTITION LIST '2019-05-18';}}
This is from the QuestDB
[documentation|https://questdb.io/docs/reference/sql/alter-table-drop-partition]
at the time of creating the ticket (might change in the future)
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
