[jira] [Commented] (DRILL-3218) Window function usage throws CompileException

["Khurram Faraaz (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/DRILL-3218?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14565666#comment-14565666 ] 

Khurram Faraaz commented on DRILL-3218:
---------------------------------------

Here is the simpler repro for the failure

Failing query,
{code}
0: jdbc:drill:schema=dfs.tmp> select max(columns[0]) over (partition by columns[1] order by columns[2]) from `int_tmstmp_date.csv`;
Error: SYSTEM ERROR: org.codehaus.commons.compiler.CompileException: Line 327, Column 31: Unknown variable or type "incoming"

Fragment 0:0

[Error Id: 93bb549b-433f-489b-980b-07f91c996cb7 on centos-04.qa.lab:31010] (state=,code=0)
{code}

Data from CSV file used in above query
{code}
4550098,2015-04-04 06:41:42.869,1968-03-22
50098,2015-06-04 06:41:42.869,1968-04-22
550098,2015-03-04 06:41:42.869,1968-01-22
4550098,2015-09-04 06:41:42.869,1968-08-22
34550098,2015-01-04 06:41:42.869,1968-08-22
6544,2015-03-04 06:41:42.869,1991-11-03
86544,2015-02-04 06:41:42.869,1991-11-03
986544,2015-08-04 06:41:42.869,1991-10-03
5986544,2015-01-04 06:41:42.869,1991-01-03
11440,2015-03-04 06:41:42.870,1956-02-07
1440,2015-02-04 06:41:42.870,1956-03-07
1811440,2015-01-04 06:41:42.870,1956-08-07
811440,2015-04-04 06:41:42.870,1956-07-07
-731534025,2015-07-04 06:41:42.171,2011-06-13
31534025,2015-08-04 06:41:42.371,2011-01-13
1534025,2015-06-04 06:41:42.871,2011-09-13
34025,2015-04-04 06:41:42.871,2011-07-13
{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)