[jira] [Comment Edited] (DRILL-3783) Incorrect results : COUNT() over results returned by UNION ALL

2015-09-15 Thread Sean Hsuan-Yi Chu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3783?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14746973#comment-14746973 ] Sean Hsuan-Yi Chu edited comment on DRILL-3783 at 9/16/15 6:36 AM: -

[jira] [Comment Edited] (DRILL-3783) Incorrect results : COUNT() over results returned by UNION ALL

2015-09-15 Thread Sean Hsuan-Yi Chu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3783?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14746973#comment-14746973 ] Sean Hsuan-Yi Chu edited comment on DRILL-3783 at 9/16/15 6:30 AM: -

[jira] [Comment Edited] (DRILL-3783) Incorrect results : COUNT() over results returned by UNION ALL

2015-09-15 Thread Sean Hsuan-Yi Chu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3783?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14746973#comment-14746973 ] Sean Hsuan-Yi Chu edited comment on DRILL-3783 at 9/16/15 6:30 AM: -

[jira] [Comment Edited] (DRILL-3783) Incorrect results : COUNT() over results returned by UNION ALL

2015-09-15 Thread Sean Hsuan-Yi Chu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3783?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14746958#comment-14746958 ] Sean Hsuan-Yi Chu edited comment on DRILL-3783 at 9/16/15 6:29 AM: -

[jira] [Commented] (DRILL-3783) Incorrect results : COUNT() over results returned by UNION ALL

2015-09-15 Thread Sean Hsuan-Yi Chu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3783?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14746973#comment-14746973 ] Sean Hsuan-Yi Chu commented on DRILL-3783: -- [~jaltekruse] I think I know what mig

[jira] [Commented] (DRILL-3783) Incorrect results : COUNT() over results returned by UNION ALL

2015-09-15 Thread Sean Hsuan-Yi Chu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3783?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14746958#comment-14746958 ] Sean Hsuan-Yi Chu commented on DRILL-3783: -- [~jaltekruse] So what is the problem

[jira] [Commented] (DRILL-3783) Incorrect results : COUNT() over results returned by UNION ALL

