[jira] [Commented] (DRILL-3555) Changing defaults for planner.memory.max_query_memory_per_node causes queries with window function to fail

2015-07-24 Thread Deneche A. Hakim (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3555?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14641301#comment-14641301 ] Deneche A. Hakim commented on DRILL-3555: - what dataset are you running the query

[jira] [Created] (DRILL-3555) Changing defaults for planner.memory.max_query_memory_per_node causes queries with window function to fail

2015-07-24 Thread Abhishek Girish (JIRA)
Abhishek Girish created DRILL-3555: -- Summary: Changing defaults for planner.memory.max_query_memory_per_node causes queries with window function to fail Key: DRILL-3555 URL: https://issues.apache.org/jira/browse

[jira] [Commented] (DRILL-2218) Constant folding rule exposing planning bugs and not being used in plan where the constant expression is in the select list

2015-07-24 Thread Jason Altekruse (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2218?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14641285#comment-14641285 ] Jason Altekruse commented on DRILL-2218: An update on this issue after discussing

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

2015-07-24 Thread Smidth Panchamia (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3364?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Smidth Panchamia updated DRILL-3364: Attachment: 0001-Add-convert_from-and-convert_to-methods-for-TIMESTAM.patch Add convert_from

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

2015-07-24 Thread Smidth Panchamia (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3364?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Smidth Panchamia updated DRILL-3364: Attachment: 0001-DRILL-3364-Prune-scan-range-if-the-filter-is-on-the-.patch The change adds

[jira] [Updated] (DRILL-3553) add support for LEAD and LAG window functions

2015-07-24 Thread Deneche A. Hakim (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3553?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Deneche A. Hakim updated DRILL-3553: Description: >From SQL standard here is the general format of LEAD and LAG: {noformat} ::=

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

2015-07-24 Thread Smidth Panchamia (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3364?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Smidth Panchamia updated DRILL-3364: Attachment: 0001-DRILL-3364-Prune-scan-range-if-the-filter-is-on-the-.patch The change adds

[jira] [Commented] (DRILL-3553) add support for LEAD and LAG window functions

2015-07-24 Thread Deneche A. Hakim (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3553?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14641182#comment-14641182 ] Deneche A. Hakim commented on DRILL-3553: - Calcite only supports {{RESPECT NULLS}}

[jira] [Updated] (DRILL-3554) Union over TIME and TIMESTAMP values throws SchemaChangeException

2015-07-24 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3554?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Khurram Faraaz updated DRILL-3554: -- Assignee: Sean Hsuan-Yi Chu (was: Chris Westin) > Union over TIME and TIMESTAMP values throws S

[jira] [Created] (DRILL-3554) Union over TIME and TIMESTAMP values throws SchemaChangeException

2015-07-24 Thread Khurram Faraaz (JIRA)
Khurram Faraaz created DRILL-3554: - Summary: Union over TIME and TIMESTAMP values throws SchemaChangeException Key: DRILL-3554 URL: https://issues.apache.org/jira/browse/DRILL-3554 Project: Apache Dri

[jira] [Updated] (DRILL-3553) add support for LEAD and LAG window functions

2015-07-24 Thread Deneche A. Hakim (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3553?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Deneche A. Hakim updated DRILL-3553: Description: >From SQL standard here is the general format of LEAD and LAG: {noformat} ::=

[jira] [Updated] (DRILL-3553) add support for LEAD and LAG window functions

2015-07-24 Thread Deneche A. Hakim (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3553?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Deneche A. Hakim updated DRILL-3553: Description: >From SQL standard here is the general format of LEAD and LAG: {noformat} ::=

[jira] [Updated] (DRILL-3553) add support for LEAD and LAG window functions

2015-07-24 Thread Deneche A. Hakim (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3553?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Deneche A. Hakim updated DRILL-3553: Labels: window_function (was: ) > add support for LEAD and LAG window functions > -

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

2015-07-24 Thread Deneche A. Hakim (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3536?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Deneche A. Hakim updated DRILL-3536: Labels: window_function (was: ) > Add support for LEAD, LAG, NTILE, FIRST_VALUE and LAST_VA

[jira] [Created] (DRILL-3553) add support for LEAD and LAG window functions

2015-07-24 Thread Deneche A. Hakim (JIRA)
Deneche A. Hakim created DRILL-3553: --- Summary: add support for LEAD and LAG window functions Key: DRILL-3553 URL: https://issues.apache.org/jira/browse/DRILL-3553 Project: Apache Drill Issu

[jira] [Created] (DRILL-3552) Additional debug information to exception shown to user in verbose mode

2015-07-24 Thread Sudheesh Katkam (JIRA)
Sudheesh Katkam created DRILL-3552: -- Summary: Additional debug information to exception shown to user in verbose mode Key: DRILL-3552 URL: https://issues.apache.org/jira/browse/DRILL-3552 Project: Ap

[jira] [Commented] (DRILL-3533) null values in a sub-structure in Parquet returns unexpected/misleading results

2015-07-24 Thread JIRA
[ https://issues.apache.org/jira/browse/DRILL-3533?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14640869#comment-14640869 ] Stefán Baxter commented on DRILL-3533: -- Thank you, I will try this later today. On F

[jira] [Commented] (DRILL-3533) null values in a sub-structure in Parquet returns unexpected/misleading results

2015-07-24 Thread ASF GitHub Bot (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3533?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14640835#comment-14640835 ] ASF GitHub Bot commented on DRILL-3533: --- Github user asfgit closed the pull request

[jira] [Comment Edited] (DRILL-2288) result set metadata not set for zero-row result (DatabaseMetaData.getColumns(...))

2015-07-24 Thread Daniel Barclay (Drill) (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2288?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14632614#comment-14632614 ] Daniel Barclay (Drill) edited comment on DRILL-2288 at 7/24/15 5:54 PM:

[jira] [Updated] (DRILL-3546) S3 - jets3t - No such File Or Directory

2015-07-24 Thread Daniel Barclay (Drill) (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3546?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Daniel Barclay (Drill) updated DRILL-3546: -- Assignee: (was: Daniel Barclay (Drill)) > S3 - jets3t - No such File Or Dire

[jira] [Updated] (DRILL-3547) IndexOutOfBoundsException on directory with ~20 subdirectories

2015-07-24 Thread Daniel Barclay (Drill) (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3547?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Daniel Barclay (Drill) updated DRILL-3547: -- Assignee: (was: Daniel Barclay (Drill)) > IndexOutOfBoundsException on direc

[jira] [Commented] (DRILL-3537) Empty Json file can potentially result into wrong results

2015-07-24 Thread Sean Hsuan-Yi Chu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3537?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14640626#comment-14640626 ] Sean Hsuan-Yi Chu commented on DRILL-3537: -- https://reviews.apache.org/r/36782/

[jira] [Commented] (DRILL-3476) Filter on nested element gives wrong results

2015-07-24 Thread ASF GitHub Bot (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3476?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14640611#comment-14640611 ] ASF GitHub Bot commented on DRILL-3476: --- Github user hnfgns commented on the pull re

[jira] [Commented] (DRILL-3353) Non data-type related schema changes errors

2015-07-24 Thread ASF GitHub Bot (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3353?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14640613#comment-14640613 ] ASF GitHub Bot commented on DRILL-3353: --- Github user hnfgns commented on the pull re

[jira] [Updated] (DRILL-3353) Non data-type related schema changes errors

2015-07-24 Thread Hanifi Gunes (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3353?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Hanifi Gunes updated DRILL-3353: Assignee: Steven Phillips (was: Hanifi Gunes) > Non data-type related schema changes errors > -

[jira] [Updated] (DRILL-3476) Filter on nested element gives wrong results

2015-07-24 Thread Hanifi Gunes (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3476?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Hanifi Gunes updated DRILL-3476: Assignee: Steven Phillips (was: Hanifi Gunes) > Filter on nested element gives wrong results >

[jira] [Updated] (DRILL-3313) Eliminate redundant #load methods and unit-test loading & exporting of vectors

2015-07-24 Thread Hanifi Gunes (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3313?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Hanifi Gunes updated DRILL-3313: Assignee: Jason Altekruse (was: Steven Phillips) > Eliminate redundant #load methods and unit-test

[jira] [Updated] (DRILL-2838) Applying flatten after joining 2 sub-queries returns empty maps

2015-07-24 Thread Hanifi Gunes (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2838?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Hanifi Gunes updated DRILL-2838: Assignee: Jason Altekruse (was: Hanifi Gunes) > Applying flatten after joining 2 sub-queries return

[jira] [Updated] (DRILL-1750) Querying directories with JSON files returns incomplete results

2015-07-24 Thread Hanifi Gunes (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1750?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Hanifi Gunes updated DRILL-1750: Assignee: Steven Phillips (was: Hanifi Gunes) > Querying directories with JSON files returns incomp

[jira] [Updated] (DRILL-3546) S3 - jets3t - No such File Or Directory

2015-07-24 Thread Philip Deegan (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3546?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Philip Deegan updated DRILL-3546: - Description: Tested on 1.1 with commit id: {noformat} 0: jdbc:drill:zk=local> select commit_id fro

[jira] [Commented] (DRILL-3547) IndexOutOfBoundsException on directory with ~20 subdirectories

2015-07-24 Thread Philip Deegan (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3547?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14640166#comment-14640166 ] Philip Deegan commented on DRILL-3547: -- The issue is due to an empty file amongst non

[jira] [Updated] (DRILL-3546) S3 - jets3t - No such File Or Directory

2015-07-24 Thread Philip Deegan (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3546?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Philip Deegan updated DRILL-3546: - Description: Tested on 1.1 with commit id: {noformat} 0: jdbc:drill:zk=local> select commit_id fro