You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@nifi.apache.org by "ASF GitHub Bot (JIRA)" <ji...@apache.org> on 2016/09/23 00:23:21 UTC

[jira] [Commented] (NIFI-2803) The pagination of GenerateTableFetch has a sort bug.

    [ https://issues.apache.org/jira/browse/NIFI-2803?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15514913#comment-15514913 ] 

ASF GitHub Bot commented on NIFI-2803:
--------------------------------------

GitHub user combineads opened a pull request:

    https://github.com/apache/nifi/pull/1052

    NIFI-2803 The pagination of GenerateTableFetch has a sort bug

    When data is coming to the ingested table, the pagination SQL needs the ORDER BY statement with maxValueClauses.
    If maxValueClauses are not the primary keys, incoming data usually inserts using primary keys. So when ExecuteSQL executes, some data may be lost.

You can merge this pull request into a Git repository by running:

    $ git pull https://github.com/combineads/nifi NIFI-2803

Alternatively you can review and apply these changes as the patch at:

    https://github.com/apache/nifi/pull/1052.patch

To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:

    This closes #1052
    
----
commit d27e5380ed490ee1aecd27a487b32b36e80c2594
Author: Byunghwa Yun <co...@combineads.co.kr>
Date:   2016-09-23T00:21:21Z

    NIFI-2803 The pagination of GenerateTableFetch has a sort bug.

----


> The pagination of GenerateTableFetch has a sort bug.
> ----------------------------------------------------
>
>                 Key: NIFI-2803
>                 URL: https://issues.apache.org/jira/browse/NIFI-2803
>             Project: Apache NiFi
>          Issue Type: Bug
>          Components: Extensions
>    Affects Versions: 1.0.0
>            Reporter: Byunghwa Yun
>
> When data is coming to the ingested table, the pagination SQL needs the ORDER BY statement with maxValueClauses.
> If maxValueClauses are not the primary keys, incoming data usually inserts  using primary keys. So when ExecuteSQL executes, some data may be lost.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)