[jira] [Commented] (DRILL-3697) REGEXP_REPLACE doc. says POSIX reg. expr.; which? not Java?

2015-08-24 Thread Kristine Hahn (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3697?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14709256#comment-14709256 ] Kristine Hahn commented on DRILL-3697: -- Fixed on the staging site:

[jira] [Assigned] (DRILL-3697) REGEXP_REPLACE doc. says POSIX reg. expr.; which? not Java?

2015-08-24 Thread Kristine Hahn (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3697?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Kristine Hahn reassigned DRILL-3697: Assignee: Kristine Hahn REGEXP_REPLACE doc. says POSIX reg. expr.; which? not Java?

[jira] [Commented] (DRILL-3682) Inaccurate documentation for contributors

2015-08-24 Thread Kristine Hahn (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3682?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14709287#comment-14709287 ] Kristine Hahn commented on DRILL-3682: -- We will need help from Dev to correct the

[jira] [Updated] (DRILL-3689) incorrect results : aggregate AVG returns wrong results over results returned by LEAD function.

2015-08-24 Thread Deneche A. Hakim (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3689?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Deneche A. Hakim updated DRILL-3689: Component/s: (was: Execution - Flow) Execution - Relational Operators

[jira] [Updated] (DRILL-3689) incorrect results : aggregate AVG returns wrong results over results returned by LEAD function.

2015-08-24 Thread Deneche A. Hakim (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3689?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Deneche A. Hakim updated DRILL-3689: Fix Version/s: 1.2.0 incorrect results : aggregate AVG returns wrong results over results

[jira] [Commented] (DRILL-3616) Memory leak in a cleanup code after canceling queries with window functions spilling to disk

2015-08-24 Thread ASF GitHub Bot (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3616?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14709425#comment-14709425 ] ASF GitHub Bot commented on DRILL-3616: --- Github user adeneche closed the pull

[jira] [Commented] (DRILL-3698) Expose Show Files Command As SQL for sorting/filtering

2015-08-24 Thread Paul Mogren (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3698?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14709394#comment-14709394 ] Paul Mogren commented on DRILL-3698: +1 for providing table-like access via

[jira] [Commented] (DRILL-3689) incorrect results : aggregate AVG returns wrong results over results returned by LEAD function.

2015-08-24 Thread Deneche A. Hakim (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3689?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14709463#comment-14709463 ] Deneche A. Hakim commented on DRILL-3689: - Looking at the output of the inner

[jira] [Updated] (DRILL-3689) incorrect results : aggregate AVG returns wrong results over results returned by LEAD function.

2015-08-24 Thread Deneche A. Hakim (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3689?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Deneche A. Hakim updated DRILL-3689: Assignee: Khurram Faraaz (was: Deneche A. Hakim) incorrect results : aggregate AVG

[jira] [Updated] (DRILL-3700) Exception in a query with multiple fist_value window functions with different partitions

2015-08-24 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3700?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3700: Description: {code} alter session set `planner.slice_target` = 1; select

[jira] [Commented] (DRILL-3679) IOB Exception : when window functions used in outer and inner query

2015-08-24 Thread Deneche A. Hakim (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3679?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14709493#comment-14709493 ] Deneche A. Hakim commented on DRILL-3679: - Looking at the plan, this looks similar

[jira] [Updated] (DRILL-3679) IOB Exception : when window functions used in outer and inner query

2015-08-24 Thread Deneche A. Hakim (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3679?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Deneche A. Hakim updated DRILL-3679: Assignee: Jinfeng Ni (was: Deneche A. Hakim) IOB Exception : when window functions used

[jira] [Commented] (DRILL-3700) Exception in a query with multiple fist_value window functions with different partitions

2015-08-24 Thread Deneche A. Hakim (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3700?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14709520#comment-14709520 ] Deneche A. Hakim commented on DRILL-3700: - it's most likely a bug in the Window

[jira] [Updated] (DRILL-3700) Exception in a query with multiple fist_value window functions with different partitions

2015-08-24 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3700?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3700: Attachment: j6.tar Exception in a query with multiple fist_value window functions with

[jira] [Updated] (DRILL-3700) Exception in a query with multiple fist_value window functions with different partitions

2015-08-24 Thread Deneche A. Hakim (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3700?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Deneche A. Hakim updated DRILL-3700: Labels: window_function (was: ) Exception in a query with multiple fist_value window

[jira] [Assigned] (DRILL-3700) Exception in a query with multiple fist_value window functions with different partitions

2015-08-24 Thread Deneche A. Hakim (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3700?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Deneche A. Hakim reassigned DRILL-3700: --- Assignee: Deneche A. Hakim (was: Chris Westin) Exception in a query with multiple

[jira] [Resolved] (DRILL-3685) Failure to execute query with NTILE and ROW_NUMBER window functions with different window definitions

2015-08-24 Thread Deneche A. Hakim (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3685?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Deneche A. Hakim resolved DRILL-3685. - Resolution: Cannot Reproduce Couldn't reproduce on master Failure to execute query with

[jira] [Created] (DRILL-3700) Exception in a query with multiple fist_value window functions with different partitions

2015-08-24 Thread Victoria Markman (JIRA)
Victoria Markman created DRILL-3700: --- Summary: Exception in a query with multiple fist_value window functions with different partitions Key: DRILL-3700 URL: https://issues.apache.org/jira/browse/DRILL-3700

[jira] [Updated] (DRILL-3679) IOB Exception : when window functions used in outer and inner query

2015-08-24 Thread Deneche A. Hakim (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3679?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Deneche A. Hakim updated DRILL-3679: Component/s: (was: Execution - Relational Operators) Query Planning

[jira] [Updated] (DRILL-3700) Exception in a query with multiple fist_value window functions with different partitions

2015-08-24 Thread Deneche A. Hakim (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3700?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Deneche A. Hakim updated DRILL-3700: Fix Version/s: 1.2.0 Exception in a query with multiple fist_value window functions with

[jira] [Resolved] (DRILL-3685) Failure to execute query with NTILE and ROW_NUMBER window functions with different window definitions

2015-08-24 Thread Deneche A. Hakim (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3685?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Deneche A. Hakim resolved DRILL-3685. - Resolution: Fixed seems to be fixed in master Failure to execute query with NTILE and

[jira] [Reopened] (DRILL-3685) Failure to execute query with NTILE and ROW_NUMBER window functions with different window definitions

2015-08-24 Thread Deneche A. Hakim (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3685?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Deneche A. Hakim reopened DRILL-3685: - Failure to execute query with NTILE and ROW_NUMBER window functions with different window

[jira] [Commented] (DRILL-3523) Drill client CLI does not reconnect to Drillbit after long period of inactivity

2015-08-24 Thread Daniel Barclay (Drill) (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3523?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14709637#comment-14709637 ] Daniel Barclay (Drill) commented on DRILL-3523: --- Regarding the seeming

[jira] [Created] (DRILL-3701) question : getTime and getTimestamp compatibility from JDBC

2015-08-24 Thread Khurram Faraaz (JIRA)
Khurram Faraaz created DRILL-3701: - Summary: question : getTime and getTimestamp compatibility from JDBC Key: DRILL-3701 URL: https://issues.apache.org/jira/browse/DRILL-3701 Project: Apache Drill

[jira] [Updated] (DRILL-3356) RPC-level data is missing data needed for result set metadata

2015-08-24 Thread Daniel Barclay (Drill) (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3356?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Daniel Barclay (Drill) updated DRILL-3356: -- Priority: Critical (was: Major) RPC-level data is missing data needed for

[jira] [Comment Edited] (DRILL-2769) many(?) JDBC methods throw non-SQLException exceptions (e.g., UnsupportedOperationException, RuntimeException)

2015-08-24 Thread Daniel Barclay (Drill) (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2769?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14709761#comment-14709761 ] Daniel Barclay (Drill) edited comment on DRILL-2769 at 8/24/15 6:19 PM:

[jira] [Commented] (DRILL-2769) many(?) JDBC methods throw non-SQLException exceptions (e.g., UnsupportedOperationException, RuntimeException)

2015-08-24 Thread Daniel Barclay (Drill) (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2769?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14709761#comment-14709761 ] Daniel Barclay (Drill) commented on DRILL-2769: --- Notes on

[jira] [Updated] (DRILL-3669) fix missing direct dependency

2015-08-24 Thread Julien Le Dem (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3669?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julien Le Dem updated DRILL-3669: - Assignee: Jason Altekruse (was: Julien Le Dem) fix missing direct dependency

[jira] [Commented] (DRILL-3643) NTILE(0) returns RuntimeException

2015-08-24 Thread Aman Sinha (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3643?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14708872#comment-14708872 ] Aman Sinha commented on DRILL-3643: --- DRILL-3643: Changes look good. +1 DRILL-3654 and

[jira] [Created] (DRILL-3699) Avro file format should validate the query with schema before processing.

2015-08-24 Thread Bhallamudi Venkata Siva Kamesh (JIRA)
Bhallamudi Venkata Siva Kamesh created DRILL-3699: - Summary: Avro file format should validate the query with schema before processing. Key: DRILL-3699 URL:

[jira] [Created] (DRILL-3702) PartitionPruning hit ClassCastException in Interpreter when the pruning filter expression is of non-nullable type.

2015-08-24 Thread Jinfeng Ni (JIRA)
Jinfeng Ni created DRILL-3702: - Summary: PartitionPruning hit ClassCastException in Interpreter when the pruning filter expression is of non-nullable type. Key: DRILL-3702 URL:

[jira] [Created] (DRILL-3703) TopLevelAllocator has a public static mutable field set as a side effect of its Constructor

2015-08-24 Thread Julien Le Dem (JIRA)
Julien Le Dem created DRILL-3703: Summary: TopLevelAllocator has a public static mutable field set as a side effect of its Constructor Key: DRILL-3703 URL: https://issues.apache.org/jira/browse/DRILL-3703

[jira] [Commented] (DRILL-2743) Parquet file metadata caching

2015-08-24 Thread Rahul Challapalli (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2743?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14710026#comment-14710026 ] Rahul Challapalli commented on DRILL-2743: -- Steven, I see block locations as

[jira] [Commented] (DRILL-2743) Parquet file metadata caching

2015-08-24 Thread Steven Phillips (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2743?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14710078#comment-14710078 ] Steven Phillips commented on DRILL-2743: No, this case is not dealt with, so it is

[jira] [Commented] (DRILL-3596) Allow only (expression) or (expression, 1) for LEAD and LAG window functions as input parameters

2015-08-24 Thread ASF GitHub Bot (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3596?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14710125#comment-14710125 ] ASF GitHub Bot commented on DRILL-3596: --- GitHub user adeneche opened a pull request:

[jira] [Updated] (DRILL-3596) Allow only (expression) or (expression, 1) for LEAD and LAG window functions as input parameters

2015-08-24 Thread Deneche A. Hakim (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3596?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Deneche A. Hakim updated DRILL-3596: Assignee: Aman Sinha (was: Deneche A. Hakim) Allow only (expression) or (expression, 1)

[jira] [Commented] (DRILL-3493) Alter session command with an option to cancel query in a particular phase of execution

2015-08-24 Thread Deneche A. Hakim (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3493?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14710303#comment-14710303 ] Deneche A. Hakim commented on DRILL-3493: - The way I was thinking of implementing

[jira] [Created] (DRILL-3705) Query runs out of memory, reported as FAILED and leaves thread running

2015-08-24 Thread Victoria Markman (JIRA)
Victoria Markman created DRILL-3705: --- Summary: Query runs out of memory, reported as FAILED and leaves thread running Key: DRILL-3705 URL: https://issues.apache.org/jira/browse/DRILL-3705 Project:

[jira] [Commented] (DRILL-3493) Alter session command with an option to cancel query in a particular phase of execution

2015-08-24 Thread Chris Westin (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3493?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14710313#comment-14710313 ] Chris Westin commented on DRILL-3493: - [~adeneche], because of the EventProcessor, I

[jira] [Updated] (DRILL-3704) Document precedence of operators in Drill

2015-08-24 Thread Abhishek Girish (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3704?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Abhishek Girish updated DRILL-3704: --- Description: I couldn't find documentation of precedence of SQL operators in Apache Drill.

[jira] [Created] (DRILL-3704) Document precedence of operators in Drill

2015-08-24 Thread Abhishek Girish (JIRA)
Abhishek Girish created DRILL-3704: -- Summary: Document precedence of operators in Drill Key: DRILL-3704 URL: https://issues.apache.org/jira/browse/DRILL-3704 Project: Apache Drill Issue

[jira] [Commented] (DRILL-3493) Alter session command with an option to cancel query in a particular phase of execution

2015-08-24 Thread Chris Westin (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3493?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14710253#comment-14710253 ] Chris Westin commented on DRILL-3493: - I talked this over with [~sudheeshkatkam], and

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

2015-08-24 Thread Sean Hsuan-Yi Chu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3580?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14710416#comment-14710416 ] Sean Hsuan-Yi Chu commented on DRILL-3580: -- [~amansinha100] I have an

[jira] [Commented] (DRILL-3596) Allow only (expression) or (expression, 1) for LEAD and LAG window functions as input parameters

2015-08-24 Thread Deneche A. Hakim (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3596?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14710157#comment-14710157 ] Deneche A. Hakim commented on DRILL-3596: - [~amansinha100] can you please review ?

[jira] [Updated] (DRILL-3703) TopLevelAllocator has a public static mutable field set as a side effect of its Constructor

2015-08-24 Thread Jason Altekruse (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3703?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jason Altekruse updated DRILL-3703: --- Assignee: Sudheesh Katkam (was: Chris Westin) TopLevelAllocator has a public static mutable

[jira] [Commented] (DRILL-3703) TopLevelAllocator has a public static mutable field set as a side effect of its Constructor

2015-08-24 Thread Jason Altekruse (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3703?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14710166#comment-14710166 ] Jason Altekruse commented on DRILL-3703: [~sudheeshkatkam] Can you try to refactor

[jira] [Updated] (DRILL-3705) Query runs out of memory, reported as FAILED and leaves thread running

2015-08-24 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3705?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3705: Attachment: jstack.txt 2a2451ec-09d8-9f26-e856-5fd349ae72fd.sys.drill

[jira] [Assigned] (DRILL-3654) FIRST_VALUE(char-column/varchar-column) returns IOB Exception

2015-08-24 Thread Deneche A. Hakim (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3654?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Deneche A. Hakim reassigned DRILL-3654: --- Assignee: Deneche A. Hakim (was: Aman Sinha)

[jira] [Assigned] (DRILL-3643) NTILE(0) returns RuntimeException

2015-08-24 Thread Deneche A. Hakim (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3643?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Deneche A. Hakim reassigned DRILL-3643: --- Assignee: Deneche A. Hakim (was: Aman Sinha) NTILE(0) returns RuntimeException

[jira] [Closed] (DRILL-3618) Documentation on drill.apache.org/docs needs to be corrected

2015-08-24 Thread Abhishek Girish (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3618?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Abhishek Girish closed DRILL-3618. -- Documentation on drill.apache.org/docs needs to be corrected