[jira] [Closed] (DRILL-2602) Throw an error on schema change during streaming aggregation

2015-05-12 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2602?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman closed DRILL-2602. --- > Throw an error on schema change during streaming aggregation > -

[jira] [Updated] (DRILL-2602) Throw an error on schema change during streaming aggregation

2015-05-12 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2602?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-2602: Labels: no_verified_test (was: ) > Throw an error on schema change during streaming aggrega

[jira] [Closed] (DRILL-2934) Exception when distinct aggregate is compared to numeric literal with decimal point

2015-05-12 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2934?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman closed DRILL-2934. --- > Exception when distinct aggregate is compared to numeric literal with decimal > point > --

[jira] [Commented] (DRILL-2934) Exception when distinct aggregate is compared to numeric literal with decimal point

2015-05-12 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2934?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14540717#comment-14540717 ] Victoria Markman commented on DRILL-2934: - Verified fixed in 1.0.0 #Tue May 12 12

[jira] [Commented] (DRILL-2244) Implicit cast between numeric data type in joins

2015-05-12 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2244?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14540984#comment-14540984 ] Victoria Markman commented on DRILL-2244: - Verified fixed in 1.0.0 #Tue May 12 12

[jira] [Closed] (DRILL-2244) Implicit cast between numeric data type in joins

2015-05-12 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2244?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman closed DRILL-2244. --- > Implicit cast between numeric data type in joins > -

[jira] [Closed] (DRILL-2433) Implicit cast between date and timestamp is missing in joins

2015-05-12 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2433?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman closed DRILL-2433. --- > Implicit cast between date and timestamp is missing in joins > -

[jira] [Commented] (DRILL-2433) Implicit cast between date and timestamp is missing in joins

2015-05-12 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2433?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14540990#comment-14540990 ] Victoria Markman commented on DRILL-2433: - Verified fixed in 1.0.0 #Tue May 12 12

[jira] [Updated] (DRILL-2508) Add new column to sys.options table that exposes whether or not the current system value is the default

2015-05-12 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2508?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-2508: Labels: doc-impacting (was: ) > Add new column to sys.options table that exposes whether or

[jira] [Closed] (DRILL-2508) Add new column to sys.options table that exposes whether or not the current system value is the default

2015-05-12 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2508?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman closed DRILL-2508. --- > Add new column to sys.options table that exposes whether or not the current > system value is t

[jira] [Commented] (DRILL-2508) Add new column to sys.options table that exposes whether or not the current system value is the default

2015-05-12 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2508?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14541006#comment-14541006 ] Victoria Markman commented on DRILL-2508: - Verified fixed in: 1.0.0 #Tue May 12 1

[jira] [Commented] (DRILL-2508) Add new column to sys.options table that exposes whether or not the current system value is the default

2015-05-12 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2508?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14541004#comment-14541004 ] Victoria Markman commented on DRILL-2508: - Thank you ! My sanity is restored. {co

[jira] [Created] (DRILL-3045) Drill is leaking memory during partition pruning if directory tree has lots of files

2015-05-12 Thread Victoria Markman (JIRA)
Victoria Markman created DRILL-3045: --- Summary: Drill is leaking memory during partition pruning if directory tree has lots of files Key: DRILL-3045 URL: https://issues.apache.org/jira/browse/DRILL-3045

[jira] [Updated] (DRILL-3045) Drill is leaking memory during partition pruning if directory tree has lots of files

2015-05-12 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3045?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3045: Description: (was: See MD-234) > Drill is leaking memory during partition pruning if dir

[jira] [Updated] (DRILL-3045) Drill is leaking memory during partition pruning if directory tree has lots of files

2015-05-12 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3045?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3045: Description: The symptom is: we are running simple query of the form "select x from t where

[jira] [Commented] (DRILL-1912) Throw unsupported error message for window functions

2015-05-12 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1912?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14541068#comment-14541068 ] Victoria Markman commented on DRILL-1912: - Verified fixed in 1.0.0 0: jdbc:drill:

[jira] [Closed] (DRILL-1912) Throw unsupported error message for window functions

2015-05-12 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1912?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman closed DRILL-1912. --- > Throw unsupported error message for window functions >

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

2015-05-13 Thread Victoria Markman (JIRA)
Victoria Markman created DRILL-3056: --- Summary: Numeric literal in an IN list is casted to decimal even when decimal type is disabled Key: DRILL-3056 URL: https://issues.apache.org/jira/browse/DRILL-3056

