You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Khurram Faraaz (JIRA)" <ji...@apache.org> on 2015/06/02 18:56:49 UTC
[jira] [Comment Edited] (DRILL-3218) Window function usage throws
CompileException
[ https://issues.apache.org/jira/browse/DRILL-3218?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14565769#comment-14565769 ]
Khurram Faraaz edited comment on DRILL-3218 at 6/2/15 4:56 PM:
---------------------------------------------------------------
Another similar scenario, aggregate MAX over data of TIME type and PARTITION BY string type data and ORDER BY time type data, also results in same Exception
{code}
0: jdbc:drill:schema=dfs.tmp> select max(columns[0]) over(partition by columns[1] order by columns[0]) from `time_data.csv`;
Error: SYSTEM ERROR: org.codehaus.commons.compiler.CompileException: Line 325, Column 31: Unknown variable or type "incoming"
Fragment 0:0
[Error Id: 3279f0b0-0e90-492e-bc6b-187533127040 on centos-03.qa.lab:31010] (state=,code=0)
{code}
Data used in test
{code}
[root@centos-01 ~]# cat time_data.csv
"time","region"
22:55:55.23,north
21:55:55.23,south
23:49:13.19,east
17:20:19.29,west
18:30:01.10,north
24:49:13.19,south
20:24:19.29,north
20:23:19.29,west
20:22:19.29,south
20:27:19.29,east
20:21:19.29,north
18:30:01.10,north
{code}
was (Author: khfaraaz):
Another similar scenario, aggregate MAX over data of TIME type and PARTITION BY string type data and ORDER BY time type data, also results in same Exception
{code}
0: jdbc:drill:schema=dfs.tmp> select max(columns[0]) over(partition by columns[1] order by columns[0]) from `time_data.csv`;
Error: SYSTEM ERROR: org.codehaus.commons.compiler.CompileException: Line 325, Column 31: Unknown variable or type "incoming"
Fragment 0:0
[Error Id: 3279f0b0-0e90-492e-bc6b-187533127040 on centos-03.qa.lab:31010] (state=,code=0)
{code}
Data used in test
{code}
[root@centos-01 ~]# cat time_data.csv
"time","region"
22:55:55.23,north
21:55:55.23,south
23:49:13:19,east
17:20:19:29,west
18:30:01:10,north
24:49:13:19,south
20:24:19:29,north
20:23:19:29,west
20:22:19:29,south
20:27:19:29,east
20:21:19:29,north
18:30:01:10,north
{code}
> Window function usage throws CompileException
> ---------------------------------------------
>
> Key: DRILL-3218
> URL: https://issues.apache.org/jira/browse/DRILL-3218
> Project: Apache Drill
> Issue Type: Bug
> Components: Execution - Flow
> Affects Versions: 1.0.0
> Environment: faec150598840c40827e6493992d81209aa936da
> Reporter: Khurram Faraaz
> Assignee: Deneche A. Hakim
> Labels: window_function
> Fix For: 1.1.0
>
> Attachments: drillbit_DRILL_3218.log
>
>
> PARTITION BY date ORDER BY timestamp
> {code}
> 0: jdbc:drill:schema=dfs.tmp> SELECT MAX(columns[0]) OVER (PARTITION BY columns[6] ORDER BY columns[4]) FROM `allTypData2.csv`;
> Error: SYSTEM ERROR: org.codehaus.commons.compiler.CompileException: Line 330, Column 31: Unknown variable or type "incoming"
> Fragment 0:0
> [Error Id: 285af8f1-ddb4-4d3e-a2d7-bfaef20df5e0 on centos-02.qa.lab:31010] (state=,code=0)
> {code}
> I will add more details in a bit.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)