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)
```
---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at [email protected] or file a JIRA ticket
with INFRA.
---