[jira] [Created] (DRILL-3067) Index out of bounds exception when "in list" contains 10,000 integer values

2015-05-13 Thread Victoria Markman (JIRA)
Victoria Markman created DRILL-3067: --- Summary: Index out of bounds exception when "in list" contains 10,000 integer values Key: DRILL-3067 URL: https://issues.apache.org/jira/browse/DRILL-3067 Proje

[jira] [Updated] (DRILL-3067) Index out of bounds exception when "in list" contains large number of integer values

2015-05-13 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3067?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3067: Description: Index out of bounds exception when in list contains 10,000 integer values Fail

[jira] [Updated] (DRILL-3067) Index out of bounds exception when "in list" contains large number of integer values

2015-05-13 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3067?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3067: Summary: Index out of bounds exception when "in list" contains large number of integer value

[jira] [Created] (DRILL-3068) Query fails and creates profile .drill file with size 0

2015-05-13 Thread Victoria Markman (JIRA)
Victoria Markman created DRILL-3068: --- Summary: Query fails and creates profile .drill file with size 0 Key: DRILL-3068 URL: https://issues.apache.org/jira/browse/DRILL-3068 Project: Apache Drill

[jira] [Updated] (DRILL-3067) Index out of bounds exception when "in list" contains large number of integer values

2015-05-13 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3067?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3067: Attachment: in_list_integer.sql > Index out of bounds exception when "in list" contains larg

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

2015-05-13 Thread Victoria Markman (JIRA)
Victoria Markman created DRILL-3076: --- Summary: USING clause should not be supported in drill Key: DRILL-3076 URL: https://issues.apache.org/jira/browse/DRILL-3076 Project: Apache Drill Iss

[jira] [Created] (DRILL-3077) sqlline's return code is 0 even when it force exits due to failed sql command

2015-05-13 Thread Victoria Markman (JIRA)
Victoria Markman created DRILL-3077: --- Summary: sqlline's return code is 0 even when it force exits due to failed sql command Key: DRILL-3077 URL: https://issues.apache.org/jira/browse/DRILL-3077 Pro

[jira] [Updated] (DRILL-3067) Index out of bounds exception when "in list" contains exceeds 20 items and one of the items is a numeric expression

2015-05-14 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3067?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3067: Summary: Index out of bounds exception when "in list" contains exceeds 20 items and one of t

[jira] [Commented] (DRILL-3067) Index out of bounds exception when "in list" contains exceeds 20 items and one of the items is a numeric expression

2015-05-14 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3067?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14544171#comment-14544171 ] Victoria Markman commented on DRILL-3067: - Correction: in list does not have to be

[jira] [Comment Edited] (DRILL-3067) Index out of bounds exception when "in list" contains exceeds 20 items and one of the items is a numeric expression

2015-05-14 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3067?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14544171#comment-14544171 ] Victoria Markman edited comment on DRILL-3067 at 5/14/15 6:39 PM: --

[jira] [Resolved] (DRILL-3077) sqlline's return code is 0 even when it force exits due to failed sql command

2015-05-15 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3077?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman resolved DRILL-3077. - Resolution: Fixed > sqlline's return code is 0 even when it force exits due to failed sql

[jira] [Closed] (DRILL-3077) sqlline's return code is 0 even when it force exits due to failed sql command

2015-05-15 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3077?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman closed DRILL-3077. --- > sqlline's return code is 0 even when it force exits due to failed sql command >

[jira] [Commented] (DRILL-3077) sqlline's return code is 0 even when it force exits due to failed sql command

2015-05-15 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3077?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14545903#comment-14545903 ] Victoria Markman commented on DRILL-3077: - Thank you, Julian.sqlline now returns n

[jira] [Commented] (DRILL-2962) Correlated subquery with scalar aggregate or scalar aggregate with expression throws and error

2015-05-15 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2962?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14546227#comment-14546227 ] Victoria Markman commented on DRILL-2962: - Verified fixed in: 1.0.0 #Fri May 15 0

[jira] [Closed] (DRILL-2962) Correlated subquery with scalar aggregate or scalar aggregate with expression throws and error

2015-05-15 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2962?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman closed DRILL-2962. --- > Correlated subquery with scalar aggregate or scalar aggregate with expression > throws and err

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

