[
https://issues.apache.org/jira/browse/TAJO-922?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14558608#comment-14558608
]
ASF GitHub Bot commented on TAJO-922:
-------------------------------------
Github user jihoonson commented on the pull request:
https://github.com/apache/tajo/pull/535#issuecomment-105349165
Sorry for late response.
I've found query result looks wrong as follows.
_Tajo_
```
tpch> select n_regionkey, nth_value(n_comment, 1) over (partition by
n_regionkey) from nation;
Progress: 100%, response time: 0.314 sec
n_regionkey, ?windowfunction
-------------------------------
0, rns. blithely bold courts among the closely regular packages use
furiously bold platelets?
0, rns. blithely bold courts among the closely regular packages use
furiously bold platelets?
0, rns. blithely bold courts among the closely regular packages use
furiously bold platelets?
0, rns. blithely bold courts among the closely regular packages use
furiously bold platelets?
0, rns. blithely bold courts among the closely regular packages use
furiously bold platelets?
1, y final packages. slow foxes cajole quickly. quickly silent platelets
breach ironic accounts. unusual pinto be
1, y final packages. slow foxes cajole quickly. quickly silent platelets
breach ironic accounts. unusual pinto be
1, y final packages. slow foxes cajole quickly. quickly silent platelets
breach ironic accounts. unusual pinto be
1, y final packages. slow foxes cajole quickly. quickly silent platelets
breach ironic accounts. unusual pinto be
1, y final packages. slow foxes cajole quickly. quickly silent platelets
breach ironic accounts. unusual pinto be
2, ously. final, express gifts cajole a
2, ously. final, express gifts cajole a
2, ously. final, express gifts cajole a
2, ously. final, express gifts cajole a
2, ously. final, express gifts cajole a
3, refully final requests. regular, ironi
3, refully final requests. regular, ironi
3, refully final requests. regular, ironi
3, refully final requests. regular, ironi
3, refully final requests. regular, ironi
4, y above the carefully unusual theodolites. final dugouts are quickly
across the furiously regular d
4, y above the carefully unusual theodolites. final dugouts are quickly
across the furiously regular d
4, y above the carefully unusual theodolites. final dugouts are quickly
across the furiously regular d
4, y above the carefully unusual theodolites. final dugouts are quickly
across the furiously regular d
4, y above the carefully unusual theodolites. final dugouts are quickly
across the furiously regular d
(25 rows, 0.314 sec, 1.9 KiB selected)
```
_Pgsql_
```
postgres=# select n_regionkey, nth_value(n_comment, 1) over (partition by
n_regionkey) from nation;
n_regionkey | nth_value
-------------+-----------------------------------------------------------------------------------------------------------------
0 | ven packages wake quickly. regu
0 | ven packages wake quickly. regu
0 | ven packages wake quickly. regu
0 | ven packages wake quickly. regu
0 | ven packages wake quickly. regu
1 | y final packages. slow foxes cajole quickly. quickly silent
platelets breach ironic accounts. unusual pinto be
1 | y final packages. slow foxes cajole quickly. quickly silent
platelets breach ironic accounts. unusual pinto be
1 | y final packages. slow foxes cajole quickly. quickly silent
platelets breach ironic accounts. unusual pinto be
1 | y final packages. slow foxes cajole quickly. quickly silent
platelets breach ironic accounts. unusual pinto be
1 | y final packages. slow foxes cajole quickly. quickly silent
platelets breach ironic accounts. unusual pinto be
2 | hely enticingly express accounts. even, final
2 | hely enticingly express accounts. even, final
2 | hely enticingly express accounts. even, final
2 | hely enticingly express accounts. even, final
2 | hely enticingly express accounts. even, final
3 | ular asymptotes are about the furious multipliers. express
dependencies nag above the ironically ironic account
3 | ular asymptotes are about the furious multipliers. express
dependencies nag above the ironically ironic account
3 | ular asymptotes are about the furious multipliers. express
dependencies nag above the ironically ironic account
3 | ular asymptotes are about the furious multipliers. express
dependencies nag above the ironically ironic account
3 | ular asymptotes are about the furious multipliers. express
dependencies nag above the ironically ironic account
4 | y above the carefully unusual theodolites. final dugouts are
quickly across the furiously regular d
4 | y above the carefully unusual theodolites. final dugouts are
quickly across the furiously regular d
4 | y above the carefully unusual theodolites. final dugouts are
quickly across the furiously regular d
4 | y above the carefully unusual theodolites. final dugouts are
quickly across the furiously regular d
4 | y above the carefully unusual theodolites. final dugouts are
quickly across the furiously regular d
(25 rows)
```
> Add NTH_VALUE window function
> -----------------------------
>
> Key: TAJO-922
> URL: https://issues.apache.org/jira/browse/TAJO-922
> Project: Tajo
> Issue Type: Sub-task
> Components: function/udf, physical operator
> Reporter: Hyunsik Choi
> Assignee: Seungun Choe
> Fix For: window function
>
> Attachments: TAJO-922.patch
>
>
> The NTH_VALUE window function returns the value of the specified row of the
> window frame relative to the first row of the window. We need to implement it.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
