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)