2015-05-18 Thread Victoria Markman (JIRA)
Victoria Markman created DRILL-3141: --- Summary: sqlline throws an exception when query is cancelled Key: DRILL-3141 URL: https://issues.apache.org/jira/browse/DRILL-3141 Project: Apache Drill

[jira] [Commented] (DRILL-2866) Incorrect error message reporting schema change when streaming aggregation and hash join are disabled

2015-05-21 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2866?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14555267#comment-14555267 ] Victoria Markman commented on DRILL-2866: - Sean, There was a similar bug that wa

[jira] [Commented] (DRILL-2346) Star is not expanded correctly in create view if view fields are specified

2015-05-22 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2346?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14556513#comment-14556513 ] Victoria Markman commented on DRILL-2346: - Nope, we have bigger fish to fry :) >

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

2015-05-22 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2988?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14533690#comment-14533690 ] Victoria Markman edited comment on DRILL-2988 at 5/22/15 6:00 PM: --

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

2015-05-22 Thread Victoria Markman (JIRA)
Victoria Markman created DRILL-3172: --- Summary: Can not plan exception when over clause is empty Key: DRILL-3172 URL: https://issues.apache.org/jira/browse/DRILL-3172 Project: Apache Drill

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

2015-05-22 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3172?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3172: Description: With all currently supported window functions: {code} 0: jdbc:drill:schema=dfs

[jira] [Created] (DRILL-3181) Change error message to a more clear one when window range is specified for window function

2015-05-26 Thread Victoria Markman (JIRA)
Victoria Markman created DRILL-3181: --- Summary: Change error message to a more clear one when window range is specified for window function Key: DRILL-3181 URL: https://issues.apache.org/jira/browse/DRILL-3181

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

2015-05-26 Thread Victoria Markman (JIRA)
Victoria Markman created DRILL-3182: --- Summary: Window function with DISTINCT qualifier returns seemingly incorrect result Key: DRILL-3182 URL: https://issues.apache.org/jira/browse/DRILL-3182 Projec

[jira] [Created] (DRILL-3188) Disable row range functionality for window functions

2015-05-26 Thread Victoria Markman (JIRA)
Victoria Markman created DRILL-3188: --- Summary: Disable row range functionality for window functions Key: DRILL-3188 URL: https://issues.apache.org/jira/browse/DRILL-3188 Project: Apache Drill

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

2015-05-26 Thread Victoria Markman (JIRA)
Victoria Markman created DRILL-3189: --- Summary: Disable ALLOW PARTIAL/DISALLOW PARTIAL in window function grammar Key: DRILL-3189 URL: https://issues.apache.org/jira/browse/DRILL-3189 Project: Apache

[jira] [Updated] (DRILL-3188) Disable row range functionality for window functions

2015-05-26 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3188?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3188: Description: We don't support row range with window functions. So we should disable this fu

[jira] [Updated] (DRILL-3188) Disable ability to specify window frame

