[jira] [Comment Edited] (DRILL-3639) Internal error: Error while applying rule PruneScanRule:Filter_On_Scan_Parquet

[ https://issues.apache.org/jira/browse/DRILL-3639?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14696529#comment-14696529 ] Rahul Challapalli edited comment on DRILL-3639 at 8/14/15 6:03 AM:

[jira] [Commented] (DRILL-3639) Internal error: Error while applying rule PruneScanRule:Filter_On_Scan_Parquet

[ https://issues.apache.org/jira/browse/DRILL-3639?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14696528#comment-14696528 ] Rahul Challapalli commented on DRILL-3639: -- The below query still produces an

[jira] [Commented] (DRILL-3639) Internal error: Error while applying rule PruneScanRule:Filter_On_Scan_Parquet

[ https://issues.apache.org/jira/browse/DRILL-3639?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14696529#comment-14696529 ] Rahul Challapalli commented on DRILL-3639: -- I didn't create a new one since this

[jira] [Created] (DRILL-3645) typo in drill documentation

Devender Yadav created DRILL-3645: -- Summary: typo in drill documentation Key: DRILL-3645 URL: https://issues.apache.org/jira/browse/DRILL-3645 Project: Apache Drill Issue Type: Bug

[jira] [Created] (DRILL-3644) Issue in using drill JDBC jar in Java code for Hive storage

Devender Yadav created DRILL-3644: -- Summary: Issue in using drill JDBC jar in Java code for Hive storage Key: DRILL-3644 URL: https://issues.apache.org/jira/browse/DRILL-3644 Project: Apache Drill

[jira] [Updated] (DRILL-3644) Issue in using drill JDBC jar in Java code for Hive storage

[ https://issues.apache.org/jira/browse/DRILL-3644?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Devender Yadav updated DRILL-3644: --- Component/s: Client - JDBC Issue in using drill JDBC jar in Java code for Hive storage

[jira] [Closed] (DRILL-3642) External Sort will leak memory if query is cancelled while it's spilling to disk

[ https://issues.apache.org/jira/browse/DRILL-3642?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Deneche A. Hakim closed DRILL-3642. --- Resolution: Duplicate External Sort will leak memory if query is cancelled while it's

[jira] [Commented] (DRILL-3536) Add support for LEAD, LAG, NTILE, FIRST_VALUE and LAST_VALUE window functions

[ https://issues.apache.org/jira/browse/DRILL-3536?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14697334#comment-14697334 ] Deneche A. Hakim commented on DRILL-3536: - created review request

[jira] [Updated] (DRILL-3649) LEAD , LAG , NTILE , FIRST_VALUE , LAST_VALUE report RuntimeException for missing OVER clause

[ https://issues.apache.org/jira/browse/DRILL-3649?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Deneche A. Hakim updated DRILL-3649: Fix Version/s: 1.2.0 LEAD , LAG , NTILE , FIRST_VALUE , LAST_VALUE report RuntimeException

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

[ https://issues.apache.org/jira/browse/DRILL-3651?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-3651: -- Assignee: Aman Sinha (was: Jinfeng Ni) Window function should not be allowed in order by clause of

[jira] [Commented] (DRILL-3649) LEAD , LAG , NTILE , FIRST_VALUE , LAST_VALUE report RuntimeException for missing OVER clause

[ https://issues.apache.org/jira/browse/DRILL-3649?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14697694#comment-14697694 ] Jinfeng Ni commented on DRILL-3649: --- Assign to Sean, since I believe the fix is in

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

[ https://issues.apache.org/jira/browse/DRILL-3651?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3651: Labels: window_function (was: ) Window function should not be allowed in order by clause

[jira] [Updated] (DRILL-3649) LEAD , LAG , NTILE , FIRST_VALUE , LAST_VALUE report RuntimeException for missing OVER clause

[ https://issues.apache.org/jira/browse/DRILL-3649?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Deneche A. Hakim updated DRILL-3649: Component/s: (was: Execution - Flow) Query Planning Optimization

[jira] [Created] (DRILL-3650) Fetch Parquet Footer times out for a seemingly small parquet files

Deneche A. Hakim created DRILL-3650: --- Summary: Fetch Parquet Footer times out for a seemingly small parquet files Key: DRILL-3650 URL: https://issues.apache.org/jira/browse/DRILL-3650 Project:

[jira] [Updated] (DRILL-3650) Fetch Parquet Footer times out for a seemingly small parquet files

[ https://issues.apache.org/jira/browse/DRILL-3650?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Deneche A. Hakim updated DRILL-3650: Fix Version/s: 1.2.0 Fetch Parquet Footer times out for a seemingly small parquet files

[jira] [Commented] (DRILL-3641) Document RecordBatch.IterOutcome (enumerators and possible sequences)

[ https://issues.apache.org/jira/browse/DRILL-3641?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14697651#comment-14697651 ] ASF GitHub Bot commented on DRILL-3641: --- GitHub user dsbos opened a pull request:

[jira] [Updated] (DRILL-3649) LEAD , LAG , NTILE , FIRST_VALUE , LAST_VALUE report RuntimeException for missing OVER clause

[ https://issues.apache.org/jira/browse/DRILL-3649?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Deneche A. Hakim updated DRILL-3649: Labels: window_function (was: window_funcion) LEAD , LAG , NTILE , FIRST_VALUE ,

[jira] [Commented] (DRILL-3648) NTILE function returns incorrect results

[ https://issues.apache.org/jira/browse/DRILL-3648?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14697525#comment-14697525 ] Deneche A. Hakim commented on DRILL-3648: - The fix will be part of DRILL-3536

[jira] [Updated] (DRILL-3536) Add support for LEAD, LAG, NTILE, FIRST_VALUE and LAST_VALUE window functions

[ https://issues.apache.org/jira/browse/DRILL-3536?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Deneche A. Hakim updated DRILL-3536: Attachment: DRILL-3536.3.patch.txt Add support for LEAD, LAG, NTILE, FIRST_VALUE and

[jira] [Created] (DRILL-3649) LEAD , LAG , NTILE , FIRST_VALUE , LAST_VALUE report RuntimeException for missing OVER clause

Khurram Faraaz created DRILL-3649: - Summary: LEAD , LAG , NTILE , FIRST_VALUE , LAST_VALUE report RuntimeException for missing OVER clause Key: DRILL-3649 URL: https://issues.apache.org/jira/browse/DRILL-3649

[jira] [Updated] (DRILL-3648) NTILE function returns incorrect results

[ https://issues.apache.org/jira/browse/DRILL-3648?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Deneche A. Hakim updated DRILL-3648: Fix Version/s: 1.2.0 NTILE function returns incorrect results

[jira] [Created] (DRILL-3648) NTILE function returns incorrect results

Khurram Faraaz created DRILL-3648: - Summary: NTILE function returns incorrect results Key: DRILL-3648 URL: https://issues.apache.org/jira/browse/DRILL-3648 Project: Apache Drill Issue Type:

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

[ https://issues.apache.org/jira/browse/DRILL-3647?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Khurram Faraaz updated DRILL-3647: -- Assignee: Deneche A. Hakim (was: Chris Westin) Handle null as input to window function NTILE

[jira] [Updated] (DRILL-3648) NTILE function returns incorrect results

[ https://issues.apache.org/jira/browse/DRILL-3648?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Khurram Faraaz updated DRILL-3648: -- Assignee: Deneche A. Hakim (was: Chris Westin) NTILE function returns incorrect results

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

[ https://issues.apache.org/jira/browse/DRILL-3647?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Deneche A. Hakim updated DRILL-3647: Labels: window_function (was: window_funcion) Handle null as input to window function

[jira] [Updated] (DRILL-3630) error message needs to be fixed LEAD , LAG window functions

[ https://issues.apache.org/jira/browse/DRILL-3630?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Deneche A. Hakim updated DRILL-3630: Fix Version/s: 1.2.0 error message needs to be fixed LEAD , LAG window functions

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

[ https://issues.apache.org/jira/browse/DRILL-3643?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Deneche A. Hakim updated DRILL-3643: Fix Version/s: 1.2.0 NTILE(0) returns RuntimeException -

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

[ https://issues.apache.org/jira/browse/DRILL-3643?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Deneche A. Hakim updated DRILL-3643: Labels: window_function (was: window_funcion) NTILE(0) returns RuntimeException

[jira] [Updated] (DRILL-3644) Issue in using drill JDBC jar in Java code for Hive storage

[ https://issues.apache.org/jira/browse/DRILL-3644?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Daniel Barclay (Drill) updated DRILL-3644: -- Component/s: (was: Client - JDBC) Issue in using drill JDBC jar in Java

[jira] [Commented] (DRILL-3644) Issue in using drill JDBC jar in Java code for Hive storage

[ https://issues.apache.org/jira/browse/DRILL-3644?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14697435#comment-14697435 ] Daniel Barclay (Drill) commented on DRILL-3644: --- Workaround: If you

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

[ https://issues.apache.org/jira/browse/DRILL-3616?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Deneche A. Hakim updated DRILL-3616: Assignee: Steven Phillips (was: Deneche A. Hakim) Memory leak in a cleanup code after

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

[ https://issues.apache.org/jira/browse/DRILL-3616?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14697434#comment-14697434 ] ASF GitHub Bot commented on DRILL-3616: --- GitHub user adeneche opened a pull request:

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

[ https://issues.apache.org/jira/browse/DRILL-3616?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Deneche A. Hakim updated DRILL-3616: Attachment: DRILL-3616.1.patch.txt Memory leak in a cleanup code after canceling queries

[jira] [Commented] (DRILL-3648) NTILE function returns incorrect results

[ https://issues.apache.org/jira/browse/DRILL-3648?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14697432#comment-14697432 ] Khurram Faraaz commented on DRILL-3648: --- Here is the repro with a smaller dataset.

[jira] [Updated] (DRILL-3536) Add support for LEAD, LAG, NTILE, FIRST_VALUE and LAST_VALUE window functions

[ https://issues.apache.org/jira/browse/DRILL-3536?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Deneche A. Hakim updated DRILL-3536: Attachment: DRILL-3536.2.patch.txt DRILL-3536.1.patch.txt Add support for

[jira] [Updated] (DRILL-3536) Add support for LEAD, LAG, NTILE, FIRST_VALUE and LAST_VALUE window functions

[ https://issues.apache.org/jira/browse/DRILL-3536?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Deneche A. Hakim updated DRILL-3536: Attachment: (was: DRILL-3536.1.patch.txt) Add support for LEAD, LAG, NTILE,

[jira] [Updated] (DRILL-3648) NTILE function returns incorrect results

[ https://issues.apache.org/jira/browse/DRILL-3648?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Deneche A. Hakim updated DRILL-3648: Priority: Critical (was: Major) NTILE function returns incorrect results

[jira] [Updated] (DRILL-3648) NTILE function returns incorrect results

[ https://issues.apache.org/jira/browse/DRILL-3648?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Deneche A. Hakim updated DRILL-3648: Labels: window_function (was: window_funcion) NTILE function returns incorrect results

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

[ https://issues.apache.org/jira/browse/DRILL-3647?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Deneche A. Hakim updated DRILL-3647: Fix Version/s: 1.2.0 Handle null as input to window function NTILE

[jira] [Updated] (DRILL-3652) Need to document order of operations with window functions and flatten

[ https://issues.apache.org/jira/browse/DRILL-3652?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3652: Labels: window_function (was: ) Need to document order of operations with window

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

[ https://issues.apache.org/jira/browse/DRILL-2743?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14697764#comment-14697764 ] ASF GitHub Bot commented on DRILL-2743: --- GitHub user StevenMPhillips opened a pull

[jira] [Commented] (DRILL-3180) Apache Drill JDBC storage plugin to query rdbms systems such as MySQL and Netezza from Apache Drill

[ https://issues.apache.org/jira/browse/DRILL-3180?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14697837#comment-14697837 ] Jacques Nadeau commented on DRILL-3180: --- I've updated this with some Magnus changes

[jira] [Commented] (DRILL-3649) LEAD , LAG , NTILE , FIRST_VALUE , LAST_VALUE report RuntimeException for missing OVER clause

[ https://issues.apache.org/jira/browse/DRILL-3649?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14697722#comment-14697722 ] Jinfeng Ni commented on DRILL-3649: --- The symptom is different. But the root cause is the

[jira] [Updated] (DRILL-3653) Assert in a query with both avg aggregate and avg window aggregate functions

[ https://issues.apache.org/jira/browse/DRILL-3653?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3653: Description: It seems to be the problem with just this combination and I can't believe I

[jira] [Updated] (DRILL-3653) Assert in a query with both avg aggregate and avg window aggregate functions

[ https://issues.apache.org/jira/browse/DRILL-3653?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3653: Attachment: t1_parquet Assert in a query with both avg aggregate and avg window aggregate

[jira] [Commented] (DRILL-3649) LEAD , LAG , NTILE , FIRST_VALUE , LAST_VALUE report RuntimeException for missing OVER clause

[ https://issues.apache.org/jira/browse/DRILL-3649?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14697706#comment-14697706 ] Victoria Markman commented on DRILL-3649: - Is this bug the same as

[jira] [Updated] (DRILL-3297) Using rank, dense_rank, percent_rank, cume_dist, row_number window functions without OVER clause results in cryptic schema change error

[ https://issues.apache.org/jira/browse/DRILL-3297?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-3297: -- Assignee: Sean Hsuan-Yi Chu (was: Jinfeng Ni) Using rank, dense_rank, percent_rank, cume_dist,

[jira] [Created] (DRILL-3653) Assert in a query with both avg aggregate and avg window aggregate functions

Victoria Markman created DRILL-3653: --- Summary: Assert in a query with both avg aggregate and avg window aggregate functions Key: DRILL-3653 URL: https://issues.apache.org/jira/browse/DRILL-3653

[jira] [Commented] (DRILL-3649) LEAD , LAG , NTILE , FIRST_VALUE , LAST_VALUE report RuntimeException for missing OVER clause

[ https://issues.apache.org/jira/browse/DRILL-3649?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14697717#comment-14697717 ] Victoria Markman commented on DRILL-3649: - The symptom looks different though ...

[jira] [Updated] (DRILL-3653) Assert in a query with both avg aggregate and avg window aggregate functions

[ https://issues.apache.org/jira/browse/DRILL-3653?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3653: Issue Type: Bug (was: Improvement) Assert in a query with both avg aggregate and avg

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

[ https://issues.apache.org/jira/browse/DRILL-3654?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Khurram Faraaz updated DRILL-3654: -- Assignee: Deneche A. Hakim (was: Chris Westin) FIRST_VALUE(char-column/varchar-column)

[jira] [Resolved] (DRILL-3364) Prune scan range if the filter is on the leading field with byte comparable encoding

[ https://issues.apache.org/jira/browse/DRILL-3364?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aditya Kishore resolved DRILL-3364. --- Resolution: Fixed Resolved by

[jira] [Created] (DRILL-3655) TIME - (minus) TIME dpesm

Daniel Barclay (Drill) created DRILL-3655: - Summary: TIME - (minus) TIME dpesm Key: DRILL-3655 URL: https://issues.apache.org/jira/browse/DRILL-3655 Project: Apache Drill Issue Type:

[jira] [Updated] (DRILL-3655) TIME - (minus) TIME doesn't work

[ https://issues.apache.org/jira/browse/DRILL-3655?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Daniel Barclay (Drill) updated DRILL-3655: -- Description: Drill doesn't seem to accept subtracting a time from a time (which

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

[ https://issues.apache.org/jira/browse/DRILL-3654?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14698016#comment-14698016 ] Khurram Faraaz commented on DRILL-3654: --- Stack trace from sqlline.log {code}

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

Khurram Faraaz created DRILL-3654: - Summary: FIRST_VALUE(char-column/varchar-column) returns IOB Exception Key: DRILL-3654 URL: https://issues.apache.org/jira/browse/DRILL-3654 Project: Apache Drill

[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

[jira] [Created] (DRILL-3646) Show tables in DFS workspace

Hari Sekhon created DRILL-3646: -- Summary: Show tables in DFS workspace Key: DRILL-3646 URL: https://issues.apache.org/jira/browse/DRILL-3646 Project: Apache Drill Issue Type: Bug