[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] [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] [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] [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] [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] [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] [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] [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=14745973#comment-14745973 ] Victoria Markman commented on DRILL-3580: - Verified fixed in 1.2.0 #Fri Sep 11 05:38:24 UTC 2015

[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] [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=14745977#comment-14745977 ] Victoria Markman commented on DRILL-2949: - [~agirish], I think you've already re-enabled these.

[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=14746017#comment-14746017 ] Victoria Markman commented on DRILL-2313: - [~seanhychu], (1) Is this expected behavior ? {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=14746026#comment-14746026 ] Victoria Markman commented on DRILL-2313: - I answered question #2 myself: {code} 0:

[jira] [Commented] (DRILL-3382) CTAS with order by clause fails with IOOB exception

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

[jira] [Closed] (DRILL-3382) CTAS with order by clause fails with IOOB exception

2015-09-14 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3382?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman closed DRILL-3382. --- > CTAS with order by clause fails with IOOB exception >

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

2015-09-14 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2748?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14743789#comment-14743789 ] Victoria Markman commented on DRILL-2748: - Jinfeng, this is checked in already, correct ? >

[jira] [Commented] (DRILL-2549) Implicit Cast between integer and varchar columns in a join should work

2015-09-14 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2549?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14744395#comment-14744395 ] Victoria Markman commented on DRILL-2549: - [~rkins] This issue might be already fixed

[jira] [Commented] (DRILL-2418) Memory leak during execution if comparison function is not found

2015-09-14 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2418?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14744390#comment-14744390 ] Victoria Markman commented on DRILL-2418: - The original error happened much later during

[jira] [Closed] (DRILL-3412) Projections are not getting push down below Window operator

2015-09-14 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3412?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman closed DRILL-3412. --- > Projections are not getting push down below Window operator >

[jira] [Commented] (DRILL-3412) Projections are not getting push down below Window operator

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

[jira] [Updated] (DRILL-2830) Self-Join via view gives wrong results

2015-09-11 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2830?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-2830: Description: Create a view by: {code} create view v1(x, y) as select n_regionkey,

[jira] [Updated] (DRILL-2830) Self-Join via view gives wrong results

2015-09-11 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2830?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-2830: Description: Create a view by: {code} create view v1(x, y) as select n_regionkey,

[jira] [Closed] (DRILL-2190) Failure to order by function if DISTINCT clause is present

2015-09-11 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2190?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman closed DRILL-2190. --- > Failure to order by function if DISTINCT clause is present >

[jira] [Comment Edited] (DRILL-3280) Missing OVER clause in window function query results in AssertionError

2015-09-11 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3280?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14741179#comment-14741179 ] Victoria Markman edited comment on DRILL-3280 at 9/11/15 5:24 PM: -- Sean,

[jira] [Commented] (DRILL-3280) Missing OVER clause in window function query results in AssertionError

2015-09-11 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3280?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14741179#comment-14741179 ] Victoria Markman commented on DRILL-3280: - Sean, Case below should throw an error about rank()

[jira] [Reopened] (DRILL-3280) Missing OVER clause in window function query results in AssertionError

2015-09-11 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3280?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman reopened DRILL-3280: - > Missing OVER clause in window function query results in AssertionError >

[jira] [Commented] (DRILL-3493) Alter session command with an option to cancel query in a particular phase of execution

2015-09-11 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3493?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14741035#comment-14741035 ] Victoria Markman commented on DRILL-3493: - Yes, exception injector throwing OOM will test

[jira] [Commented] (DRILL-2318) Query fails when an ORDER BY clause is used with WITH-CLAUSE

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

[jira] [Commented] (DRILL-3280) Missing OVER clause in window function query results in AssertionError

2015-09-11 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3280?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14741339#comment-14741339 ] Victoria Markman commented on DRILL-3280: - Tests added in:

[jira] [Closed] (DRILL-3360) Window function defined within another window function

2015-09-11 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3360?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman closed DRILL-3360. --- > Window function defined within another window function >

[jira] [Commented] (DRILL-3360) Window function defined within another window function

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

[jira] [Commented] (DRILL-2830) Self-Join via view gives wrong results

2015-09-11 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2830?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14741461#comment-14741461 ] Victoria Markman commented on DRILL-2830: - I'm removing fix version from this bug, since this bug

[jira] [Updated] (DRILL-2830) Self-Join via view gives wrong results

2015-09-11 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2830?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-2830: Fix Version/s: (was: 1.2.0) > Self-Join via view gives wrong results >

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

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

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

2015-09-11 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3653?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman closed DRILL-3653. --- > Assert in a query with both avg aggregate and avg window aggregate functions >

[jira] [Commented] (DRILL-3601) LEAD function used without OVER clause should not plan

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

[jira] [Closed] (DRILL-3601) LEAD function used without OVER clause should not plan

2015-09-11 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3601?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman closed DRILL-3601. --- > LEAD function used without OVER clause should not plan >

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

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

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

2015-09-11 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3555?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman closed DRILL-3555. --- > Changing defaults for planner.memory.max_query_memory_per_node causes queries > with window

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

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

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

2015-09-11 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3649?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman closed DRILL-3649. --- > LEAD , LAG , NTILE , FIRST_VALUE , LAST_VALUE report RuntimeException for > missing OVER

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

2015-09-11 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3297?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman closed DRILL-3297. --- > Using rank, dense_rank, percent_rank, cume_dist, row_number window functions > without OVER

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

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

[jira] [Closed] (DRILL-2318) Query fails when an ORDER BY clause is used with WITH-CLAUSE

2015-09-11 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2318?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman closed DRILL-2318. --- > Query fails when an ORDER BY clause is used with WITH-CLAUSE >

[jira] [Updated] (DRILL-3769) to_date function with one argument returns wrong data type

2015-09-11 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3769?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3769: Component/s: Functions - Drill > to_date function with one argument returns wrong data type

[jira] [Updated] (DRILL-3769) to_date function with one argument returns wrong data type

2015-09-11 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3769?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3769: Affects Version/s: 1.2.0 1.1.0 > to_date function with one argument

[jira] [Created] (DRILL-3769) to_date function with one argument returns wrong data type

2015-09-11 Thread Victoria Markman (JIRA)
Victoria Markman created DRILL-3769: --- Summary: to_date function with one argument returns wrong data type Key: DRILL-3769 URL: https://issues.apache.org/jira/browse/DRILL-3769 Project: Apache Drill

[jira] [Commented] (DRILL-2095) Order by on a repeated index inside a sub query results in an NPE

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

[jira] [Closed] (DRILL-2095) Order by on a repeated index inside a sub query results in an NPE

2015-09-11 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2095?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman closed DRILL-2095. --- > Order by on a repeated index inside a sub query results in an NPE >

[jira] [Created] (DRILL-3758) InvalidRecorException while selecting from a table with multiple parquet file

2015-09-10 Thread Victoria Markman (JIRA)
Victoria Markman created DRILL-3758: --- Summary: InvalidRecorException while selecting from a table with multiple parquet file Key: DRILL-3758 URL: https://issues.apache.org/jira/browse/DRILL-3758

[jira] [Updated] (DRILL-3758) InvalidRecorException while selecting from a table with multiple parquet file

2015-09-10 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3758?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3758: Attachment: drillbit.log > InvalidRecorException while selecting from a table with multiple

[jira] [Updated] (DRILL-3758) InvalidRecorException while selecting from a table with multiple parquet file

2015-09-10 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3758?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3758: Assignee: Deneche A. Hakim (was: Steven Phillips) > InvalidRecorException while selecting

[jira] [Commented] (DRILL-3758) InvalidRecorException while selecting from a table with multiple parquet file

2015-09-10 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3758?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14739119#comment-14739119 ] Victoria Markman commented on DRILL-3758: - test2.tar is too big to attach here. >

[jira] [Updated] (DRILL-3758) InvalidRecordException while selecting from a table with multiple parquet file

2015-09-10 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3758?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3758: Summary: InvalidRecordException while selecting from a table with multiple parquet file

[jira] [Updated] (DRILL-3139) Query against yelp academic dataset causes exception - improve error message

2015-09-10 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3139?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3139: Summary: Query against yelp academic dataset causes exception - improve error message

[jira] [Commented] (DRILL-2152) Scalar Subqueries error message should be friendly

2015-09-10 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2152?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14739819#comment-14739819 ] Victoria Markman commented on DRILL-2152: - Yes, these queries are supported now and we do have

[jira] [Reopened] (DRILL-2152) Scalar Subqueries error message should be friendly

2015-09-10 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2152?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman reopened DRILL-2152: - > Scalar Subqueries error message should be friendly >

[jira] [Closed] (DRILL-1784) Ignore boolean type enforcement on filter conditions during validation

2015-09-10 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1784?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman closed DRILL-1784. --- > Ignore boolean type enforcement on filter conditions during validation >

[jira] [Updated] (DRILL-1784) Ignore boolean type enforcement on filter conditions during validation

2015-09-10 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1784?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-1784: Fix Version/s: (was: 1.2.0) > Ignore boolean type enforcement on filter conditions

[jira] [Reopened] (DRILL-2190) Failure to order by function if DISTINCT clause is present

2015-09-04 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2190?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman reopened DRILL-2190: - > Failure to order by function if DISTINCT clause is present >

[jira] [Commented] (DRILL-2190) Failure to order by function if DISTINCT clause is present

2015-09-04 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2190?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14731212#comment-14731212 ] Victoria Markman commented on DRILL-2190: - Sean, It does not seem to work in the latest 1.2.0 ...

[jira] [Closed] (DRILL-1395) UNION ALL query fails "while setting up Foreman"

2015-09-04 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1395?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman closed DRILL-1395. --- > UNION ALL query fails "while setting up Foreman" >

[jira] [Commented] (DRILL-1395) UNION ALL query fails "while setting up Foreman"

2015-09-04 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1395?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14731677#comment-14731677 ] Victoria Markman commented on DRILL-1395: - Verified fixed in 1.2.0 #Fri Sep 04 00:17:59 UTC 2015

[jira] [Commented] (DRILL-3685) Failure to execute query with NTILE and ROW_NUMBER window functions with different window definitions

2015-09-03 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3685?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14729701#comment-14729701 ] Victoria Markman commented on DRILL-3685: - Verified fixed in 1.2 #Thu Sep 03 00:07:29 UTC 2015

[jira] [Closed] (DRILL-3685) Failure to execute query with NTILE and ROW_NUMBER window functions with different window definitions

2015-09-03 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3685?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman closed DRILL-3685. --- > Failure to execute query with NTILE and ROW_NUMBER window functions with > different window

[jira] [Closed] (DRILL-2802) Projecting dir[n] by itself results in projecting of all columns

2015-09-03 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2802?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman closed DRILL-2802. --- > Projecting dir[n] by itself results in projecting of all columns >

[jira] [Commented] (DRILL-2802) Projecting dir[n] by itself results in projecting of all columns

2015-09-03 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2802?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14729722#comment-14729722 ] Victoria Markman commented on DRILL-2802: - Verified fixed in 1.2.0 #Thu Sep 03 00:07:29 UTC 2015

[jira] [Commented] (DRILL-3657) Wrong result with SUM(1) window function when multiple partitions are present

2015-09-03 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3657?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14729735#comment-14729735 ] Victoria Markman commented on DRILL-3657: - Verified fixed in 1.2.0 #Thu Sep 03 00:07:29 UTC 2015

[jira] [Closed] (DRILL-3657) Wrong result with SUM(1) window function when multiple partitions are present

2015-09-03 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3657?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman closed DRILL-3657. --- > Wrong result with SUM(1) window function when multiple partitions are present >

[jira] [Closed] (DRILL-2867) Session level parameter drill.exec.testing.controls appears to be set even though it was not

2015-09-03 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2867?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman closed DRILL-2867. --- > Session level parameter drill.exec.testing.controls appears to be set even > though it was

[jira] [Commented] (DRILL-2867) Session level parameter drill.exec.testing.controls appears to be set even though it was not

2015-09-03 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2867?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14729761#comment-14729761 ] Victoria Markman commented on DRILL-2867: - Verified fixed in 1.2.0 #Thu Sep 03 00:07:29 UTC 2015

[jira] [Commented] (DRILL-2643) HashAggBatch/HashAggTemplate call incoming.cleanup() twice resulting in warnings

2015-09-03 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2643?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14729885#comment-14729885 ] Victoria Markman commented on DRILL-2643: - The warning is not there as of drill 1.2.0 #Thu Sep 03

[jira] [Commented] (DRILL-3348) NPE when two different window functions are used in projection list and order by clauses

2015-09-03 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3348?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14729754#comment-14729754 ] Victoria Markman commented on DRILL-3348: - Verified fixed in 1.2.0 #Thu Sep 03 00:07:29 UTC 2015

[jira] [Closed] (DRILL-3056) Numeric literal in an IN list is casted to decimal even when decimal type is disabled

2015-09-03 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3056?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman closed DRILL-3056. --- > Numeric literal in an IN list is casted to decimal even when decimal type is > disabled >

[jira] [Commented] (DRILL-3122) Changing a session option to default value results in status as changed

2015-09-03 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3122?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14730051#comment-14730051 ] Victoria Markman commented on DRILL-3122: - This is fixed in 1.2.0 #Thu Sep 03 00:07:29 UTC 2015

[jira] [Updated] (DRILL-3287) Changing session level parameter back to the default value does not change it's status back to DEFAULT

2015-09-03 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3287?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3287: Fix Version/s: (was: 1.3.0) 1.2.0 > Changing session level parameter

[jira] [Commented] (DRILL-1938) Fix error message when reserved words are used in query.

2015-09-03 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1938?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14730076#comment-14730076 ] Victoria Markman commented on DRILL-1938: - Verified fixed in 1.2.0 #Thu Sep 03 00:07:29 UTC 2015

[jira] [Closed] (DRILL-1938) Fix error message when reserved words are used in query.

2015-09-03 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1938?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman closed DRILL-1938. --- > Fix error message when reserved words are used in query. >

[jira] [Updated] (DRILL-1938) Fix error message when reserved words are used in query.

2015-09-03 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1938?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-1938: Labels: no_verified_test (was: ) > Fix error message when reserved words are used in

[jira] [Closed] (DRILL-3076) USING clause should not be supported in drill

2015-09-03 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3076?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman closed DRILL-3076. --- > USING clause should not be supported in drill > --

[jira] [Commented] (DRILL-3056) Numeric literal in an IN list is casted to decimal even when decimal type is disabled

2015-09-03 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3056?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14729911#comment-14729911 ] Victoria Markman commented on DRILL-3056: - Verified by auditing drillbit.log for this query:

[jira] [Commented] (DRILL-2874) Concat operator is not supported with complex types, we should throw an error early

2015-09-03 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2874?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14729928#comment-14729928 ] Victoria Markman commented on DRILL-2874: - Sean, I think we should fix at least "SYSTEM ERROR" to

[jira] [Reopened] (DRILL-2874) Concat operator is not supported with complex types, we should throw an error early

2015-09-03 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2874?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman reopened DRILL-2874: - > Concat operator is not supported with complex types, we should throw an error > early >

[jira] [Resolved] (DRILL-3287) Changing session level parameter back to the default value does not change it's status back to DEFAULT

2015-09-03 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3287?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman resolved DRILL-3287. - Resolution: Fixed Resolved in 1.2.0, see comments in DRILL-3122 > Changing session level

[jira] [Closed] (DRILL-3287) Changing session level parameter back to the default value does not change it's status back to DEFAULT

2015-09-03 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3287?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman closed DRILL-3287. --- > Changing session level parameter back to the default value does not change > it's status back

[jira] [Closed] (DRILL-3122) Changing a session option to default value results in status as changed

2015-09-03 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3122?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman closed DRILL-3122. --- > Changing a session option to default value results in status as changed >

[jira] [Closed] (DRILL-3292) SUM(constant) OVER(...) returns wrong results

2015-09-03 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3292?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman closed DRILL-3292. --- > SUM(constant) OVER(...) returns wrong results > - >

[jira] [Commented] (DRILL-3292) SUM(constant) OVER(...) returns wrong results

2015-09-03 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3292?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14730082#comment-14730082 ] Victoria Markman commented on DRILL-3292: - Verified in 1.2.0 #Thu Sep 03 00:07:29 UTC 2015

[jira] [Closed] (DRILL-3691) CTAS Memory Leak : IllegalStateException

2015-09-03 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3691?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman closed DRILL-3691. --- > CTAS Memory Leak : IllegalStateException > > >

[jira] [Closed] (DRILL-3684) CTAS : Memory Leak when using CTAS with tpch sf100

2015-09-03 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3684?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman closed DRILL-3684. --- > CTAS : Memory Leak when using CTAS with tpch sf100 >

[jira] [Closed] (DRILL-3348) NPE when two different window functions are used in projection list and order by clauses

2015-09-03 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3348?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman closed DRILL-3348. --- > NPE when two different window functions are used in projection list and order > by clauses >

[jira] [Closed] (DRILL-2864) Unable to cast string literal with the valid value in ISO 8601 format to interval

2015-09-02 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2864?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman closed DRILL-2864. --- > Unable to cast string literal with the valid value in ISO 8601 format to > interval >

[jira] [Commented] (DRILL-3691) CTAS Memory Leak : IllegalStateException

2015-09-02 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3691?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14728330#comment-14728330 ] Victoria Markman commented on DRILL-3691: - Hakim, I think DRILL-3673, DRILL-3684 and DRILL-3691

[jira] [Commented] (DRILL-3734) CTAS with partition by clause causes NPE

2015-09-02 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3734?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14727980#comment-14727980 ] Victoria Markman commented on DRILL-3734: - Query without CTAS successfully completes. {code} ...

[jira] [Updated] (DRILL-3729) Remove info message about invalid argument during query planning where filter is a directory

2015-09-02 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3729?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3729: Assignee: Mehant Baid > Remove info message about invalid argument during query planning

[jira] [Closed] (DRILL-3673) Memory leak in parquet writer on CTAS

2015-09-02 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3673?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman closed DRILL-3673. --- > Memory leak in parquet writer on CTAS > - > >

[jira] [Commented] (DRILL-3673) Memory leak in parquet writer on CTAS

2015-09-02 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3673?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14728169#comment-14728169 ] Victoria Markman commented on DRILL-3673: - I can't reproduce this bug with the latest rpm. Had 10

[jira] [Resolved] (DRILL-3673) Memory leak in parquet writer on CTAS

2015-09-02 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3673?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman resolved DRILL-3673. - Resolution: Fixed > Memory leak in parquet writer on CTAS >

<    1   2   3   4   5   6   7   8   9   10   >