[
https://issues.apache.org/jira/browse/NIFI-4457?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16190876#comment-16190876
]
meh commented on NIFI-4457:
---------------------------
[~patricker] hi peter.
no that is not already the maximum value in the table, at same time new records
are inserting and max value is increasing.
try this dataset: [^subquery.csv]
i connect to mariaDB database using jdbc, and query this table to return
records greater than X by initial.maxvalue.tweet_id . at first use this works
well, but i need this processor scheduled and for next run this problem is
happening and maxvalue on view state not changing.
i using this processor on other tables and there is not any problem, but this
different!
is it probable that relates to "Use Avro Logical Types" or "Default Decimal
Precision" or "Default Decimal Scale"? because of length of tweet_id?
> "Maximum-value" not increasing when "initial.maxvalue" is set and
> "Maximum-value column" name is different from "id"
> ---------------------------------------------------------------------------------------------------------------------
>
> Key: NIFI-4457
> URL: https://issues.apache.org/jira/browse/NIFI-4457
> Project: Apache NiFi
> Issue Type: Bug
> Components: Core Framework
> Affects Versions: 1.3.0
> Environment: windows 10
> Reporter: meh
> Attachments: Picture1.png, Picture2.png, subquery.csv
>
> Original Estimate: 24h
> Remaining Estimate: 24h
>
> when "Maximum-value column" name is "id" there is no problem, when i add
> "initial.maxvalue.id" property in "QueryDatabaseTable" processor, it works
> well and maxvalue is increasing by every running.
> !Picture1.png|thumbnail!
> but...
> when the "Maximum-value column" name is different from "id" (such as
> "tweet_id"), after initial processor working, only given
> "initial.maxvalue.id" is saves and that repeating just same value for every
> run.
> !Picture2.png|thumbnail!
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
