[
https://issues.apache.org/jira/browse/NIFI-4457?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16192863#comment-16192863
]
meh commented on NIFI-4457:
---------------------------
[~patricker]
yes, this is schema; and I think that is maybe as you said... :thinking: (on)
USE twt_new;
CREATE TABLE tweets_json (
tweet_id bigint(20) UNSIGNED NOT NULL,
date datetime NOT NULL,
PRIMARY KEY (tweet_id),
INDEX date (date),
CONSTRAINT FK_tweets_json_tweets FOREIGN KEY (tweet_id)
REFERENCES tweets (id) ON DELETE RESTRICT ON UPDATE RESTRICT
)
ENGINE = INNODB
AVG_ROW_LENGTH = 782
CHARACTER SET utf8mb4
COLLATE utf8mb4_unicode_520_ci
ROW_FORMAT = COMPRESSED;
> "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)
