[ https://issues.apache.org/jira/browse/DRILL-3601?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14741361#comment-14741361 ]
Victoria Markman commented on DRILL-3601: ----------------------------------------- Verified fixed in: 1.2.0 #Fri Sep 11 05:38:24 UTC 2015 git.commit.id.abbrev=b525692 Test added in: Functional/Passing/window_functions/negative/no_over_clause-3.sql > LEAD function used without OVER clause should not plan > ------------------------------------------------------ > > Key: DRILL-3601 > URL: https://issues.apache.org/jira/browse/DRILL-3601 > Project: Apache Drill > Issue Type: Bug > Components: Query Planning & Optimization > Affects Versions: 1.2.0 > Environment: private-branch-with-new-window-functions > Reporter: Khurram Faraaz > Assignee: Sean Hsuan-Yi Chu > Labels: window_function > Fix For: 1.2.0 > > Attachments: drillbit.log, fewRowsAllData.parquet > > > When using LEAD window function without OVER clause, query should fail. Yet > it generates a StreamingAgg operator and then fails trying to compile it's > generated code. > {code} > 0: jdbc:drill:schema=dfs.tmp> select lead(col0) from `fewRowsAllData.parquet`; > java.lang.RuntimeException: java.sql.SQLException: SYSTEM ERROR: > CompileException: Line 95, Column 62: Unknown variable or type "index" > Fragment 0:0 > [Error Id: 0d967bd7-36f6-4c8d-a574-9d67d7b22f7e on centos-01.qa.lab:31010] > at sqlline.IncrementalRows.hasNext(IncrementalRows.java:73) > at > sqlline.TableOutputFormat$ResizingRowsProvider.next(TableOutputFormat.java:87) > at sqlline.TableOutputFormat.print(TableOutputFormat.java:118) > at sqlline.SqlLine.print(SqlLine.java:1583) > at sqlline.Commands.execute(Commands.java:852) > at sqlline.Commands.sql(Commands.java:751) > at sqlline.SqlLine.dispatch(SqlLine.java:738) > at sqlline.SqlLine.begin(SqlLine.java:612) > at sqlline.SqlLine.start(SqlLine.java:366) > at sqlline.SqlLine.main(SqlLine.java:259) > {code} > Here is the plan for such query: > {noformat} > 0: jdbc:drill:> explain plan for select lead(col0) from > `fewRowsAllData.parquet`; > +------+------+ > | text | json | > +------+------+ > | 00-00 Screen > 00-01 Project(EXPR$0=[$0]) > 00-02 StreamAgg(group=[{}], EXPR$0=[LEAD($0)]) > 00-03 Scan(groupscan=[ParquetGroupScan [entries=[ReadEntryWithPath > [path=file:/Users/hakim/MapR/data/3601.parquet]], > selectionRoot=file:/Users/hakim/MapR/data/fewRowsAllData.parquet, numFiles=1, > columns=[`col0`]]]) > {noformat} -- This message was sent by Atlassian JIRA (v6.3.4#6332)