2015-05-26 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3188?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3188: Summary: Disable ability to specify window frame (was: Disable row range functionality for

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

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

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

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

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

2015-05-27 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3172?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14561308#comment-14561308 ] Victoria Markman commented on DRILL-3172: - This bug blocks our testing of empty ov

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

2015-05-27 Thread Victoria Markman (JIRA)
Victoria Markman created DRILL-3195: --- Summary: Throw unsupported exception for Window functions that are not currently supported Key: DRILL-3195 URL: https://issues.apache.org/jira/browse/DRILL-3195

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

2015-05-27 Thread Victoria Markman (JIRA)
Victoria Markman created DRILL-3196: --- Summary: Disable multiple partition by clauses in the same sql query Key: DRILL-3196 URL: https://issues.apache.org/jira/browse/DRILL-3196 Project: Apache Drill

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

2015-05-27 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: Priority: Critical (was: Major) > Disable multiple partition by clauses in the same sql que

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

2015-05-27 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: Assignee: Deneche A. Hakim (was: Daniel Barclay (Drill)) > Window function with DISTINCT qu

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

2015-05-27 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: window_function (was: ) > Disable multiple partition by clauses in the same sql que

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

2015-05-27 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3195?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3195: Labels: window_function (was: ) > Throw unsupported exception for Window functions that are

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

2015-05-27 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3189?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3189: Labels: window_function (was: ) > Disable ALLOW PARTIAL/DISALLOW PARTIAL in window function

[jira] [Updated] (DRILL-3188) Disable ability to specify window frame

2015-05-27 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3188?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3188: Labels: window_function (was: ) > Disable ability to specify window frame > ---

[jira] [Updated] (DRILL-3183) Query that uses window functions returns NPE

2015-05-27 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3183?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3183: Labels: window_function (was: ) > Query that uses window functions returns NPE > --

[jira] [Updated] (DRILL-3183) Query that uses window functions returns NPE

2015-05-27 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3183?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3183: Environment: faec150598840c40827e6493992d81209aa936da (was: faec150598840c40827e6493992d812

[jira] [Updated] (DRILL-3183) Query that uses window functions returns NPE

2015-05-27 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3183?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3183: Environment: faec150598840c40827e6493992d81209aa936da; window_function (was: faec150598840c

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

2015-05-27 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: window_function (was: ) > Window function with DISTINCT qualifier returns seemingly

[jira] [Updated] (DRILL-3197) Query that uses window functions fails

2015-05-27 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3197?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3197: Labels: window_function (was: ) > Query that uses window functions fails >

[jira] [Updated] (DRILL-3181) Change error message to a more clear one when window range is specified for window function

2015-05-27 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3181?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3181: Labels: window_functions (was: ) > Change error message to a more clear one when window ran

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

2015-05-27 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1862?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-1862: Labels: window_function (was: window_functions) > over clause with only order by clause thr

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

2015-05-27 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: Assignee: Sean Hsuan-Yi Chu (was: Jinfeng Ni) > Disable multiple partition by clauses in th

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

2015-05-27 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3195?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3195: Assignee: Sean Hsuan-Yi Chu (was: Deneche A. Hakim) > Throw unsupported exception for Windo

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

2015-05-27 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3189?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3189: Assignee: Sean Hsuan-Yi Chu (was: Jinfeng Ni) > Disable ALLOW PARTIAL/DISALLOW PARTIAL in w

[jira] [Updated] (DRILL-3188) Disable ability to specify window frame

2015-05-27 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3188?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3188: Assignee: Sean Hsuan-Yi Chu (was: Jinfeng Ni) > Disable ability to specify window frame > -

[jira] [Updated] (DRILL-3173) Invalid inputs are NOT handled properly by Window functions

2015-05-27 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3173?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3173: Labels: window_function (was: ) > Invalid inputs are NOT handled properly by Window functio

[jira] [Commented] (DRILL-3197) Query that uses window functions fails

2015-05-27 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3197?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14561808#comment-14561808 ] Victoria Markman commented on DRILL-3197: - Khurram, It looks like you have an emp

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

2015-05-28 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3196?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14563274#comment-14563274 ] Victoria Markman commented on DRILL-3196: - Hakim, If you look at the plan, two wi

[jira] [Created] (DRILL-3204) Problem in name resolution with window functions

2015-05-28 Thread Victoria Markman (JIRA)
Victoria Markman created DRILL-3204: --- Summary: Problem in name resolution with window functions Key: DRILL-3204 URL: https://issues.apache.org/jira/browse/DRILL-3204 Project: Apache Drill I

[jira] [Updated] (DRILL-3204) Problem in name resolution with window functions

2015-05-28 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3204?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3204: Labels: window_fun (was: ) > Problem in name resolution with window functions > ---

[jira] [Updated] (DRILL-3204) Problem in name resolution with window functions

2015-05-28 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3204?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3204: Labels: window_function (was: window_fun) > Problem in name resolution with window function

[jira] [Updated] (DRILL-3206) Memory leak in window functions

2015-05-28 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3206?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3206: Labels: window_function (was: ) > Memory leak in window functions > ---

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

2015-05-28 Thread Victoria Markman (JIRA)
Victoria Markman created DRILL-3210: --- Summary: Star is not expanded correctly in projection list when used with window function Key: DRILL-3210 URL: https://issues.apache.org/jira/browse/DRILL-3210

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

2015-05-28 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3210?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3210: Labels: window_function (was: ) > Star is not expanded correctly in projection list when us

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

2015-05-28 Thread Victoria Markman (JIRA)
Victoria Markman created DRILL-3211: --- Summary: Assert in a query with window function and group by clause Key: DRILL-3211 URL: https://issues.apache.org/jira/browse/DRILL-3211 Project: Apache Drill

[jira] [Created] (DRILL-3212) Passing star as an argument to any drill function results in NPE

2015-05-28 Thread Victoria Markman (JIRA)
Victoria Markman created DRILL-3212: --- Summary: Passing star as an argument to any drill function results in NPE Key: DRILL-3212 URL: https://issues.apache.org/jira/browse/DRILL-3212 Project: Apache

[jira] [Updated] (DRILL-3213) Use of aggregate function in order by clause within an over clause fails

2015-05-28 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3213?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3213: Labels: window_function (was: ) > Use of aggregate function in order by clause within an ov

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

2015-05-29 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3211?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14565138#comment-14565138 ] Victoria Markman commented on DRILL-3211: - One more example, it seems to me that i

[jira] [Updated] (DRILL-3218) Window function usage throws CompileException

2015-05-29 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3218?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3218: Labels: window_function (was: ) > Window function usage throws CompileException > -

[jira] [Created] (DRILL-3219) Filter is not pushed into subquery with window function

2015-05-29 Thread Victoria Markman (JIRA)
Victoria Markman created DRILL-3219: --- Summary: Filter is not pushed into subquery with window function Key: DRILL-3219 URL: https://issues.apache.org/jira/browse/DRILL-3219 Project: Apache Drill

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

2015-05-29 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3196?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14565474#comment-14565474 ] Victoria Markman commented on DRILL-3196: - You are right, I missed the fact that s

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

2015-06-01 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3238?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14568055#comment-14568055 ] Victoria Markman commented on DRILL-3238: - Interestingly, this case "over W" works

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

2015-06-01 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3238?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3238: Labels: window_functions (was: ) > Cannot Plan Exception is raised when the same window par

[jira] [Created] (DRILL-3241) Query with window function runs out of direct memory and does not report back to client that it did

2015-06-01 Thread Victoria Markman (JIRA)
Victoria Markman created DRILL-3241: --- Summary: Query with window function runs out of direct memory and does not report back to client that it did Key: DRILL-3241 URL: https://issues.apache.org/jira/browse/DRILL

[jira] [Updated] (DRILL-3204) Problem in name resolution with window functions

2015-06-02 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3204?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3204: Priority: Blocker (was: Major) > Problem in name resolution with window functions > ---

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

2015-06-02 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3211?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3211: Priority: Blocker (was: Major) > Assert in a query with window function and group by clause

[jira] [Commented] (DRILL-2558) Four different errors are returned when running one COALESCE with multiple arguments of incompatible data types

2015-06-04 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2558?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14573852#comment-14573852 ] Victoria Markman commented on DRILL-2558: - Same in 1.0.0 {code} 0: jdbc:drill:sch

[jira] [Commented] (DRILL-2628) sqlline hangs and then asserts when trying to execute anything on a dead JDBC connection

2015-06-04 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2628?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14573856#comment-14573856 ] Victoria Markman commented on DRILL-2628: - Nope, with 1.0.0 I get: {code} 0: jdbc

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

2015-06-04 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3211?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3211: Priority: Major (was: Blocker) > Assert in a query with window function and group by clause

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

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

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

2015-06-09 Thread Victoria Markman (JIRA)
Victoria Markman created DRILL-3265: --- Summary: Query with window function and sort below that spills to disk runs out of memory Key: DRILL-3265 URL: https://issues.apache.org/jira/browse/DRILL-3265

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

2015-06-09 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3265?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3265: Attachment: drill-3265.log drillbit.log with the additional information. > Query with windo

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

2015-06-09 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3265?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3265: Description: Failure: {code} 0: jdbc:drill:schema=dfs> select . . . . . . . . . . . . > s

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

2015-06-09 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3265?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3265: Description: Failure: {code} 0: jdbc:drill:schema=dfs> select . . . . . . . . . . . . > s

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

2015-06-09 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3265?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3265: Labels: window_function (was: ) > Query with window function and sort below that spills to

[jira] [Commented] (DRILL-3204) Problem in name resolution with window functions

2015-06-11 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3204?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14582621#comment-14582621 ] Victoria Markman commented on DRILL-3204: - It is also very strange that if I add "

[jira] [Comment Edited] (DRILL-3204) Problem in name resolution with window functions

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

[jira] [Commented] (DRILL-3204) Problem in name resolution with window functions

2015-06-11 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3204?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14582681#comment-14582681 ] Victoria Markman commented on DRILL-3204: - I'm not sure I understand, query like t

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