[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&focusedCommentId=14731677#comment-14731677 ] Victoria Markman commented on DRILL-1395: - Verified fixed in 1.2.0 #Fri Sep 04 00

[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&focusedCommentId=14731212#comment-14731212 ] Victoria Markman commented on DRILL-2190: - Sean, It does not seem to work in the

[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] [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] [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&focusedCommentId=14730082#comment-14730082 ] Victoria Markman commented on DRILL-3292: - Verified in 1.2.0 #Thu Sep 03 00:07:29

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

[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] [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&focusedCommentId=14730076#comment-14730076 ] Victoria Markman commented on DRILL-1938: - Verified fixed in 1.2.0 #Thu Sep 03 00

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

[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] [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&focusedCommentId=14730051#comment-14730051 ] Victoria Markman commented on DRILL-3122: - This is fixed in 1.2.0 #Thu Sep 03 00:

[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] [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] [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&focusedCommentId=14729928#comment-14729928 ] Victoria Markman commented on DRILL-2874: - Sean, I think we should fix at least "

[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-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&focusedCommentId=14729911#comment-14729911 ] Victoria Markman commented on DRILL-3056: - Verified by auditing drillbit.log for t

[jira] [Updated] (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 updated DRILL-3056: Labels: document (was: ) > Numeric literal in an IN list is casted to decimal even when dec

[jira] [Commented] (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:comment-tabpanel&focusedCommentId=14729907#comment-14729907 ] Victoria Markman commented on DRILL-3076: - We wanted to disable it because at fist

[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-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&focusedCommentId=14729885#comment-14729885 ] Victoria Markman commented on DRILL-2643: - The warning is not there as of drill 1.

[jira] [Closed] (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:all-tabpanel ] Victoria Markman closed DRILL-2643. --- > HashAggBatch/HashAggTemplate call incoming.cleanup() twice resulting in > warnings > --

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

[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&focusedCommentId=14729761#comment-14729761 ] Victoria Markman commented on DRILL-2867: - Verified fixed in 1.2.0 #Thu Sep 03 00

[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&focusedCommentId=14729754#comment-14729754 ] Victoria Markman commented on DRILL-3348: - Verified fixed in 1.2.0 #Thu Sep 03 00

[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-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] [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&focusedCommentId=14729735#comment-14729735 ] Victoria Markman commented on DRILL-3657: - Verified fixed in 1.2.0 #Thu Sep 03 00

[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&focusedCommentId=14729722#comment-14729722 ] Victoria Markman commented on DRILL-2802: - Verified fixed in 1.2.0 #Thu Sep 03 00

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

[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&focusedCommentId=14729701#comment-14729701 ] Victoria Markman commented on DRILL-3685: - Verified fixed in 1.2 #Thu Sep 03 00:0

[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] [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&focusedCommentId=14728330#comment-14728330 ] Victoria Markman commented on DRILL-3691: - Hakim, I think DRILL-3673, DRILL-3684

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

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

[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&focusedCommentId=14728169#comment-14728169 ] Victoria Markman commented on DRILL-3673: - I can't reproduce this bug with the lat

[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&focusedCommentId=14727980#comment-14727980 ] Victoria Markman commented on DRILL-3734: - Query without CTAS successfully complet

[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-3141) sqlline throws an exception when query is cancelled

2015-09-01 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3141?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14726451#comment-14726451 ] Victoria Markman commented on DRILL-3141: - Closing, have not seen it in a while ..

[jira] [Closed] (DRILL-3141) sqlline throws an exception when query is cancelled

2015-09-01 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3141?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman closed DRILL-3141. --- > sqlline throws an exception when query is cancelled > --

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

2015-09-01 Thread Victoria Markman (JIRA)
Victoria Markman created DRILL-3734: --- Summary: CTAS with partition by clause causes NPE Key: DRILL-3734 URL: https://issues.apache.org/jira/browse/DRILL-3734 Project: Apache Drill Issue Ty

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

2015-09-01 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3732?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3732: Attachment: drillbit.log > Drill leaks memory if external sort hits out of disk space except

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

2015-09-01 Thread Victoria Markman (JIRA)
Victoria Markman created DRILL-3732: --- Summary: Drill leaks memory if external sort hits out of disk space exception Key: DRILL-3732 URL: https://issues.apache.org/jira/browse/DRILL-3732 Project: Apa

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

2015-08-31 Thread Victoria Markman (JIRA)
Victoria Markman created DRILL-3729: --- Summary: Remove info message about invalid argument during query planning where filter is a directory Key: DRILL-3729 URL: https://issues.apache.org/jira/browse/DRILL-3729

[jira] [Commented] (DRILL-3716) Drill should push filter past aggregate in order to improve query performance.

2015-08-27 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3716?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14717094#comment-14717094 ] Victoria Markman commented on DRILL-3716: - Jinfeng, is it the same as https://issu

[jira] [Updated] (DRILL-3714) Query runs out of memory and remains in CANCELLATION_REQUESTED state until drillbit is restarted

2015-08-26 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3714?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3714: Attachment: Screen Shot 2015-08-26 at 10.36.33 AM.png jstack.txt

[jira] [Created] (DRILL-3714) Query runs out of memory and remains in CANCELLATION_REQUESTED state until drillbit is restarted

2015-08-26 Thread Victoria Markman (JIRA)
Victoria Markman created DRILL-3714: --- Summary: Query runs out of memory and remains in CANCELLATION_REQUESTED state until drillbit is restarted Key: DRILL-3714 URL: https://issues.apache.org/jira/browse/DRILL-37

[jira] [Updated] (DRILL-3705) Query runs out of memory, reported as FAILED and leaves thread running

2015-08-24 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3705?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3705: Attachment: jstack.txt 2a2451ec-09d8-9f26-e856-5fd349ae72fd.sys.drill

[jira] [Created] (DRILL-3705) Query runs out of memory, reported as FAILED and leaves thread running

2015-08-24 Thread Victoria Markman (JIRA)
Victoria Markman created DRILL-3705: --- Summary: Query runs out of memory, reported as FAILED and leaves thread running Key: DRILL-3705 URL: https://issues.apache.org/jira/browse/DRILL-3705 Project:

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

2015-08-24 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: Description: {code} alter session set `planner.slice_target` = 1; select first_value

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

2015-08-24 Thread Victoria Markman (JIRA)
Victoria Markman created DRILL-3700: --- Summary: Exception in a query with multiple fist_value window functions with different partitions Key: DRILL-3700 URL: https://issues.apache.org/jira/browse/DRILL-3700

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

2015-08-24 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: Attachment: j6.tar > Exception in a query with multiple fist_value window functions with dif

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

2015-08-21 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3685?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3685: Attachment: drillbit.log.drill-3685 > Failure to execute query with NTILE and ROW_NUMBER win

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

2015-08-21 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3684?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14707228#comment-14707228 ] Victoria Markman commented on DRILL-3684: - It could be, but exception is different

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

2015-08-21 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3685?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3685: Attachment: j2.tar > Failure to execute query with NTILE and ROW_NUMBER window functions wit

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

2015-08-21 Thread Victoria Markman (JIRA)
Victoria Markman created DRILL-3685: --- Summary: Failure to execute query with NTILE and ROW_NUMBER window functions with different window definitions Key: DRILL-3685 URL: https://issues.apache.org/jira/browse/DRI

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

2015-08-21 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3680?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3680: Fix Version/s: 1.2.0 > window function query returns Incorrect results > --

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

2015-08-21 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3555?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3555: Fix Version/s: 1.2.0 > Changing defaults for planner.memory.max_query_memory_per_node causes

[jira] [Resolved] (DRILL-3677) Wrong result with LEAD window function when used in multiple windows in the same query

2015-08-20 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3677?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman resolved DRILL-3677. - Resolution: Invalid > Wrong result with LEAD window function when used in multiple windows

[jira] [Commented] (DRILL-3677) Wrong result with LEAD window function when used in multiple windows in the same query

2015-08-20 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3677?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14706054#comment-14706054 ] Victoria Markman commented on DRILL-3677: - This is not a bug. My table contains a

[jira] [Closed] (DRILL-3677) Wrong result with LEAD window function when used in multiple windows in the same query

2015-08-20 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3677?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman closed DRILL-3677. --- > Wrong result with LEAD window function when used in multiple windows in the > same query >

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

2015-08-20 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3680?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14705893#comment-14705893 ] Victoria Markman commented on DRILL-3680: - This looks like a planner bug to me (th

[jira] [Updated] (DRILL-3677) Wrong result with LEAD window function when used in multiple windows in the same query

2015-08-20 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3677?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3677: Description: Query produces wrong result: {code} select c_integer, lead(c_in

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

2015-08-20 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3673?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14705594#comment-14705594 ] Victoria Markman commented on DRILL-3673: - Hakim, just to let you know: this same

[jira] [Commented] (DRILL-3677) Wrong result with LEAD window function when used in multiple windows in the same query

2015-08-20 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3677?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14705585#comment-14705585 ] Victoria Markman commented on DRILL-3677: - Same with lag. Please let me know if yo

[jira] [Updated] (DRILL-3677) Wrong result with LEAD window function when used in multiple windows in the same query

2015-08-20 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3677?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3677: Attachment: j1.tar > Wrong result with LEAD window function when used in multiple windows in

[jira] [Updated] (DRILL-3677) Wrong result with LEAD window function when used in multiple windows in the same query

2015-08-20 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3677?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3677: Attachment: q46.out q46.res > Wrong result with LEAD window function when us

[jira] [Created] (DRILL-3677) Wrong result with LEAD window function when used in multiple windows in the same query

2015-08-20 Thread Victoria Markman (JIRA)
Victoria Markman created DRILL-3677: --- Summary: Wrong result with LEAD window function when used in multiple windows in the same query Key: DRILL-3677 URL: https://issues.apache.org/jira/browse/DRILL-3677

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

2015-08-20 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3583?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14705260#comment-14705260 ] Victoria Markman commented on DRILL-3583: - https://issues.apache.org/jira/browse/D

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

2015-08-19 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3673?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3673: Attachment: ctas.sh 1_rows.dat > Memory leak in parquet writer on CTAS >

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

2015-08-19 Thread Victoria Markman (JIRA)
Victoria Markman created DRILL-3673: --- Summary: Memory leak in parquet writer on CTAS Key: DRILL-3673 URL: https://issues.apache.org/jira/browse/DRILL-3673 Project: Apache Drill Issue Type:

[jira] [Commented] (DRILL-3654) FIRST_VALUE(/) returns IOB Exception

2015-08-18 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3654?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14702251#comment-14702251 ] Victoria Markman commented on DRILL-3654: - I see IOB with first_value and partitio

[jira] [Updated] (DRILL-3665) Deadlock while executing CTAS that runs out of memory

2015-08-18 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3665?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3665: Attachment: drillbit.log.drill-3665 > Deadlock while executing CTAS that runs out of memory

[jira] [Updated] (DRILL-3665) Deadlock while executing CTAS that runs out of memory

2015-08-18 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3665?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3665: Attachment: jstack.txt > Deadlock while executing CTAS that runs out of memory > ---

[jira] [Created] (DRILL-3665) Deadlock while executing CTAS that runs out of memory

2015-08-18 Thread Victoria Markman (JIRA)
Victoria Markman created DRILL-3665: --- Summary: Deadlock while executing CTAS that runs out of memory Key: DRILL-3665 URL: https://issues.apache.org/jira/browse/DRILL-3665 Project: Apache Drill

[jira] [Commented] (DRILL-2293) CTAS does not clean up when it fails

2015-08-18 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2293?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14701685#comment-14701685 ] Victoria Markman commented on DRILL-2293: - One more example, CTAS fails with out o

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

2015-08-16 Thread Victoria Markman (JIRA)
Victoria Markman created DRILL-3657: --- Summary: Wrong result with SUM(1) window function when multiple partitions are present Key: DRILL-3657 URL: https://issues.apache.org/jira/browse/DRILL-3657 Pro

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

2015-08-14 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3653?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3653: Description: It seems to be the problem with just this combination and I can't believe I did

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

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

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

2015-08-14 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3653?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3653: Issue Type: Bug (was: Improvement) > Assert in a query with both avg aggregate and avg wind

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

2015-08-14 Thread Victoria Markman (JIRA)
Victoria Markman created DRILL-3653: --- Summary: Assert in a query with both avg aggregate and avg window aggregate functions Key: DRILL-3653 URL: https://issues.apache.org/jira/browse/DRILL-3653 Proj

[jira] [Updated] (DRILL-3652) Need to document order of operations with window functions and flatten

2015-08-14 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3652?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3652: Labels: window_function (was: ) > Need to document order of operations with window function

[jira] [Created] (DRILL-3652) Need to document order of operations with window functions and flatten

2015-08-14 Thread Victoria Markman (JIRA)
Victoria Markman created DRILL-3652: --- Summary: Need to document order of operations with window functions and flatten Key: DRILL-3652 URL: https://issues.apache.org/jira/browse/DRILL-3652 Project: A

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

2015-08-14 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3649?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14697717#comment-14697717 ] Victoria Markman commented on DRILL-3649: - The symptom looks different though ...

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

2015-08-14 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3649?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14697706#comment-14697706 ] Victoria Markman commented on DRILL-3649: - Is this bug the same as https://issues.

[jira] [Created] (DRILL-3651) Window function should not be allowed in order by clause of over clause of window function

2015-08-14 Thread Victoria Markman (JIRA)
Victoria Markman created DRILL-3651: --- Summary: Window function should not be allowed in order by clause of over clause of window function Key: DRILL-3651 URL: https://issues.apache.org/jira/browse/DRILL-3651

[jira] [Updated] (DRILL-3651) Window function should not be allowed in order by clause of over clause of window function

2015-08-14 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3651?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3651: Labels: window_function (was: ) > Window function should not be allowed in order by clause

[jira] [Closed] (DRILL-3574) Empty Over Clause should trigger Union-Exchange to be added below

2015-08-13 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3574?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman closed DRILL-3574. --- > Empty Over Clause should trigger Union-Exchange to be added below >

[jira] [Commented] (DRILL-3574) Empty Over Clause should trigger Union-Exchange to be added below

2015-08-13 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3574?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14695495#comment-14695495 ] Victoria Markman commented on DRILL-3574: - Verified fixed in: 1.2.0 #Wed Aug 12 2

[jira] [Updated] (DRILL-2861) enhance drill profile file management

2015-08-12 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2861?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-2861: Assignee: Sudheesh Katkam (was: Jacques Nadeau) > enhance drill profile file management > -

[jira] [Closed] (DRILL-3567) Wrong result in a query with multiple window functions and different over clauses

2015-08-11 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3567?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman closed DRILL-3567. --- > Wrong result in a query with multiple window functions and different over > clauses > -

[jira] [Commented] (DRILL-3567) Wrong result in a query with multiple window functions and different over clauses

2015-08-11 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3567?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14682068#comment-14682068 ] Victoria Markman commented on DRILL-3567: - Verified fixed in: 1.2.0 #Fri Aug 07 2

[jira] [Updated] (DRILL-3567) Wrong result in a query with multiple window functions and different over clauses

2015-08-11 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3567?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3567: Environment: (was: private-branch-with-multiple-partitions-enabled) > Wrong result in a

[jira] [Updated] (DRILL-3429) DrillAvgVarianceConvertlet may produce wrong results while rewriting stddev, variance

2015-08-10 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3429?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3429: Priority: Critical (was: Major) > DrillAvgVarianceConvertlet may produce wrong results whil

[jira] [Commented] (DRILL-3291) utility that runs the profile ui against a query profile file.

2015-08-07 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3291?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14662515#comment-14662515 ] Victoria Markman commented on DRILL-3291: - Having spent some time debugging some o

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

2015-08-06 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3616?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3616: Issue Type: Sub-task (was: Bug) Parent: DRILL-1942 > Memory leak in a cleanup code

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

2015-08-06 Thread Victoria Markman (JIRA)
Victoria Markman created DRILL-3616: --- Summary: Memory leak in a cleanup code after canceling queries with window functions spilling to disk Key: DRILL-3616 URL: https://issues.apache.org/jira/browse/DRILL-3616

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