[jira] [Created] (DRILL-3287) Changing session level parameter back to the default value does not change it

2015-06-12 Thread Victoria Markman (JIRA)
Victoria Markman created DRILL-3287: --- Summary: Changing session level parameter back to the default value does not change it Key: DRILL-3287 URL: https://issues.apache.org/jira/browse/DRILL-3287 Pro

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

2015-06-12 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: Summary: Changing session level parameter back to the default value does not change it's sta

[jira] [Created] (DRILL-3288) False "Hash aggregate does not support schema changes" error message in a query containing both window and regular aggregate function

2015-06-12 Thread Victoria Markman (JIRA)
Victoria Markman created DRILL-3288: --- Summary: False "Hash aggregate does not support schema changes" error message in a query containing both window and regular aggregate function Key: DRILL-3288 URL: https://i

[jira] [Updated] (DRILL-3288) False "Hash aggregate does not support schema changes" error message in a query containing both window and regular aggregate function

2015-06-12 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3288?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3288: Description: This error seems to be happening only when you have both window and regular ag

[jira] [Commented] (DRILL-3288) False "Hash aggregate does not support schema changes" error message in a query with merge join and hash aggregation

2015-06-12 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3288?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14584210#comment-14584210 ] Victoria Markman commented on DRILL-3288: - I take it back, it can be reproduced wi

[jira] [Updated] (DRILL-3288) False "Hash aggregate does not support schema changes" error message in a query with merge join and hash aggregation

2015-06-12 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3288?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3288: Summary: False "Hash aggregate does not support schema changes" error message in a query wit

[jira] [Comment Edited] (DRILL-3288) False "Hash aggregate does not support schema changes" error message in a query with merge join and hash aggregation

2015-06-12 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3288?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14584210#comment-14584210 ] Victoria Markman edited comment on DRILL-3288 at 6/12/15 10:47 PM: -

[jira] [Updated] (DRILL-3288) False "Hash aggregate does not support schema changes" error message in a query with merge join and hash aggregation

2015-06-12 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3288?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3288: Labels: (was: window_function) > False "Hash aggregate does not support schema changes" er

[jira] [Updated] (DRILL-3288) False "Hash aggregate does not support schema changes" error message in a query with merge join and hash aggregation

2015-06-12 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3288?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3288: Attachment: j7.parquet j6.parquet > False "Hash aggregate does not support s

[jira] [Updated] (DRILL-1169) Add support for UNION (distinct type)

2015-06-12 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1169?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-1169: Labels: doc-impacting (was: ) > Add support for UNION (distinct type) > ---

[jira] [Created] (DRILL-3293) CTAS with window function fails with NPE

2015-06-15 Thread Victoria Markman (JIRA)
Victoria Markman created DRILL-3293: --- Summary: CTAS with window function fails with NPE Key: DRILL-3293 URL: https://issues.apache.org/jira/browse/DRILL-3293 Project: Apache Drill Issue Typ

[jira] [Updated] (DRILL-3293) CTAS with window function fails with NPE

2015-06-15 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3293?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3293: Labels: window_function (was: ) > CTAS with window function fails with NPE > --

[jira] [Updated] (DRILL-3293) CTAS with window function fails with NPE

2015-06-15 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3293?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3293: Attachment: t1_parquet > CTAS with window function fails with NPE >

[jira] [Created] (DRILL-3294) False schema change exception in CTAS with AVG window function

2015-06-15 Thread Victoria Markman (JIRA)
Victoria Markman created DRILL-3294: --- Summary: False schema change exception in CTAS with AVG window function Key: DRILL-3294 URL: https://issues.apache.org/jira/browse/DRILL-3294 Project: Apache Dr

[jira] [Updated] (DRILL-3294) False schema change exception in CTAS with AVG window function

2015-06-15 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3294?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3294: Labels: window_function (was: ) > False schema change exception in CTAS with AVG window fun

[jira] [Commented] (DRILL-3211) Assert in a query with window function and group by clause

2015-06-15 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3211?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14586615#comment-14586615 ] Victoria Markman commented on DRILL-3211: - There is one more case, where we should

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

