[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 > --

[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-tabpanel&focusedCommentId=14710416#comment-14710416 ] Sean Hsuan-Yi Chu commented on DRILL-3580: -- [~amansinha100] I have an implementat

[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] [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-tabpanel&focusedCommentId=14710313#comment-14710313 ] Chris Westin commented on DRILL-3493: - [~adeneche], because of the EventProcessor, I t

[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 Deneche A. Hakim (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3493?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14710303#comment-14710303 ] Deneche A. Hakim commented on DRILL-3493: - The way I was thinking of implementing

[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 Type

[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. If

[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-tabpanel&focusedCommentId=14710253#comment-14710253 ] Chris Westin commented on DRILL-3493: - I talked this over with [~sudheeshkatkam], and

[jira] [Assigned] (DRILL-3654) FIRST_VALUE(/) 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) > FIRST_VALUE(/) returns IOB Exception

[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] [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-tabpanel&focusedCommentId=14710166#comment-14710166 ] Jason Altekruse commented on DRILL-3703: [~sudheeshkatkam] Can you try to refactor

[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-3596) Allow only () or (, 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-tabpanel&focusedCommentId=14710157#comment-14710157 ] Deneche A. Hakim commented on DRILL-3596: - [~amansinha100] can you please review ?

[jira] [Updated] (DRILL-3596) Allow only () or (, 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 () or (, 1) for LEAD and LAG wind

[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] [Updated] (DRILL-3701) getTime and getTimestamp compatibility from JDBC

2015-08-24 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3701?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Khurram Faraaz updated DRILL-3701: -- Summary: getTime and getTimestamp compatibility from JDBC (was: question : getTime and getTimes

[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: https://issues.apache.org/jira/browse/DR

[jira] [Commented] (DRILL-3596) Allow only () or (, 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-tabpanel&focusedCommentId=14710125#comment-14710125 ] ASF GitHub Bot commented on DRILL-3596: --- GitHub user adeneche opened a pull request:

[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-tabpanel&focusedCommentId=14710078#comment-14710078 ] Steven Phillips commented on DRILL-2743: No, this case is not dealt with, so it is

[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-tabpanel&focusedCommentId=14710026#comment-14710026 ] Rahul Challapalli commented on DRILL-2743: -- Steven, I see block locations as par

[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] [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-tabpanel&focusedCommentId=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-tabpanel&focusedCommentId=14709761#comment-14709761 ] Daniel Barclay (Drill) commented on DRILL-2769: --- Notes on UnsupportedOperati

[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] [Issue Comment Deleted] (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 updated DRILL-3685: Comment: was deleted (was: Couldn't reproduce on master) > Failure to execute query with NT

[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-tabpanel&focusedCommentId=14709637#comment-14709637 ] Daniel Barclay (Drill) commented on DRILL-3523: --- Regarding the seeming timeo

[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] [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 R

[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 res

[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] [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-tabpanel&focusedCommentId=14709520#comment-14709520 ] Deneche A. Hakim commented on DRILL-3700: - it's most likely a bug in the Window fu

[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 d

[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 func

[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] [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 & Op

[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 i

[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-tabpanel&focusedCommentId=14709493#comment-14709493 ] Deneche A. Hakim commented on DRILL-3679: - Looking at the plan, this looks similar

[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 first_value

[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-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 dif

[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-tabpanel&focusedCommentId=14709463#comment-14709463 ] Deneche A. Hakim commented on DRILL-3689: - Looking at the output of the inner quer

[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 return

[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-tabpanel&focusedCommentId=14709425#comment-14709425 ] ASF GitHub Bot commented on DRILL-3616: --- Github user adeneche closed the pull reques

[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] [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] [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-tabpanel&focusedCommentId=14709394#comment-14709394 ] Paul Mogren commented on DRILL-3698: +1 for providing table-like access via INFORMATIO

[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-tabpanel&focusedCommentId=14709287#comment-14709287 ] Kristine Hahn commented on DRILL-3682: -- We will need help from Dev to correct the doc

[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-tabpanel&focusedCommentId=14709256#comment-14709256 ] Kristine Hahn commented on DRILL-3697: -- Fixed on the staging site: http://kristineha

[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] [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: https://issues.apache.org/jira/browse/DRI