2015-09-15 Thread Jason Altekruse (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3783?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14746858#comment-14746858 ] Jason Altekruse commented on DRILL-3783: I was pretty surprised that it had a prob

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

2015-09-15 Thread Abhishek Girish (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3786?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14746848#comment-14746848 ] Abhishek Girish commented on DRILL-3786: Value is 23 > Query with window function

[jira] [Commented] (DRILL-3783) Incorrect results : COUNT() over results returned by UNION ALL

2015-09-15 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3783?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14746800#comment-14746800 ] Victoria Markman commented on DRILL-3783: - {code} postgres=# select count(a1) fro

[jira] [Resolved] (DRILL-2482) JDBC : calling getObject when the actual column type is 'NVARCHAR' results in NoClassDefFoundError

2015-09-15 Thread Daniel Barclay (Drill) (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2482?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Daniel Barclay (Drill) resolved DRILL-2482. --- Resolution: Fixed > JDBC : calling getObject when the actual column type is 'N

[jira] [Resolved] (DRILL-3658) Missing org.apache.hadoop in the JDBC jar

2015-09-15 Thread Daniel Barclay (Drill) (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3658?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Daniel Barclay (Drill) resolved DRILL-3658. --- Resolution: Fixed > Missing org.apache.hadoop in the JDBC jar > --

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

2015-09-15 Thread Deneche A. Hakim (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3786?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14746757#comment-14746757 ] Deneche A. Hakim commented on DRILL-3786: - [~agirish] what is the value of {{plann

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

2015-09-15 Thread Deneche A. Hakim (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3786?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Deneche A. Hakim updated DRILL-3786: Fix Version/s: 1.2.0 > Query with window function fails with IllegalFormatConversionExceptio

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

2015-09-15 Thread Deneche A. Hakim (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3786?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14746751#comment-14746751 ] Deneche A. Hakim commented on DRILL-3786: - The failure is happening here: {code} i

[jira] [Commented] (DRILL-3783) Incorrect results : COUNT() over results returned by UNION ALL

2015-09-15 Thread Jason Altekruse (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3783?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14746669#comment-14746669 ] Jason Altekruse commented on DRILL-3783: Interestingly when I tried to put extra p

[jira] [Commented] (DRILL-3788) Partition Pruning not taking place with metadata caching when we have ~20k files

2015-09-15 Thread Aman Sinha (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3788?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14746670#comment-14746670 ] Aman Sinha commented on DRILL-3788: --- That is true..in this case the data was probably cr

[jira] [Commented] (DRILL-3783) Incorrect results : COUNT() over results returned by UNION ALL

2015-09-15 Thread Jason Altekruse (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3783?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14746667#comment-14746667 ] Jason Altekruse commented on DRILL-3783: Shouldn't the parenthesis that surround t

[jira] [Reopened] (DRILL-3783) Incorrect results : COUNT() over results returned by UNION ALL

2015-09-15 Thread Jason Altekruse (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3783?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jason Altekruse reopened DRILL-3783: > Incorrect results : COUNT() over results returned by UNION ALL >

[jira] [Closed] (DRILL-3783) Incorrect results : COUNT() over results returned by UNION ALL

2015-09-15 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3783?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Khurram Faraaz closed DRILL-3783. - > Incorrect results : COUNT() over results returned by UNION ALL > --

[jira] [Resolved] (DRILL-3783) Incorrect results : COUNT() over results returned by UNION ALL

2015-09-15 Thread Sean Hsuan-Yi Chu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3783?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sean Hsuan-Yi Chu resolved DRILL-3783. -- Resolution: Invalid This is fine. Set-Operator (e.g., Union, Intersect) has the least pr

[jira] [Commented] (DRILL-3788) Partition Pruning not taking place with metadata caching when we have ~20k files

2015-09-15 Thread Steven Phillips (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3788?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14746645#comment-14746645 ] Steven Phillips commented on DRILL-3788: I am a bit confused. This jira seems to b

[jira] [Commented] (DRILL-3788) Partition Pruning not taking place with metadata caching when we have ~20k files

2015-09-15 Thread Aman Sinha (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3788?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14746640#comment-14746640 ] Aman Sinha commented on DRILL-3788: --- [~rkins] can you try to create a smaller repro ? G

[jira] [Commented] (DRILL-2748) Filter is not pushed down into subquery with the group by

2015-09-15 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2748?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14746631#comment-14746631 ] Jinfeng Ni commented on DRILL-2748: --- Turns out adding FilterAggregateTransposableRule is

[jira] [Updated] (DRILL-3788) Partition Pruning not taking place with metadata caching when we have ~20k files

2015-09-15 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3788?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-3788: -- Assignee: Aman Sinha (was: Jinfeng Ni) > Partition Pruning not taking place with metadata caching when

[jira] [Updated] (DRILL-3788) Partition Pruning not taking place with metadata caching when we have ~20k files

2015-09-15 Thread Rahul Challapalli (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3788?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rahul Challapalli updated DRILL-3788: - Attachment: plan.txt Log file contents {code} 2015-09-16 00:59:51,812 [2a0740fa-e089-4afc

[jira] [Created] (DRILL-3788) Partition Pruning not taking place with metadata caching when we have ~20k files

2015-09-15 Thread Rahul Challapalli (JIRA)
Rahul Challapalli created DRILL-3788: Summary: Partition Pruning not taking place with metadata caching when we have ~20k files Key: DRILL-3788 URL: https://issues.apache.org/jira/browse/DRILL-3788

[jira] [Issue Comment Deleted] (DRILL-2748) Filter is not pushed down into subquery with the group by

2015-09-15 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2748?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-2748: Comment: was deleted (was: [~jni] I tried with tpcds sf100, filter is not pushed down as we

[jira] [Reopened] (DRILL-2748) Filter is not pushed down into subquery with the group by

2015-09-15 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2748?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman reopened DRILL-2748: - > Filter is not pushed down into subquery with the group by >

[jira] [Commented] (DRILL-2748) Filter is not pushed down into subquery with the group by

2015-09-15 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2748?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14746599#comment-14746599 ] Victoria Markman commented on DRILL-2748: - [~jni] I tried with tpcds sf100, filte

[jira] [Commented] (DRILL-2748) Filter is not pushed down into subquery with the group by

2015-09-15 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2748?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14746596#comment-14746596 ] Victoria Markman commented on DRILL-2748: - [~jni] Costing theory may not be corre

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

2015-09-15 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3679?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14746598#comment-14746598 ] Khurram Faraaz commented on DRILL-3679: --- Ok I will verify and confirm. > IOB Except

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

2015-09-15 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3679?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14746594#comment-14746594 ] Jinfeng Ni commented on DRILL-3679: --- Can you run against the latest master branch? The f

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

2015-09-15 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3679?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14746584#comment-14746584 ] Khurram Faraaz commented on DRILL-3679: --- I see this JIRA is marked as resolved, but

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

2015-09-15 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3679?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14746586#comment-14746586 ] Khurram Faraaz commented on DRILL-3679: --- Should I re-open this JIRA or report a new

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

2015-09-15 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3680?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Khurram Faraaz closed DRILL-3680. - Verified fix on master commit id: b525692e added test {code} 0: jdbc:drill:schema=dfs.tmp> select c1

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

2015-09-15 Thread Chun Chang (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3537?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chun Chang closed DRILL-3537. - Assignee: Chun Chang (was: Parth Chandra) verified fix. {noformat} 0: jdbc:drill:schema=dfs.drillTestDir

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

2015-09-15 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3679?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni resolved DRILL-3679. --- Resolution: Fixed The symptom is different, but the root cause is same as DRILL-3680. Marked as dupli

[jira] [Created] (DRILL-3787) Need a better error message

2015-09-15 Thread Khurram Faraaz (JIRA)
Khurram Faraaz created DRILL-3787: - Summary: Need a better error message Key: DRILL-3787 URL: https://issues.apache.org/jira/browse/DRILL-3787 Project: Apache Drill Issue Type: Bug

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

2015-09-15 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3786?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14746556#comment-14746556 ] Jinfeng Ni commented on DRILL-3786: --- The stack trace shows the error is raised in Sort o

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

2015-09-15 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3786?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-3786: -- Assignee: Deneche A. Hakim (was: Jinfeng Ni) > Query with window function fails with IllegalFormatConve

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

2015-09-15 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3786?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-3786: -- Component/s: (was: Query Planning & Optimization) Execution - Relational Operators

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

2015-09-15 Thread Abhishek Girish (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3786?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Abhishek Girish updated DRILL-3786: --- Attachment: query_profile.json drillbit.log.txt > Query with window function f

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

2015-09-15 Thread Abhishek Girish (JIRA)
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: Apa

[jira] [Closed] (DRILL-3737) CTAS from empty text file fails with NPE

2015-09-15 Thread Chun Chang (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3737?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chun Chang closed DRILL-3737. - Assignee: Chun Chang (was: Sean Hsuan-Yi Chu) dup of Drill-3539 > CTAS from empty text file fails with N

[jira] [Resolved] (DRILL-3765) Partition prune rule is unnecessary fired multiple times.

2015-09-15 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3765?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni resolved DRILL-3765. --- Resolution: Won't Fix I looked at the Calcite trace file. Seems the multiple rule firing is what Calc

[jira] [Updated] (DRILL-3121) Hive partition pruning is not happening

2015-09-15 Thread Chun Chang (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3121?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chun Chang updated DRILL-3121: -- Assignee: Rahul Challapalli (was: Mehant Baid) > Hive partition pruning is not happening >

[jira] [Closed] (DRILL-2625) org.apache.drill.common.StackTrace should follow standard stacktrace format

2015-09-15 Thread Chun Chang (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2625?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chun Chang closed DRILL-2625. - Assignee: Chun Chang (was: Chris Westin) verified fix. {noformat} [Error Id: ed3fbb63-6468-4f59-b312-722

[jira] [Updated] (DRILL-2625) org.apache.drill.common.StackTrace should follow standard stacktrace format

2015-09-15 Thread Daniel Barclay (Drill) (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2625?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Daniel Barclay (Drill) updated DRILL-2625: -- Description: org.apache.drill.common.StackTrace uses a different textual format

[jira] [Commented] (DRILL-1065) Provide a reset command to reset an option to its default value

2015-09-15 Thread ASF GitHub Bot (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1065?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14746489#comment-14746489 ] ASF GitHub Bot commented on DRILL-1065: --- GitHub user sudheeshkatkam opened a pull re

[jira] [Commented] (DRILL-3030) Foreman hangs trying to cancel non-root fragments

2015-09-15 Thread Sudheesh Katkam (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3030?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14746488#comment-14746488 ] Sudheesh Katkam commented on DRILL-3030: I don't think this is a duplicate of [DR

[jira] [Closed] (DRILL-3030) Foreman hangs trying to cancel non-root fragments

2015-09-15 Thread Chun Chang (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3030?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chun Chang closed DRILL-3030. - Assignee: Chun Chang (was: Sudheesh Katkam) dup of Drill-3448. > Foreman hangs trying to cancel non-root

[jira] [Updated] (DRILL-3238) Cannot Plan Exception is raised when the same window partition is defined in select & window clauses

2015-09-15 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3238?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3238: Fix Version/s: (was: Future) 1.2.0 > Cannot Plan Exception is raised

[jira] [Closed] (DRILL-2650) Cancelled queries json profile shows query end time occurs before fragments end time

2015-09-15 Thread Krystal (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2650?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krystal closed DRILL-2650. -- git.commit.id.abbrev=0c1b293 Verified the durations of the individual fragments are within the duration of the can

[jira] [Resolved] (DRILL-3393) Quotes not being recognized in tab delimited (tsv) files

2015-09-15 Thread Sean Hsuan-Yi Chu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3393?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sean Hsuan-Yi Chu resolved DRILL-3393. -- Resolution: Fixed Resolved in commit#: 48bc0b9a8916af7191b0a99351c27fd5b69786c3 > Quote

[jira] [Updated] (DRILL-3448) typo in QueryManager.DrillbitStatusListener will cause the Foreman to hang if a Drillbit dies

2015-09-15 Thread Chun Chang (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3448?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chun Chang updated DRILL-3448: -- Assignee: Khurram Faraaz (was: Sudheesh Katkam) > typo in QueryManager.DrillbitStatusListener will caus

[jira] [Commented] (DRILL-3718) quotes in .tsv trigger exception

2015-09-15 Thread Sean Hsuan-Yi Chu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3718?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14746395#comment-14746395 ] Sean Hsuan-Yi Chu commented on DRILL-3718: -- Resolved in commit#: 48bc0b9a8916af71

[jira] [Updated] (DRILL-3785) AssertionError in FindPartitionConditions.java

2015-09-15 Thread Rahul Challapalli (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3785?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rahul Challapalli updated DRILL-3785: - Attachment: error (4).log > AssertionError in FindPartitionConditions.java > -

[jira] [Created] (DRILL-3785) AssertionError in FindPartitionConditions.java

2015-09-15 Thread Rahul Challapalli (JIRA)
Rahul Challapalli created DRILL-3785: Summary: AssertionError in FindPartitionConditions.java Key: DRILL-3785 URL: https://issues.apache.org/jira/browse/DRILL-3785 Project: Apache Drill I

[jira] [Resolved] (DRILL-3238) Cannot Plan Exception is raised when the same window partition is defined in select & window clauses

2015-09-15 Thread Sean Hsuan-Yi Chu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3238?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sean Hsuan-Yi Chu resolved DRILL-3238. -- Resolution: Fixed > Cannot Plan Exception is raised when the same window partition is de

[jira] [Closed] (DRILL-3497) Throw UserException#validationError for errors when modifying options

2015-09-15 Thread Chun Chang (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3497?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chun Chang closed DRILL-3497. - Assignee: Chun Chang (was: Sudheesh Katkam) verified fix. {code} 0: jdbc:drill:schema=dfs.drillTestDirDr

[jira] [Updated] (DRILL-3455) If a drillbit, that contains fragments for the current query, dies the QueryManager will fail the query even if those fragments already finished successfully

2015-09-15 Thread Chun Chang (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3455?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chun Chang updated DRILL-3455: -- Assignee: Khurram Faraaz (was: Sudheesh Katkam) > If a drillbit, that contains fragments for the curren

[jira] [Commented] (DRILL-3497) Throw UserException#validationError for errors when modifying options

2015-09-15 Thread Sudheesh Katkam (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3497?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14746090#comment-14746090 ] Sudheesh Katkam commented on DRILL-3497: Invalid parameters to "ALTER ... SET ..."

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

2015-09-15 Thread Magnus Pierre (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3180?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14746059#comment-14746059 ] Magnus Pierre commented on DRILL-3180: -- If remembering correctly the JDBC drivers are

[jira] [Reopened] (DRILL-2332) Drill should be consistent with Implicit casting rules across data formats

2015-09-15 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2332?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman reopened DRILL-2332: - Sean, Fix for DRILL-2313 I believe, makes this case work now: t1 is parquet file: message ro

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

2015-09-15 Thread Magnus Pierre (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3180?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14746044#comment-14746044 ] Magnus Pierre commented on DRILL-3180: -- Hello Jacques, Sounds good. :) Re the questio

[jira] [Commented] (DRILL-2313) Query fails when one of the operands is a DATE literal without an explicit cast

2015-09-15 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2313?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14746026#comment-14746026 ] Victoria Markman commented on DRILL-2313: - I answered question #2 myself: {code}

[jira] [Commented] (DRILL-2313) Query fails when one of the operands is a DATE literal without an explicit cast

2015-09-15 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2313?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14746017#comment-14746017 ] Victoria Markman commented on DRILL-2313: - [~seanhychu], (1) Is this expected beh

[jira] [Commented] (DRILL-3539) CTAS over empty json file throws NPE

2015-09-15 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3539?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14746013#comment-14746013 ] Khurram Faraaz commented on DRILL-3539: --- Adding this here. {code} 0: jdbc:drill:sch

[jira] [Updated] (DRILL-3539) CTAS over empty json file throws NPE

2015-09-15 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3539?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Khurram Faraaz updated DRILL-3539: -- Assignee: Sean Hsuan-Yi Chu (was: Steven Phillips) > CTAS over empty json file throws NPE > ---

[jira] [Created] (DRILL-3784) simple Jdbc program fails with NoClassDefFoundError

2015-09-15 Thread Deneche A. Hakim (JIRA)
Deneche A. Hakim created DRILL-3784: --- Summary: simple Jdbc program fails with NoClassDefFoundError Key: DRILL-3784 URL: https://issues.apache.org/jira/browse/DRILL-3784 Project: Apache Drill

[jira] [Closed] (DRILL-2727) CTAS select * from CSV file results in Exception

2015-09-15 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2727?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Khurram Faraaz closed DRILL-2727. - Verified on master b525692e > CTAS select * from CSV file results in Exception >

[jira] [Closed] (DRILL-2843) Reading empty CSV file fails with error (rather than yielding zero rows)

2015-09-15 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2843?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Khurram Faraaz closed DRILL-2843. - > Reading empty CSV file fails with error (rather than yielding zero rows) > -

[jira] [Closed] (DRILL-3295) UNION (distinct type) is supported now

2015-09-15 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3295?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Khurram Faraaz closed DRILL-3295. - Verified. > UNION (distinct type) is supported now > -- > >

[jira] [Closed] (DRILL-3095) Memory Leak : Failure while closing accountor.

2015-09-15 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3095?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Khurram Faraaz closed DRILL-3095. - > Memory Leak : Failure while closing accountor. > -- > >

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

2015-09-15 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3536?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Khurram Faraaz closed DRILL-3536. - Verified on master b525692e > Add support for LEAD, LAG, NTILE, FIRST_VALUE and LAST_VALUE window fun

[jira] [Commented] (DRILL-3783) Incorrect results : COUNT() over results returned by UNION ALL

2015-09-15 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3783?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14745981#comment-14745981 ] Khurram Faraaz commented on DRILL-3783: --- Query plan for the query {code} 0: jdbc:dr

[jira] [Commented] (DRILL-2949) TPC-DS queries 1 and 30 fail with CannotPlanException

2015-09-15 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2949?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14745977#comment-14745977 ] Victoria Markman commented on DRILL-2949: - [~agirish], I think you've already re-

[jira] [Updated] (DRILL-2949) TPC-DS queries 1 and 30 fail with CannotPlanException

2015-09-15 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2949?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-2949: Assignee: Abhishek Girish (was: Aman Sinha) > TPC-DS queries 1 and 30 fail with CannotPlanE

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

2015-09-15 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3580?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14745973#comment-14745973 ] Victoria Markman commented on DRILL-3580: - Verified fixed in 1.2.0 #Fri Sep 11 05

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

2015-09-15 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3580?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman closed DRILL-3580. --- > wrong plan for window function queries containing function(col1 + colb) > --

[jira] [Closed] (DRILL-3542) Rebase Drill on Calcite 1.4.0 release

2015-09-15 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3542?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Khurram Faraaz closed DRILL-3542. - > Rebase Drill on Calcite 1.4.0 release > - > > Ke

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

2015-09-15 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3553?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Khurram Faraaz closed DRILL-3553. - Verified on master b525692e > add support for LEAD and LAG window functions > ---

[jira] [Commented] (DRILL-3542) Rebase Drill on Calcite 1.4.0 release

2015-09-15 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3542?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14745970#comment-14745970 ] Khurram Faraaz commented on DRILL-3542: --- Verified on master b525692e > Rebase Drill

[jira] [Commented] (DRILL-3557) Reading empty CSV file fails with SYSTEM ERROR

2015-09-15 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3557?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14745967#comment-14745967 ] Khurram Faraaz commented on DRILL-3557: --- Verified on master commit id b525692e {cod

[jira] [Closed] (DRILL-3557) Reading empty CSV file fails with SYSTEM ERROR

2015-09-15 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3557?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Khurram Faraaz closed DRILL-3557. - > Reading empty CSV file fails with SYSTEM ERROR > -- > >

[jira] [Closed] (DRILL-3583) SUM on varchar column produces incorrect error

2015-09-15 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3583?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Khurram Faraaz closed DRILL-3583. - > SUM on varchar column produces incorrect error > -- > >

[jira] [Commented] (DRILL-3583) SUM on varchar column produces incorrect error

2015-09-15 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3583?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14745960#comment-14745960 ] Khurram Faraaz commented on DRILL-3583: --- Verified on master commit ID: b525692e We n

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

2015-09-15 Thread Chun Chang (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3616?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chun Chang updated DRILL-3616: -- Assignee: Victoria Markman (was: Deneche A. Hakim) > Memory leak in a cleanup code after canceling quer

[jira] [Updated] (DRILL-3622) With user authentication enabled, only admin users should be able to change system options

2015-09-15 Thread Chun Chang (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3622?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chun Chang updated DRILL-3622: -- Assignee: Krystal (was: Venki Korukanti) > With user authentication enabled, only admin users should be

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

2015-09-15 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3619?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Khurram Faraaz closed DRILL-3619. - Verified. > Add support for NTILE window function > - > >

[jira] [Closed] (DRILL-3608) add support for FIRST_VALUE and LAST_VALUE

2015-09-15 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3608?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Khurram Faraaz closed DRILL-3608. - Verified on master. > add support for FIRST_VALUE and LAST_VALUE > --

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

2015-09-15 Thread Ajo Abraham (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3180?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14745931#comment-14745931 ] Ajo Abraham commented on DRILL-3180: Hi [~jnadeau] - is it possible to push down a que

[jira] [Closed] (DRILL-3635) IllegalArgumentException - not a Parquet file (too small)

2015-09-15 Thread Chun Chang (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3635?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chun Chang closed DRILL-3635. - Assignee: Chun Chang (was: Deneche A. Hakim) Ran the same test in a loop for 10 times, did not hit the fa

[jira] [Reopened] (DRILL-3658) Missing org.apache.hadoop in the JDBC jar

2015-09-15 Thread Daniel Barclay (Drill) (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3658?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Daniel Barclay (Drill) reopened DRILL-3658: --- > Missing org.apache.hadoop in the JDBC jar >

[jira] [Assigned] (DRILL-2489) Accessing Connection, Statement, PreparedStatement after they are closed should throw a SQLException

2015-09-15 Thread Daniel Barclay (Drill) (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2489?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Daniel Barclay (Drill) reassigned DRILL-2489: - Assignee: Daniel Barclay (Drill) (was: Mehant Baid) > Accessing Connecti

[jira] [Updated] (DRILL-3780) storage plugin configurations in ZooKeeper need to be secured

2015-09-15 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3780?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Khurram Faraaz updated DRILL-3780: -- Assignee: Venki Korukanti > storage plugin configurations in ZooKeeper need to be secured >

[jira] [Closed] (DRILL-2637) Schema change reported incorrectly although both the input columns are of same datatype

2015-09-15 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2637?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Khurram Faraaz closed DRILL-2637. - > Schema change reported incorrectly although both the input columns are of > same datatype > ---

[jira] [Commented] (DRILL-2637) Schema change reported incorrectly although both the input columns are of same datatype

2015-09-15 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2637?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14745886#comment-14745886 ] Khurram Faraaz commented on DRILL-2637: --- Verified that we do not see the RelOptPlann

[jira] [Comment Edited] (DRILL-3189) Disable ALLOW PARTIAL/DISALLOW PARTIAL in window function grammar

2015-09-15 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3189?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14745884#comment-14745884 ] Victoria Markman edited comment on DRILL-3189 at 9/15/15 6:25 PM: --

[jira] [Closed] (DRILL-3189) Disable ALLOW PARTIAL/DISALLOW PARTIAL in window function grammar

2015-09-15 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3189?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman closed DRILL-3189. --- > Disable ALLOW PARTIAL/DISALLOW PARTIAL in window function grammar >

  1   2   >