[
https://issues.apache.org/jira/browse/TAJO-1327?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jihun Kang resolved TAJO-1327.
------------------------------
Resolution: Invalid
Sorry for that. I was confused other functions.
> rank function refers table data that was purged
> -----------------------------------------------
>
> Key: TAJO-1327
> URL: https://issues.apache.org/jira/browse/TAJO-1327
> Project: Tajo
> Issue Type: Bug
> Components: function/udf
> Affects Versions: 0.10
> Reporter: Jihun Kang
> Priority: Critical
>
> When executing a query containing rank function, tajo returns the data that
> was already purged. More details can be found in a series of queries.
> {code}
> default> create external table test1 (n_name int4) using csv with
> ('text.delimiter'='|') location 'file:///opt/tajo-0.10.0/tpch/test.tbl';
> OK
> default> select * from test1;
> n_name
> -------------------------------
> 1
> 3
> 2
> 4
> (4 rows, 0.181 sec, 12 B selected)
> default> select rank() over (order by n_name) from test1;
> Progress: 0%, response time: 1.608 sec
> Progress: 0%, response time: 1.611 sec
> Progress: 0%, response time: 2.013 sec
> Progress: 0%, response time: 2.816 sec
> Progress: 50%, response time: 3.819 sec
> Progress: 100%, response time: 4.577 sec
> ?windowfunction
> -------------------------------
> 1
> 2
> 3
> 4
> (4 rows, 4.577 sec, 8 B selected)
> default> drop table test1 purge;
> OK
> default> create external table test2 (n_name text) using csv with
> ('text.delimiter'='|') location 'file:///opt/tajo-0.10.0/tpch/test.tbl';
> OK
> default> select * from test2;
> n_name
> -------------------------------
> abcd
> eifjkld
> bcdjk
> eiodf
> (4 rows, 0.041 sec, 29 B selected)
> default> select rank() over (order by n_name) from test2;
> Progress: 0%, response time: 2.441 sec
> Progress: 0%, response time: 2.443 sec
> Progress: 0%, response time: 2.846 sec
> Progress: 0%, response time: 3.648 sec
> Progress: 50%, response time: 4.651 sec
> Progress: 50%, response time: 5.654 sec
> Progress: 50%, response time: 6.657 sec
> Progress: 100%, response time: 7.316 sec
> ?windowfunction
> -------------------------------
> 1
> 2
> 3
> 4
> (4 rows, 7.316 sec, 8 B selected)
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
