[jira] [Created] (DRILL-7420) window function improve ROWS clause/frame possibilities

benj created DRILL-7420: --- Summary: window function improve ROWS clause/frame possibilities Key: DRILL-7420 URL: https://issues.apache.org/jira/browse/DRILL-7420 Project: Apache Drill Issue Type: New

[jira] [Created] (DRILL-7404) window function RANGE with compound ORDER BY

benj created DRILL-7404: --- Summary: window function RANGE with compound ORDER BY Key: DRILL-7404 URL: https://issues.apache.org/jira/browse/DRILL-7404 Project: Apache Drill Issue Type: Improvement

[jira] [Resolved] (DRILL-7034) Window function over a malformed CSV file crashes the JVM

[ https://issues.apache.org/jira/browse/DRILL-7034?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Arina Ielchiieva resolved DRILL-7034. - Resolution: Fixed > Window function over a malformed CSV file crashes the

[jira] [Created] (DRILL-7034) Window function over a malformed CSV file crashes the JVM

Boaz Ben-Zvi created DRILL-7034: --- Summary: Window function over a malformed CSV file crashes the JVM Key: DRILL-7034 URL: https://issues.apache.org/jira/browse/DRILL-7034 Project: Apache Drill

[jira] [Created] (DRILL-6395) Value Window Function - LEAD and LAG on VarChar result in "No applicable constructor/method found" error

Raymond Wong created DRILL-6395: --- Summary: Value Window Function - LEAD and LAG on VarChar result in "No applicable constructor/method found" error Key: DRILL-6395 URL: https://issues.apache.org/jira/br

[jira] [Created] (DRILL-5916) Drill document window function example on LAST_VALUE is incorrect

Raymond Wong created DRILL-5916: --- Summary: Drill document window function example on LAST_VALUE is incorrect Key: DRILL-5916 URL: https://issues.apache.org/jira/browse/DRILL-5916 Project: Apache Drill

[jira] [Resolved] (DRILL-3241) Query with window function runs out of direct memory and does not report back to client that it did

[ https://issues.apache.org/jira/browse/DRILL-3241?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Khurram Faraaz resolved DRILL-3241. --- Resolution: Fixed > Query with window function runs out of direct memory and does not rep

Re: Window function

created to track this. > > > On Sat, Dec 3, 2016 at 5:46 PM, Khurram Faraaz <kfar...@maprtech.com> > wrote: > > > Hakim, thanks for sharing those details and the explanation. > > I will file a JIRA and anyone interested can pick it up and provide the > > fix

Re: Window function

Hakim, thanks for sharing those details and the explanation. I will file a JIRA and anyone interested can pick it up and provide the fix to support OFFSET values greater than one for LAG window function. Regards, Khurram On Fri, Dec 2, 2016 at 10:18 PM, deneche abdelhakim <adene...@gmail.

Re: Window function

any help on this ? from class NoFrameSupportTemplate, I see that inIndex is hard coded to point to previous row in case of lag and next row in case of lead. Is there a way I can modify this and pass it as parameter to pic appropriate row? On Fri, Nov 25, 2016 at 2:57 PM, Nitin Pawar

Re: Window function

adding dev list for comments On Wed, Nov 23, 2016 at 7:04 PM, Nitin Pawar wrote: > Hi, > > according to DRILL-3596 , > lead or lag function are limited to use offset as 1. > > according to documentation on postgres >

[jira] [Created] (DRILL-4847) Window function query results in OOM Exception.

Khurram Faraaz created DRILL-4847: - Summary: Window function query results in OOM Exception. Key: DRILL-4847 URL: https://issues.apache.org/jira/browse/DRILL-4847 Project: Apache Drill Issue

[jira] [Created] (DRILL-4810) CalciteContextException - SELECT star, window function

Khurram Faraaz created DRILL-4810: - Summary: CalciteContextException - SELECT star, window function Key: DRILL-4810 URL: https://issues.apache.org/jira/browse/DRILL-4810 Project: Apache Drill

[jira] [Created] (DRILL-4808) CTE query with window function results in AssertionError

Khurram Faraaz created DRILL-4808: - Summary: CTE query with window function results in AssertionError Key: DRILL-4808 URL: https://issues.apache.org/jira/browse/DRILL-4808 Project: Apache Drill

[jira] [Created] (DRILL-4512) Revisit the changes for DRILL-3404 (using SUM0 for window function)

Aman Sinha created DRILL-4512: - Summary: Revisit the changes for DRILL-3404 (using SUM0 for window function) Key: DRILL-4512 URL: https://issues.apache.org/jira/browse/DRILL-4512 Project: Apache Drill

[jira] [Resolved] (DRILL-4457) Difference in results returned by window function over BIGINT data

nce in results returned by window function over BIGINT data > -- > > Key: DRILL-4457 > URL: https://issues.apache.org/jira/browse/DRILL-4457 > Project: Apache Drill >

[jira] [Created] (DRILL-4453) Difference in results over char data, window function query

Khurram Faraaz created DRILL-4453: - Summary: Difference in results over char data, window function query Key: DRILL-4453 URL: https://issues.apache.org/jira/browse/DRILL-4453 Project: Apache Drill

[jira] [Created] (DRILL-4444) Window function query results in IllegalStateException

Khurram Faraaz created DRILL-: - Summary: Window function query results in IllegalStateException Key: DRILL- URL: https://issues.apache.org/jira/browse/DRILL- Project: Apache Drill

[jira] [Resolved] (DRILL-4148) NullPointerException in planning when running window function query

[ https://issues.apache.org/jira/browse/DRILL-4148?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sean Hsuan-Yi Chu resolved DRILL-4148. -- Resolution: Cannot Reproduce > NullPointerException in planning when running win

[jira] [Created] (DRILL-4320) Difference in query plan on JDK8 for window function query

Khurram Faraaz created DRILL-4320: - Summary: Difference in query plan on JDK8 for window function query Key: DRILL-4320 URL: https://issues.apache.org/jira/browse/DRILL-4320 Project: Apache Drill

[jira] [Created] (DRILL-4267) Multiple window function operators instead of one

Deneche A. Hakim created DRILL-4267: --- Summary: Multiple window function operators instead of one Key: DRILL-4267 URL: https://issues.apache.org/jira/browse/DRILL-4267 Project: Apache Drill

[jira] [Resolved] (DRILL-3786) Query with window function fails with IllegalFormatConversionException

[ https://issues.apache.org/jira/browse/DRILL-3786?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Deneche A. Hakim resolved DRILL-3786. - Resolution: Fixed Fixed by DRILL-4174 > Query with window function fa

[jira] [Created] (DRILL-4216) Aggregate Window Function COUNT() With GROUP BY Clause expected: range(0, 32768)

PIPELINE created DRILL-4216: --- Summary: Aggregate Window Function COUNT() With GROUP BY Clause expected: range(0, 32768) Key: DRILL-4216 URL: https://issues.apache.org/jira/browse/DRILL-4216 Project: Apache

[GitHub] drill pull request: DRILL-3786: Query with window function fails w...

Github user parthchandra commented on the pull request: https://github.com/apache/drill/pull/239#issuecomment-156506328 +1. Looks good. --- 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

[GitHub] drill pull request: DRILL-3786: Query with window function fails w...

Github user asfgit closed the pull request at: https://github.com/apache/drill/pull/239 --- 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

[jira] [Resolved] (DRILL-4061) Incorrect results returned by window function query.

[ https://issues.apache.org/jira/browse/DRILL-4061?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Khurram Faraaz resolved DRILL-4061. --- Resolution: Not A Problem > Incorrect results returned by window function qu

[jira] [Created] (DRILL-4061) Incorrect results returned by window function query.

Khurram Faraaz created DRILL-4061: - Summary: Incorrect results returned by window function query. Key: DRILL-4061 URL: https://issues.apache.org/jira/browse/DRILL-4061 Project: Apache Drill

[jira] [Resolved] (DRILL-3770) Query with window function having just ORDER BY clause runs out of memory on large datasets

by DRILL-3952 > Query with window function having just ORDER BY clause runs out of memory on > large datasets > --- > > Key: DRILL-3770 > URL: https://issu

[jira] [Created] (DRILL-3786) Query with window function fails with IllegalFormatConversionException

Abhishek Girish created DRILL-3786: -- Summary: Query with window function fails with IllegalFormatConversionException Key: DRILL-3786 URL: https://issues.apache.org/jira/browse/DRILL-3786 Project

[jira] [Resolved] (DRILL-3677) Wrong result with LEAD window function when used in multiple windows in the same query

[ https://issues.apache.org/jira/browse/DRILL-3677?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman resolved DRILL-3677. - Resolution: Invalid Wrong result with LEAD window function when used in multiple windows

[jira] [Created] (DRILL-3677) Wrong result with LEAD window function when used in multiple windows in the same query

Victoria Markman created DRILL-3677: --- Summary: Wrong result with LEAD window function when used in multiple windows in the same query Key: DRILL-3677 URL: https://issues.apache.org/jira/browse/DRILL-3677

[jira] [Created] (DRILL-3680) window function query returns Incorrect results

Khurram Faraaz created DRILL-3680: - Summary: window function query returns Incorrect results Key: DRILL-3680 URL: https://issues.apache.org/jira/browse/DRILL-3680 Project: Apache Drill

[jira] [Resolved] (DRILL-3619) Add support for NTILE window function

for NTILE window function - Key: DRILL-3619 URL: https://issues.apache.org/jira/browse/DRILL-3619 Project: Apache Drill Issue Type: Sub-task Components: Execution - Relational Operators

Re: Review Request 37515: DRILL-3657: Wrong result with SUM(1) window function when multiple partitions are present

--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/37515/ --- (Updated Aug. 17, 2015, 4:54 p.m.) Review request for drill and Aman Sinha.

Re: Review Request 37515: DRILL-3657: Wrong result with SUM(1) window function when multiple partitions are present

On Aug. 17, 2015, 4:08 p.m., Aman Sinha wrote: exec/java-exec/src/main/java/org/apache/drill/exec/planner/physical/WindowPrule.java, line 159 https://reviews.apache.org/r/37515/diff/1/?file=1041599#file1041599line159 Would this work if there was non-window-agg functions

Re: Review Request 37515: DRILL-3657: Wrong result with SUM(1) window function when multiple partitions are present

--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/37515/#review95592 ---

Review Request 37515: DRILL-3657: Wrong result with SUM(1) window function when multiple partitions are present

--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/37515/ --- Review request for drill and Aman Sinha. Bugs: DRILL-3657

[jira] [Created] (DRILL-3651) Window function should not be allowed in order by clause of over clause of window function

Victoria Markman created DRILL-3651: --- Summary: Window function should not be allowed in order by clause of over clause of window function Key: DRILL-3651 URL: https://issues.apache.org/jira/browse/DRILL-3651

[jira] [Created] (DRILL-3647) Handle null as input to window function NTILE

Khurram Faraaz created DRILL-3647: - Summary: Handle null as input to window function NTILE Key: DRILL-3647 URL: https://issues.apache.org/jira/browse/DRILL-3647 Project: Apache Drill Issue

Re: [jira] [Created] (DRILL-3619) Add support for NTILE window function

Let me know if you want some suggestions for approximate ntile implementations. On Mon, Aug 10, 2015 at 10:42 AM, Deneche A. Hakim (JIRA) j...@apache.org wrote: Deneche A. Hakim created DRILL-3619: --- Summary: Add support for NTILE window

[jira] [Created] (DRILL-3619) Add support for NTILE window function

Deneche A. Hakim created DRILL-3619: --- Summary: Add support for NTILE window function Key: DRILL-3619 URL: https://issues.apache.org/jira/browse/DRILL-3619 Project: Apache Drill Issue Type

Re: [jira] [Created] (DRILL-3619) Add support for NTILE window function

A. Hakim created DRILL-3619: --- Summary: Add support for NTILE window function Key: DRILL-3619 URL: https://issues.apache.org/jira/browse/DRILL-3619 Project: Apache Drill Issue Type

[jira] [Created] (DRILL-3580) wrong plan for window function queries containing function(col1 + colb)

Deneche A. Hakim created DRILL-3580: --- Summary: wrong plan for window function queries containing function(col1 + colb) Key: DRILL-3580 URL: https://issues.apache.org/jira/browse/DRILL-3580 Project

[jira] [Created] (DRILL-3582) Asset with the window function and group by when aggregate is used in order by clause

Victoria Markman created DRILL-3582: --- Summary: Asset with the window function and group by when aggregate is used in order by clause Key: DRILL-3582 URL: https://issues.apache.org/jira/browse/DRILL-3582

[jira] [Created] (DRILL-3574) Wrong result with SUM window function in the query with multiple window definitions

Victoria Markman created DRILL-3574: --- Summary: Wrong result with SUM window function in the query with multiple window definitions Key: DRILL-3574 URL: https://issues.apache.org/jira/browse/DRILL-3574

Re: Review Request 36278: DRILL-3189: Disable DISALLOW PARTIAL in window function grammar

--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/36278/ --- (Updated July 10, 2015, 11:33 p.m.) Review request for drill, Aman Sinha and

Re: Review Request 36278: DRILL-3189: Disable DISALLOW PARTIAL in window function grammar

--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/36278/#review91375 --- Ship it! Ship It! - Aman Sinha On July 10, 2015, 11:33 p.m.,

Re: Review Request 36278: DRILL-3189: Disable DISALLOW PARTIAL in window function grammar

--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/36278/ --- (Updated July 9, 2015, 5:33 p.m.) Review request for drill, Aman Sinha and

[jira] [Created] (DRILL-3481) Query with Window Function fails with SYSTEM ERROR: RpcException: Data not accepted downstream.

Abhishek Girish created DRILL-3481: -- Summary: Query with Window Function fails with SYSTEM ERROR: RpcException: Data not accepted downstream. Key: DRILL-3481 URL: https://issues.apache.org/jira/browse/DRILL-3481

Re: Review Request 36070: DRILL-3243: Need a better error message - Use of alias in window function definition

--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/36070/#review90194 --- Ship it! - Hanifi Gunes On June 30, 2015, 11:20 p.m., abdelhakim

Review Request 36070: DRILL-3243: Need a better error message - Use of alias in window function definition

--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/36070/ --- Review request for drill and Hanifi Gunes. Bugs: DRILL-3243

[jira] [Created] (DRILL-3414) Window function on a null producing column of an outer join results in the wrong result

Victoria Markman created DRILL-3414: --- Summary: Window function on a null producing column of an outer join results in the wrong result Key: DRILL-3414 URL: https://issues.apache.org/jira/browse/DRILL-3414

[jira] [Resolved] (DRILL-3414) Window function on a null producing column of an outer join results in the wrong result

[ https://issues.apache.org/jira/browse/DRILL-3414?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman resolved DRILL-3414. - Resolution: Invalid Window function on a null producing column of an outer join results

[jira] [Resolved] (DRILL-3211) Assert in a query with window function and group by clause

[ https://issues.apache.org/jira/browse/DRILL-3211?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sean Hsuan-Yi Chu resolved DRILL-3211. -- Resolution: Duplicate Assert in a query with window function and group by clause

[jira] [Resolved] (DRILL-3183) When Group By clause is present, the argument in window function should not refer to any column outside Group By

is present, the argument in window function should not refer to any column outside Group By Key: DRILL-3183 URL: https://issues.apache.org/jira/browse

[jira] [Created] (DRILL-3404) Filter on window function does not appear in query plan

Khurram Faraaz created DRILL-3404: - Summary: Filter on window function does not appear in query plan Key: DRILL-3404 URL: https://issues.apache.org/jira/browse/DRILL-3404 Project: Apache Drill

Re: Review Request 35960: DRILL-3307: Query with window function runs out of memory

--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/35960/#review89600 --- Ship it! Ship It! - Steven Phillips On June 27, 2015, 1:12

Re: Review Request 35609: DRILL-3243: Need a better error message - Use of alias in window function definition

--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/35609/ --- (Updated June 25, 2015, 3:52 p.m.) Review request for drill and Hanifi Gunes.

[jira] [Created] (DRILL-3352) Extra re-distribution when evaluating window function after GROUP BY

Aman Sinha created DRILL-3352: - Summary: Extra re-distribution when evaluating window function after GROUP BY Key: DRILL-3352 URL: https://issues.apache.org/jira/browse/DRILL-3352 Project: Apache Drill

[jira] [Created] (DRILL-3358) CUME_DIST window function provides wrong result when only ORDER BY clause is specified

Abhishek Girish created DRILL-3358: -- Summary: CUME_DIST window function provides wrong result when only ORDER BY clause is specified Key: DRILL-3358 URL: https://issues.apache.org/jira/browse/DRILL-3358

[jira] [Created] (DRILL-3359) Drill should throw and error when window function defined using WINDOW AS uses ROWS UNBOUNDED PRECEDING

Deneche A. Hakim created DRILL-3359: --- Summary: Drill should throw and error when window function defined using WINDOW AS uses ROWS UNBOUNDED PRECEDING Key: DRILL-3359 URL: https://issues.apache.org/jira/browse

[jira] [Resolved] (DRILL-3358) CUME_DIST window function provides wrong result when only ORDER BY clause is specified

[ https://issues.apache.org/jira/browse/DRILL-3358?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Deneche A. Hakim resolved DRILL-3358. - Resolution: Duplicate CUME_DIST window function provides wrong result when only ORDER

[jira] [Created] (DRILL-3365) Query with window function on large dataset fails with IOException: Mkdirs failed to create spill directory

Abhishek Girish created DRILL-3365: -- Summary: Query with window function on large dataset fails with IOException: Mkdirs failed to create spill directory Key: DRILL-3365 URL: https://issues.apache.org/jira

Re: Review Request 35609: DRILL-3243: Need a better error message - Use of alias in window function definition

--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/35609/#review89036 --- Ship it! Ship It! - Hanifi Gunes On June 18, 2015, 3:14 p.m.,

[jira] [Created] (DRILL-3337) Queries with Window Function DENSE_RANK fail with SchemaChangeException

Abhishek Girish created DRILL-3337: -- Summary: Queries with Window Function DENSE_RANK fail with SchemaChangeException Key: DRILL-3337 URL: https://issues.apache.org/jira/browse/DRILL-3337 Project

[jira] [Resolved] (DRILL-3293) CTAS with window function fails with UnsupportedOperationException

[ https://issues.apache.org/jira/browse/DRILL-3293?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni resolved DRILL-3293. --- Resolution: Fixed fixed in commit: ffae1691c0cd526ed1095fbabbc0855d016790d7 CTAS with window

[jira] [Resolved] (DRILL-3265) Query with window function and sort below that spills to disk runs out of memory

[ https://issues.apache.org/jira/browse/DRILL-3265?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman resolved DRILL-3265. - Resolution: Fixed Query with window function and sort below that spills to disk runs out

[jira] [Resolved] (DRILL-3294) False schema change exception in CTAS with AVG window function

change exception in CTAS with AVG window function -- Key: DRILL-3294 URL: https://issues.apache.org/jira/browse/DRILL-3294 Project: Apache Drill Issue Type: Bug Components

Re: Review Request 35584: DRILL-3298: fix wrong result for window function query when no partition-by is present

--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/35584/ --- (Updated June 18, 2015, 7:07 p.m.) Review request for drill and Jinfeng Ni.

Re: Review Request 35584: DRILL-3298: fix wrong result for window function query when no partition-by is present

On June 18, 2015, 1:11 a.m., Jinfeng Ni wrote: exec/java-exec/src/main/java/org/apache/drill/exec/planner/physical/WindowPrule.java, line 64 https://reviews.apache.org/r/35584/diff/1/?file=986627#file986627line64 This might not be related to this JIRA. But I feel this for loop is

Re: Review Request 35584: DRILL-3298: fix wrong result for window function query when no partition-by is present

--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/35584/#review88432 --- Ship it! Ship It! - Jinfeng Ni On June 18, 2015, 12:07 p.m.,

[jira] [Created] (DRILL-3307) Query with window function runs out of memory

Abhishek Girish created DRILL-3307: -- Summary: Query with window function runs out of memory Key: DRILL-3307 URL: https://issues.apache.org/jira/browse/DRILL-3307 Project: Apache Drill Issue

Review Request 35584: DRILL-3298: fix wrong result for window function query when no partition-by is present

--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/35584/ --- Review request for drill and Jinfeng Ni. Bugs: DRILL-3298

Re: Review Request 35584: DRILL-3298: fix wrong result for window function query when no partition-by is present

On June 18, 2015, 1:11 a.m., Jinfeng Ni wrote: exec/java-exec/src/main/java/org/apache/drill/exec/planner/physical/WindowPrule.java, line 64 https://reviews.apache.org/r/35584/diff/1/?file=986627#file986627line64 This might not be related to this JIRA. But I feel this for loop is

Re: Review Request 35584: DRILL-3298: fix wrong result for window function query when no partition-by is present

--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/35584/#review88321 ---

[jira] [Created] (DRILL-3294) False schema change exception in CTAS with AVG window function

Victoria Markman created DRILL-3294: --- Summary: False schema change exception in CTAS with AVG window function Key: DRILL-3294 URL: https://issues.apache.org/jira/browse/DRILL-3294 Project: Apache

[jira] [Created] (DRILL-3293) CTAS with window function fails with NPE

Victoria Markman created DRILL-3293: --- Summary: CTAS with window function fails with NPE Key: DRILL-3293 URL: https://issues.apache.org/jira/browse/DRILL-3293 Project: Apache Drill Issue

[jira] [Created] (DRILL-3298) Wrong result with SUM window function and order by without partition by in the OVER clause

Victoria Markman created DRILL-3298: --- Summary: Wrong result with SUM window function and order by without partition by in the OVER clause Key: DRILL-3298 URL: https://issues.apache.org/jira/browse/DRILL-3298

[jira] [Created] (DRILL-3280) Missing OVER clause in window function query results in AssertionError

Khurram Faraaz created DRILL-3280: - Summary: Missing OVER clause in window function query results in AssertionError Key: DRILL-3280 URL: https://issues.apache.org/jira/browse/DRILL-3280 Project

[jira] [Created] (DRILL-3265) Query with window function and sort below that spills to disk runs out of memory

Victoria Markman created DRILL-3265: --- Summary: Query with window function and sort below that spills to disk runs out of memory Key: DRILL-3265 URL: https://issues.apache.org/jira/browse/DRILL-3265

Re: Window function query takes too long to complete and return results

please open a JIRA issue. please provide the test file (compressed) or a script to generate similar data. Thanks! On Tue, Jun 9, 2015 at 6:55 PM, Khurram Faraaz kfar...@maprtech.com wrote: Query that uses window functions takes too long to complete and return results. It returns close to a

Window function query takes too long to complete and return results

Query that uses window functions takes too long to complete and return results. It returns close to a million records, for which it took 533.8 seconds ~8 minutes Input CSV file has two columns, one integer and another varchar type column. Please let me know if this needs to be investigated and I

[jira] [Created] (DRILL-3269) Window function query takes too long to complete and return results

Khurram Faraaz created DRILL-3269: - Summary: Window function query takes too long to complete and return results Key: DRILL-3269 URL: https://issues.apache.org/jira/browse/DRILL-3269 Project: Apache

Re: Window function query takes too long to complete and return results

In cases like this where you are printing millions of record in SQLLINE, you should pipe the output to /dev/null or to a file, and measure the performance that way. I'm guessing that most of the time in this case is spent printing the output to the console, and thus really unrelated to Drill

[jira] [Created] (DRILL-3241) Query with window function runs out of direct memory and does not report back to client that it did

Victoria Markman created DRILL-3241: --- Summary: Query with window function runs out of direct memory and does not report back to client that it did Key: DRILL-3241 URL: https://issues.apache.org/jira/browse

[jira] [Created] (DRILL-3243) Need a better error message - Use of alias in window function definition

Khurram Faraaz created DRILL-3243: - Summary: Need a better error message - Use of alias in window function definition Key: DRILL-3243 URL: https://issues.apache.org/jira/browse/DRILL-3243 Project

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

Khurram Faraaz created DRILL-3218: - Summary: Window function usage throws CompileException Key: DRILL-3218 URL: https://issues.apache.org/jira/browse/DRILL-3218 Project: Apache Drill Issue

[jira] [Created] (DRILL-3219) Filter is not pushed into subquery with window function

Victoria Markman created DRILL-3219: --- Summary: Filter is not pushed into subquery with window function Key: DRILL-3219 URL: https://issues.apache.org/jira/browse/DRILL-3219 Project: Apache Drill

select * + window function gives strange column names

I have a small json file that contains the following columns: employee_id, position_id, salary, sub and count when I run the following query: select *, count(*) over(partition by position_id) from `myfile.json`; I get this list of columns: T1¦¦employee_id | T1¦¦position_id | T1¦¦sub |

Re: select * + window function gives strange column names

never mind, DRILL-3210 https://issues.apache.org/jira/browse/DRILL-3210 was just filled for a similar problem On Thu, May 28, 2015 at 3:51 PM, Abdel Hakim Deneche adene...@maprtech.com wrote: I have a small json file that contains the following columns: employee_id, position_id, salary, sub

[jira] [Created] (DRILL-3211) Assert in a query with window function and group by clause

Victoria Markman created DRILL-3211: --- Summary: Assert in a query with window function and group by clause Key: DRILL-3211 URL: https://issues.apache.org/jira/browse/DRILL-3211 Project: Apache

[jira] [Created] (DRILL-3181) Change error message to a more clear one when window range is specified for window function

Victoria Markman created DRILL-3181: --- Summary: Change error message to a more clear one when window range is specified for window function Key: DRILL-3181 URL: https://issues.apache.org/jira/browse/DRILL-3181

[jira] [Created] (DRILL-2405) Generate test data for window function instead of downloading it from S3

Deneche A. Hakim created DRILL-2405: --- Summary: Generate test data for window function instead of downloading it from S3 Key: DRILL-2405 URL: https://issues.apache.org/jira/browse/DRILL-2405 Project

Re: Review Request 30051: DRILL-1908: new window function implementation

--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/30051/ --- (Updated March 3, 2015, 10 p.m.) Review request for drill and Jacques Nadeau.

Re: Review Request 30051: DRILL-1908: new window function implementation

--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/30051/ --- (Updated Feb. 12, 2015, 6:20 p.m.) Review request for drill and Jacques

Re: Review Request 30051: DRILL-1908: new window function implementation

On Jan. 30, 2015, 1:12 a.m., Chris Westin wrote: exec/java-exec/src/main/java/org/apache/drill/exec/physical/impl/window/GenerateTestData.java, line 121 https://reviews.apache.org/r/30051/diff/2/?file=826885#file826885line121 Make the file prefix a command-line argument so that

Re: Review Request 30051: DRILL-1908: new window function implementation

On Jan. 24, 2015, 12:20 a.m., abdelhakim deneche wrote: exec/java-exec/src/main/java/org/apache/drill/exec/physical/impl/window/WindowFrameRecordBatch.java, line 85 https://reviews.apache.org/r/30051/diff/3/?file=828946#file828946line85 Yes, especially if the user uses over()

Re: Review Request 30051: DRILL-1908: new window function implementation

On Jan. 26, 2015, 5:51 p.m., Jacques Nadeau wrote: exec/java-exec/src/test/java/org/apache/drill/exec/physical/impl/window/TestWindowFrame.java, line 38 https://reviews.apache.org/r/30051/diff/3/?file=828952#file828952line38 Please add a negative test case when using multiple

Re: Review Request 30051: DRILL-1908: new window function implementation

--- - updated GeneratorMapping and MappingSet variables to follow same convention used in HashJoinBatch and ChainedHashTable - check and disable window function in sql parsing - fail when schema changes - use fail(Exception e) to report errors - rename StreamingWindowPrel/StreamingWindowPrule

Re: Review Request 30051: DRILL-1908: new window function implementation

On Jan. 23, 2015, 11:39 p.m., Chris Westin wrote: exec/java-exec/src/main/java/org/apache/drill/exec/physical/impl/window/WindowFrameRecordBatch.java, line 273 https://reviews.apache.org/r/30051/diff/3/?file=828946#file828946line273 Shouldn't these all be static? No. We should

  1   2   >