[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

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

[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

[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=14746596#comment-14746596 ] Victoria Markman commented on DRILL-2748: - [~jni] Costing theory may not be correct: tried with

[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=14746599#comment-14746599 ] Victoria Markman commented on DRILL-2748: - [~jni] I tried with tpcds sf100, filter is not pushed

[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

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

[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=14746848#comment-14746848 ] Abhishek Girish commented on DRILL-3786: Value is 23 > Query with window function fails with

[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

[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=14746489#comment-14746489 ] ASF GitHub Bot commented on DRILL-1065: --- GitHub user sudheeshkatkam opened a pull request:

[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=14746488#comment-14746488 ] Sudheesh Katkam commented on DRILL-3030: I don't think this is a duplicate of

[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-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=14746858#comment-14746858 ] Jason Altekruse commented on DRILL-3783: I was pretty surprised that it had a problem with it, I

[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=14746800#comment-14746800 ] Victoria Markman commented on DRILL-3783: - {code} postgres=# select count(a1) from ((select a1

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

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

[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

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

[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=14746584#comment-14746584 ] Khurram Faraaz commented on DRILL-3679: --- I see this JIRA is marked as resolved, but the issue still

[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

[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=14746757#comment-14746757 ] Deneche A. Hakim commented on DRILL-3786: - [~agirish] what is the value of

[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=14746594#comment-14746594 ] Jinfeng Ni commented on DRILL-3679: --- Can you run against the latest master branch? The fix for

[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=14746598#comment-14746598 ] Khurram Faraaz commented on DRILL-3679: --- Ok I will verify and confirm. > IOB Exception : when

[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

[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

[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] [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] [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=14746645#comment-14746645 ] Steven Phillips commented on DRILL-3788: I am a bit confused. This jira seems to be related to

[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=14746669#comment-14746669 ] Jason Altekruse commented on DRILL-3783: Interestingly when I tried to put extra parenthesis

[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=14746670#comment-14746670 ] Aman Sinha commented on DRILL-3788: --- That is true..in this case the data was probably created with the

[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=14746395#comment-14746395 ] Sean Hsuan-Yi Chu commented on DRILL-3718: -- Resolved in commit#:

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

[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-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=14746631#comment-14746631 ] Jinfeng Ni commented on DRILL-2748: --- Turns out adding FilterAggregateTransposableRule is not enough to

[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=14746667#comment-14746667 ] Jason Altekruse commented on DRILL-3783: Shouldn't the parenthesis that surround the sub-query

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

[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

[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=14746556#comment-14746556 ] Jinfeng Ni commented on DRILL-3786: --- The stack trace shows the error is raised in Sort operator. Assign

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

[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

[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] [Commented] (DRILL-3735) Directory pruning is not happening when number of files is larger than 64k

2015-09-15 Thread ASF GitHub Bot (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3735?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14744932#comment-14744932 ] ASF GitHub Bot commented on DRILL-3735: --- Github user jinfengni commented on a diff in the pull

[jira] [Updated] (DRILL-3761) CastIntDecimal implementation should not update the input holder.

2015-09-15 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3761?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-3761: -- Assignee: Mehant Baid (was: Jinfeng Ni) > CastIntDecimal implementation should not update the input

[jira] [Commented] (DRILL-3761) CastIntDecimal implementation should not update the input holder.

2015-09-15 Thread Mehant Baid (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3761?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14745877#comment-14745877 ] Mehant Baid commented on DRILL-3761: +1. We should also add logic to enforce the constraint that the

[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=14745931#comment-14745931 ] Ajo Abraham commented on DRILL-3180: Hi [~jnadeau] - is it possible to push down a query directly by

[jira] [Closed] (DRILL-1136) Create view replaces the same existing view

2015-09-15 Thread Krystal (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1136?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krystal closed DRILL-1136. -- Bug verified as fixed. > Create view replaces the same existing view > ---

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

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

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

2015-09-15 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3700?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman closed DRILL-3700. --- > Exception in a query with multiple fist_value window functions with different > partitions >

[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=14745884#comment-14745884 ] Victoria Markman edited comment on DRILL-3189 at 9/15/15 6:25 PM: -- Since

[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=14745886#comment-14745886 ] Khurram Faraaz commented on DRILL-2637: --- Verified that we do not see the

[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

[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] [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-12) Check "Drill" name

2015-09-15 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-12?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Khurram Faraaz closed DRILL-12. --- > Check "Drill" name > -- > > Key: DRILL-12 > URL:

[jira] [Commented] (DRILL-2217) Trying to flatten an empty list should return an empty result

2015-09-15 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2217?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14745802#comment-14745802 ] Victoria Markman commented on DRILL-2217: - With drill 1.2.0 I see result below and I'm not sure if

[jira] [Closed] (DRILL-2316) Docs Enhancement: Data Sources and File Formats, Basics Tutorial

2015-09-15 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2316?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Khurram Faraaz closed DRILL-2316. - > Docs Enhancement: Data Sources and File Formats, Basics Tutorial >

[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=14745960#comment-14745960 ] Khurram Faraaz commented on DRILL-3583: --- Verified on master commit ID: b525692e We now get a better

[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] [Updated] (DRILL-3761) CastIntDecimal implementation should not update the input holder.

2015-09-15 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3761?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-3761: -- Attachment: 0001-DRILL-3761-Modify-CastIntDecimal-implementation-so-t.patch > CastIntDecimal

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

2015-09-15 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: Assignee: Deneche A. Hakim (was: Victoria Markman) > Exception in a query with multiple

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

2015-09-15 Thread Khurram Faraaz (JIRA)
Khurram Faraaz created DRILL-3783: - Summary: Incorrect results : COUNT() over results returned by UNION ALL Key: DRILL-3783 URL: https://issues.apache.org/jira/browse/DRILL-3783 Project: Apache

[jira] [Commented] (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=14745884#comment-14745884 ] Victoria Markman commented on DRILL-3189: - Since we decided not to support "ROWS" syntax for now,

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

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

[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

[jira] [Commented] (DRILL-102) Riak storage engine

2015-09-15 Thread Agata M (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-102?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14745136#comment-14745136 ] Agata M commented on DRILL-102: --- Hi, I'm looking for a Riak plugin implementation. Are there plans to release

[jira] [Commented] (DRILL-2724) Implicit cast test fails in Union All query (reports type mismatch)

2015-09-15 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2724?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14745588#comment-14745588 ] Victoria Markman commented on DRILL-2724: - Closing, as this is not a bug, but expected behavior.

[jira] [Commented] (DRILL-3767) SchemaPath.getCompoundPath(String...strings) reverses it's input array

2015-09-15 Thread ASF GitHub Bot (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3767?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14745618#comment-14745618 ] ASF GitHub Bot commented on DRILL-3767: --- Github user adeneche commented on a diff in the pull

[jira] [Closed] (DRILL-2724) Implicit cast test fails in Union All query (reports type mismatch)

2015-09-15 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2724?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman closed DRILL-2724. --- > Implicit cast test fails in Union All query (reports type mismatch) >

[jira] [Updated] (DRILL-3732) Drill leaks memory if external sort hits out of disk space exception

2015-09-15 Thread Deneche A. Hakim (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3732?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Deneche A. Hakim updated DRILL-3732: Assignee: Aman Sinha (was: Deneche A. Hakim) > Drill leaks memory if external sort hits

[jira] [Commented] (DRILL-2688) Use of ORDER BY on right side of Union All results in SqlValidatorException

2015-09-15 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2688?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14745608#comment-14745608 ] Victoria Markman commented on DRILL-2688: - ISO/IEC 9075-2:2011(E) (6.41 ) states: "b) QE shall

[jira] [Closed] (DRILL-2688) Use of ORDER BY on right side of Union All results in SqlValidatorException

2015-09-15 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2688?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman closed DRILL-2688. --- > Use of ORDER BY on right side of Union All results in SqlValidatorException >

[jira] [Commented] (DRILL-3735) Directory pruning is not happening when number of files is larger than 64k

2015-09-15 Thread ASF GitHub Bot (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3735?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14745637#comment-14745637 ] ASF GitHub Bot commented on DRILL-3735: --- Github user jinfengni commented on a diff in the pull

[jira] [Commented] (DRILL-1942) Improve off-heap memory usage tracking

2015-09-15 Thread ASF GitHub Bot (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1942?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14745316#comment-14745316 ] ASF GitHub Bot commented on DRILL-1942: --- Github user asfgit closed the pull request at:

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

2015-09-15 Thread ASF GitHub Bot (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2650?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14745318#comment-14745318 ] ASF GitHub Bot commented on DRILL-2650: --- Github user asfgit closed the pull request at:

[jira] [Closed] (DRILL-1438) HBase queries fail with illegal char error

2015-09-15 Thread Krystal (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1438?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krystal closed DRILL-1438. -- Verified on latest master that bug is fixed. Test case added. > HBase queries fail with illegal char error >

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

2015-09-15 Thread Chun Chang (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3700?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chun Chang updated DRILL-3700: -- Assignee: Victoria Markman (was: Deneche A. Hakim) > Exception in a query with multiple fist_value

[jira] [Closed] (DRILL-2777) CTAS, order by and flatten of repeated list result in ExpandConversionRule error

2015-09-15 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2777?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman closed DRILL-2777. --- > CTAS, order by and flatten of repeated list result in ExpandConversionRule > error >

[jira] [Commented] (DRILL-2777) CTAS, order by and flatten of repeated list result in ExpandConversionRule error

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

[jira] [Commented] (DRILL-3767) SchemaPath.getCompoundPath(String...strings) reverses it's input array

2015-09-15 Thread ASF GitHub Bot (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3767?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14745619#comment-14745619 ] ASF GitHub Bot commented on DRILL-3767: --- Github user adeneche commented on a diff in the pull

[jira] [Closed] (DRILL-1145) Select from view created from a view returns NPE

2015-09-15 Thread Krystal (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1145?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krystal closed DRILL-1145. -- Already verified. Closing bug. > Select from view created from a view returns NPE >

[jira] [Issue Comment Deleted] (DRILL-2217) Trying to flatten an empty list should return an empty result

2015-09-15 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2217?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-2217: Comment: was deleted (was: With drill 1.2.0 I see result below and I'm not sure if it is

[jira] [Closed] (DRILL-1277) Join between 2 hbase/M7 tables using the dot notation fails

2015-09-15 Thread Krystal (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1277?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krystal closed DRILL-1277. -- Bug already verified as fixed. Test case added. > Join between 2 hbase/M7 tables using the dot notation fails >

[jira] [Commented] (DRILL-3735) Directory pruning is not happening when number of files is larger than 64k

2015-09-15 Thread ASF GitHub Bot (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3735?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14745632#comment-14745632 ] ASF GitHub Bot commented on DRILL-3735: --- Github user amansinha100 commented on a diff in the pull

[jira] [Commented] (DRILL-3735) Directory pruning is not happening when number of files is larger than 64k

2015-09-15 Thread ASF GitHub Bot (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3735?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14745636#comment-14745636 ] ASF GitHub Bot commented on DRILL-3735: --- Github user amansinha100 commented on a diff in the pull

[jira] [Commented] (DRILL-3761) CastIntDecimal implementation should not update the input holder.

2015-09-15 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3761?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14745844#comment-14745844 ] Jinfeng Ni commented on DRILL-3761: --- [~mehant], could you review this small patch? Thanks! >

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

[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-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] [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] [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=14746044#comment-14746044 ] Magnus Pierre commented on DRILL-3180: -- Hello Jacques, Sounds good. :) Re the question: I humbly

  1   2   >