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

[jira] [Commented] (TRAFODION-1850) Select First N from TMUDF Select all rows

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

ASF GitHub Bot commented on TRAFODION-1850:
-------------------------------------------

GitHub user zellerh opened a pull request:

    https://github.com/apache/incubator-trafodion/pull/351

    [TRAFODION-1850] First N operator no longer returns extra rows.

    This also fixes [TRAFODION-908].
    
    This is the entire or a partial fix to the problem where
    a select [first n] * from udf(...) can return more than n rows.
    The problem was that neither FirstN nor the UDF operator fully
    implemented the GET_N protocol. While that may be ok for the UDF,
    the FirstN needed a fix.

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

    $ git pull https://github.com/zellerh/incubator-trafodion bug/1581

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

    https://github.com/apache/incubator-trafodion/pull/351.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 #351
    
----
commit f614456a56d665587b706da2fb6bb82b5dcc0000
Author: Hans Zeller <hz...@apache.org>
Date:   2016-02-29T23:12:58Z

    [TRAFODION-1850] First N operator no longer returns extra rows.
    
    This is the entire or a partial fix to the problem where
    a select [first n] * from udf(...) can return more than n rows.
    The problem was that neither FirstN nor the UDF operator fully
    implemented the GET_N protocol. While that may be ok for the UDF,
    the FirstN needed a fix.

----


> Select First N from TMUDF Select all rows
> -----------------------------------------
>
>                 Key: TRAFODION-1850
>                 URL: https://issues.apache.org/jira/browse/TRAFODION-1850
>             Project: Apache Trafodion
>          Issue Type: Bug
>            Reporter: hazi goldman
>            Assignee: Hans Zeller
>
> If I use this with esp parallelism ON then First N is honored but with parallelism OFF it returns all rows,
> select [first 10] * from udf(udfFooName(table(select * from logs)))



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