2015-06-15 Thread Victoria Markman (JIRA)
Victoria Markman created DRILL-3297: --- Summary: Using rank, dense_rank, percent_rank, cume_dist, row_number window functions without OVER clause results in cryptic schema change error Key: DRILL-3297 URL: https:

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

2015-06-15 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3297?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3297: Description: {code} 0: jdbc:drill:schema=dfs> select rank() from t1; java.lang.RuntimeExcept

[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-06-15 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3297?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14587103#comment-14587103 ] Victoria Markman commented on DRILL-3297: - Jinfeng, I did not expect this to work.

[jira] [Created] (DRILL-3298) Wrong result with SUM window function and order by without partition by in the OVER clause

2015-06-15 Thread Victoria Markman (JIRA)
Victoria Markman created DRILL-3298: --- Summary: Wrong result with SUM window function and order by without partition by in the OVER clause Key: DRILL-3298 URL: https://issues.apache.org/jira/browse/DRILL-3298

[jira] [Updated] (DRILL-3298) Wrong result with SUM window function and order by without partition by in the OVER clause

2015-06-15 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3298?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3298: Labels: window_function (was: ) > Wrong result with SUM window function and order by withou

[jira] [Updated] (DRILL-3298) Wrong result with SUM window function and order by without partition by in the OVER clause

2015-06-15 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3298?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3298: Attachment: test.res j1.tar > Wrong result with SUM window function and orde

[jira] [Commented] (DRILL-3298) Wrong result with SUM window function and order by without partition by in the OVER clause

2015-06-15 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3298?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14587199#comment-14587199 ] Victoria Markman commented on DRILL-3298: - Labeled it as "window_function" until p

[jira] [Commented] (DRILL-3298) Wrong result with SUM window function and order by without partition by in the OVER clause

2015-06-16 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3298?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14588391#comment-14588391 ] Victoria Markman commented on DRILL-3298: - My apologies, wrong file was attached.

[jira] [Updated] (DRILL-3298) Wrong result with SUM window function and order by without partition by in the OVER clause

2015-06-16 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3298?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3298: Attachment: (was: test.res) > Wrong result with SUM window function and order by without

[jira] [Updated] (DRILL-3298) Wrong result with SUM window function and order by without partition by in the OVER clause

2015-06-16 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3298?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3298: Attachment: test.res > Wrong result with SUM window function and order by without partition

[jira] [Updated] (DRILL-3298) Wrong result with SUM window function and order by without partition by in the OVER clause

2015-06-16 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3298?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3298: Attachment: test.res > Wrong result with SUM window function and order by without partition

[jira] [Updated] (DRILL-3298) Wrong result with SUM window function and order by without partition by in the OVER clause

2015-06-16 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3298?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3298: Attachment: (was: test.res) > Wrong result with SUM window function and order by without

[jira] [Resolved] (DRILL-2988) Correlated exists subquery returns wrong result if join columns in subquery are not fully qualified

2015-06-16 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2988?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman resolved DRILL-2988. - Resolution: Won't Fix This works as by design currently. > Correlated exists subquery re

[jira] [Commented] (DRILL-3307) Query with window function runs out of memory

2015-06-17 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3307?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14590909#comment-14590909 ] Victoria Markman commented on DRILL-3307: - It is not the same as https://issues.ap

[jira] [Comment Edited] (DRILL-3307) Query with window function runs out of memory

2015-06-17 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3307?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14590909#comment-14590909 ] Victoria Markman edited comment on DRILL-3307 at 6/18/15 12:33 AM: -

[jira] [Created] (DRILL-3311) sqlline hangs when query is cancelled while results are returned from the server

2015-06-18 Thread Victoria Markman (JIRA)
Victoria Markman created DRILL-3311: --- Summary: sqlline hangs when query is cancelled while results are returned from the server Key: DRILL-3311 URL: https://issues.apache.org/jira/browse/DRILL-3311

[jira] [Commented] (DRILL-3311) sqlline hangs when query is cancelled while results are returned from the server

2015-06-18 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3311?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14592201#comment-14592201 ] Victoria Markman commented on DRILL-3311: - This was fixed in 1.0.0 timeframe, soun

[jira] [Commented] (DRILL-3196) Disable multiple partition by clauses in the same sql query

2015-06-18 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3196?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14592544#comment-14592544 ] Victoria Markman commented on DRILL-3196: - Verified fixed in: 1.1.0 #Thu Jun 18 1

[jira] [Updated] (DRILL-3196) Disable multiple partition by clauses in the same sql query

2015-06-18 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3196?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3196: Labels: no_verified_test window_function (was: window_function) > Disable multiple partitio

[jira] [Closed] (DRILL-3196) Disable multiple partition by clauses in the same sql query

2015-06-18 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3196?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman closed DRILL-3196. --- > Disable multiple partition by clauses in the same sql query > --

[jira] [Commented] (DRILL-3172) Can not plan exception when over clause is empty

2015-06-18 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3172?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14592559#comment-14592559 ] Victoria Markman commented on DRILL-3172: - Verified fixed in: 1.1.0 #Thu Jun 18 1

[jira] [Closed] (DRILL-3172) Can not plan exception when over clause is empty

2015-06-18 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3172?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman closed DRILL-3172. --- > Can not plan exception when over clause is empty >

[jira] [Closed] (DRILL-3195) Throw unsupported exception for Window functions that are not currently supported

2015-06-18 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3195?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman closed DRILL-3195. --- > Throw unsupported exception for Window functions that are not currently > supported > -

[jira] [Commented] (DRILL-3195) Throw unsupported exception for Window functions that are not currently supported

2015-06-18 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3195?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14592817#comment-14592817 ] Victoria Markman commented on DRILL-3195: - Verified fixed in: 1.1.0 #Thu Jun 18 1

[jira] [Created] (DRILL-3325) Explicitly specified default window frame throws an error requiring order by

2015-06-19 Thread Victoria Markman (JIRA)
Victoria Markman created DRILL-3325: --- Summary: Explicitly specified default window frame throws an error requiring order by Key: DRILL-3325 URL: https://issues.apache.org/jira/browse/DRILL-3325 Proj

[jira] [Updated] (DRILL-3327) row_number function returns incorrect result when only order by clause is specified

2015-06-19 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3327?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3327: Attachment: row_number_wrong_result.tar > row_number function returns incorrect result when

[jira] [Created] (DRILL-3327) row_number function returns incorrect result when only order by clause is specified

2015-06-19 Thread Victoria Markman (JIRA)
Victoria Markman created DRILL-3327: --- Summary: row_number function returns incorrect result when only order by clause is specified Key: DRILL-3327 URL: https://issues.apache.org/jira/browse/DRILL-3327

[jira] [Updated] (DRILL-3327) row_number function returns incorrect result when only order by clause is specified

2015-06-19 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3327?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3327: Attachment: j1.tar > row_number function returns incorrect result when only order by clause

[jira] [Commented] (DRILL-3327) row_number function returns incorrect result when only order by clause is specified

2015-06-19 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3327?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14594086#comment-14594086 ] Victoria Markman commented on DRILL-3327: - I will work on a smaller reproduction.

[jira] [Updated] (DRILL-3327) row_number function returns incorrect result when only order by clause is specified

2015-06-19 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3327?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3327: Labels: window_function (was: ) > row_number function returns incorrect result when only or

[jira] [Updated] (DRILL-3293) CTAS with window function fails with UnsupportedOperationException

2015-06-22 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3293?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3293: Fix Version/s: 1.1.0 > CTAS with window function fails with UnsupportedOperationException >

[jira] [Commented] (DRILL-3265) Query with window function and sort below that spills to disk runs out of memory

2015-06-22 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3265?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14596250#comment-14596250 ] Victoria Markman commented on DRILL-3265: - This query now runs: memory leak was fi

[jira] [Updated] (DRILL-3326) Query with unsupported windows function containing "AS" blocks correct error message

2015-06-22 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3326?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3326: Labels: window_function (was: ) > Query with unsupported windows function containing "AS" b

[jira] [Updated] (DRILL-3337) Queries with Window Function DENSE_RANK fail with SchemaChangeException

2015-06-22 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3337?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3337: Labels: window_function (was: ) > Queries with Window Function DENSE_RANK fail with SchemaC

[jira] [Closed] (DRILL-3265) Query with window function and sort below that spills to disk runs out of memory

2015-06-22 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3265?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman closed DRILL-3265. --- > Query with window function and sort below that spills to disk runs out of > memory > --

[jira] [Resolved] (DRILL-3265) Query with window function and sort below that spills to disk runs out of memory

2015-06-22 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3265?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman resolved DRILL-3265. - Resolution: Fixed > Query with window function and sort below that spills to disk runs out

[jira] [Commented] (DRILL-3265) Query with window function and sort below that spills to disk runs out of memory

2015-06-22 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3265?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14596882#comment-14596882 ] Victoria Markman commented on DRILL-3265: - Memory leak is fixed. Drill returns co

[jira] [Resolved] (DRILL-3338) Error message must be modified when PERCENT_RANK window functions are used without ORDER BY

2015-06-22 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3338?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman resolved DRILL-3338. - Resolution: Duplicate > Error message must be modified when PERCENT_RANK window functions

[jira] [Closed] (DRILL-3338) Error message must be modified when PERCENT_RANK window functions are used without ORDER BY

2015-06-22 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3338?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman closed DRILL-3338. --- > Error message must be modified when PERCENT_RANK window functions are used > without ORDER BY

[jira] [Updated] (DRILL-3294) False schema change exception in CTAS with AVG window function

2015-06-22 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3294?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3294: Attachment: t1_parquet > False schema change exception in CTAS with AVG window function > --

[jira] [Created] (DRILL-3343) Seemingly incorrect result with SUM window functions and float data type

2015-06-23 Thread Victoria Markman (JIRA)
Victoria Markman created DRILL-3343: --- Summary: Seemingly incorrect result with SUM window functions and float data type Key: DRILL-3343 URL: https://issues.apache.org/jira/browse/DRILL-3343 Project:

[jira] [Updated] (DRILL-3343) Seemingly incorrect result with SUM window functions and float data type

2015-06-23 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3343?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3343: Labels: window_function (was: ) > Seemingly incorrect result with SUM window functions and

[jira] [Updated] (DRILL-3343) Seemingly incorrect result with SUM window functions and float data type

2015-06-23 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3343?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3343: Attachment: create_table.tar voter_hive queries.tar > Seemin

[jira] [Updated] (DRILL-3343) Seemingly incorrect result with SUM window functions and float data type

2015-06-23 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3343?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3343: Component/s: Execution - Data Types > Seemingly incorrect result with SUM window functions a

[jira] [Updated] (DRILL-3345) TestWindowFrame fails to properly check cases involving multiple batches

2015-06-23 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3345?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3345: Labels: window_function (was: ) > TestWindowFrame fails to properly check cases involving m

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

2015-06-23 Thread Victoria Markman (JIRA)
Victoria Markman created DRILL-3348: --- Summary: NPE when two different window functions are used in projection list and order by clauses Key: DRILL-3348 URL: https://issues.apache.org/jira/browse/DRILL-3348

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

2015-06-23 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3348?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3348: Labels: window_funcion (was: ) > NPE when two different window functions are used in projec

[jira] [Resolved] (DRILL-3351) Invalid query must be caught earlier

2015-06-24 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3351?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman resolved DRILL-3351. - Resolution: Duplicate > Invalid query must be caught earlier > ---

[jira] [Commented] (DRILL-3293) CTAS with window function fails with UnsupportedOperationException

2015-06-24 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3293?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14599664#comment-14599664 ] Victoria Markman commented on DRILL-3293: - Verified fixed in: 1.1.0 #Wed Jun 24 0

[jira] [Closed] (DRILL-3293) CTAS with window function fails with UnsupportedOperationException

2015-06-24 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3293?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman closed DRILL-3293. --- > CTAS with window function fails with UnsupportedOperationException > ---

[jira] [Commented] (DRILL-3294) False schema change exception in CTAS with AVG window function

2015-06-24 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3294?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14599676#comment-14599676 ] Victoria Markman commented on DRILL-3294: - Verified fixed in 1.1 #Wed Jun 24 04:5

[jira] [Closed] (DRILL-3294) False schema change exception in CTAS with AVG window function

2015-06-24 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3294?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman closed DRILL-3294. --- > False schema change exception in CTAS with AVG window function > ---

[jira] [Commented] (DRILL-3343) Seemingly incorrect result with SUM window functions and float data type

2015-06-24 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3343?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14600100#comment-14600100 ] Victoria Markman commented on DRILL-3343: - Your comment in DRILL-3188 implies that

[jira] [Commented] (DRILL-3343) Seemingly incorrect result with SUM window functions and float data type

2015-06-24 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3343?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14600106#comment-14600106 ] Victoria Markman commented on DRILL-3343: - AS Hakim pointed out, this is "ROWS" an

[jira] [Commented] (DRILL-3288) False "Hash aggregate does not support schema changes" error message in a query with merge join and hash aggregation

2015-06-25 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3288?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14601396#comment-14601396 ] Victoria Markman commented on DRILL-3288: - My bad, by looking at the plan, you ca

[jira] [Updated] (DRILL-3288) False "Hash aggregate does not support schema changes" error message in a query with merge join and hash aggregation

2015-06-25 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3288?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3288: Assignee: Deneche A. Hakim (was: Victoria Markman) > False "Hash aggregate does not support

[jira] [Comment Edited] (DRILL-3288) False "Hash aggregate does not support schema changes" error message in a query with merge join and hash aggregation

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

[jira] [Resolved] (DRILL-3327) row_number function returns incorrect result when only order by clause is specified

2015-06-25 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3327?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman resolved DRILL-3327. - Resolution: Fixed > row_number function returns incorrect result when only order by clause

[jira] [Commented] (DRILL-3327) row_number function returns incorrect result when only order by clause is specified

2015-06-25 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3327?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14601624#comment-14601624 ] Victoria Markman commented on DRILL-3327: - Verified fixed in 1.1 #Thu Jun 25 09:1

[jira] [Closed] (DRILL-3327) row_number function returns incorrect result when only order by clause is specified

2015-06-25 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3327?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman closed DRILL-3327. --- > row_number function returns incorrect result when only order by clause is > specified > ---

[jira] [Updated] (DRILL-3182) Window function with DISTINCT qualifier returns seemingly incorrect result

2015-06-25 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3182?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3182: Labels: no_verified_test window_function (was: window_function) > Window function with DIST

[jira] [Commented] (DRILL-3182) Window function with DISTINCT qualifier returns seemingly incorrect result

2015-06-25 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3182?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14601753#comment-14601753 ] Victoria Markman commented on DRILL-3182: - Verified fixed in 1.1 #Thu Jun 25 09:1

[jira] [Closed] (DRILL-3182) Window function with DISTINCT qualifier returns seemingly incorrect result

2015-06-25 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3182?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman closed DRILL-3182. --- > Window function with DISTINCT qualifier returns seemingly incorrect result > ---

[jira] [Created] (DRILL-3375) Window function in order by clause fails if window clause is used

2015-06-25 Thread Victoria Markman (JIRA)
Victoria Markman created DRILL-3375: --- Summary: Window function in order by clause fails if window clause is used Key: DRILL-3375 URL: https://issues.apache.org/jira/browse/DRILL-3375 Project: Apache

[jira] [Updated] (DRILL-3375) Window function in order by clause fails if window clause is used

2015-06-25 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3375?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3375: Labels: window (was: window_function) > Window function in order by clause fails if window

[jira] [Updated] (DRILL-3375) Window function in order by clause fails if window clause is used

2015-06-25 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3375?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3375: Labels: window_function (was: window) > Window function in order by clause fails if window

[jira] [Commented] (DRILL-3210) Star is not expanded correctly in projection list when used with window function

2015-06-25 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3210?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14602011#comment-14602011 ] Victoria Markman commented on DRILL-3210: - Verified fixed in 1.1 #Thu Jun 25 09:1

[jira] [Closed] (DRILL-3210) Star is not expanded correctly in projection list when used with window function

2015-06-25 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3210?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman closed DRILL-3210. --- > Star is not expanded correctly in projection list when used with window > function > --

[jira] [Created] (DRILL-3377) Can't partition by expression when columns are explicitly specified in the CTAS column list

2015-06-25 Thread Victoria Markman (JIRA)
Victoria Markman created DRILL-3377: --- Summary: Can't partition by expression when columns are explicitly specified in the CTAS column list Key: DRILL-3377 URL: https://issues.apache.org/jira/browse/DRILL-3377

[jira] [Updated] (DRILL-3377) Can't partition by expression when columns are explicitly specified in the CTAS column list

2015-06-25 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3377?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3377: Labels: ctas (was: ) > Can't partition by expression when columns are explicitly specified

[jira] [Commented] (DRILL-3377) Can't partition by expression when columns are explicitly specified in the CTAS column list

2015-06-25 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3377?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14602139#comment-14602139 ] Victoria Markman commented on DRILL-3377: - Could be the same as DRILL-3374 > Can'

[jira] [Commented] (DRILL-1862) over clause with only order by clause throws an exception

2015-06-26 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1862?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14603023#comment-14603023 ] Victoria Markman commented on DRILL-1862: - Verified fixed in: 1.1 #Thu Jun 25 23:5

[jira] [Closed] (DRILL-1862) over clause with only order by clause throws an exception

2015-06-26 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1862?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman closed DRILL-1862. --- > over clause with only order by clause throws an exception >

[jira] [Commented] (DRILL-3279) Window functions without ORDER BY - Error message needs to be fixed

2015-06-26 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3279?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14603165#comment-14603165 ] Victoria Markman commented on DRILL-3279: - Hakim and I investigated this morning a

[jira] [Comment Edited] (DRILL-3279) Window functions without ORDER BY - Error message needs to be fixed

2015-06-26 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3279?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14603165#comment-14603165 ] Victoria Markman edited comment on DRILL-3279 at 6/26/15 4:52 PM: --

[jira] [Updated] (DRILL-3396) Add other function names to the error message disallowing frame definition

2015-06-26 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3396?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3396: Labels: window_function (was: ) > Add other function names to the error message disallowing

[jira] [Created] (DRILL-3396) Add other function names to the error message disallowing frame definition

2015-06-26 Thread Victoria Markman (JIRA)
Victoria Markman created DRILL-3396: --- Summary: Add other function names to the error message disallowing frame definition Key: DRILL-3396 URL: https://issues.apache.org/jira/browse/DRILL-3396 Projec

[jira] [Updated] (DRILL-3396) Add other function names to the error message disallowing frame definition

2015-06-26 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3396?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3396: Affects Version/s: 1.1.0 > Add other function names to the error message disallowing frame d

[jira] [Updated] (DRILL-3396) Add other function names to the error message disallowing frame definition

2015-06-26 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3396?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3396: Component/s: Query Planning & Optimization > Add other function names to the error message d

[jira] [Updated] (DRILL-3396) Add other function names to the error message disallowing frame definition

2015-06-26 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3396?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3396: Fix Version/s: 1.2.0 > Add other function names to the error message disallowing frame defin

[jira] [Updated] (DRILL-3326) Query with unsupported windows function containing "AS" blocks correct error message

2015-06-26 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3326?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3326: Labels: no_verified_test window_function (was: window_function) > Query with unsupported wi

[jira] [Closed] (DRILL-3326) Query with unsupported windows function containing "AS" blocks correct error message

2015-06-26 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3326?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman closed DRILL-3326. --- > Query with unsupported windows function containing "AS" blocks correct error > message > --

[jira] [Commented] (DRILL-3326) Query with unsupported windows function containing "AS" blocks correct error message

2015-06-26 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3326?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14603225#comment-14603225 ] Victoria Markman commented on DRILL-3326: - Verified fixed in 1.1 #Thu Jun 25 23:5

[jira] [Commented] (DRILL-3359) Drill should throw and error when window function defined using WINDOW AS uses ROWS UNBOUNDED PRECEDING

2015-06-26 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3359?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14603268#comment-14603268 ] Victoria Markman commented on DRILL-3359: - Verified fixed in 1.1 #Thu Jun 25 23:5

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