[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-tabpanelfocusedCommentId=14541004#comment-14541004 ] Victoria Markman commented on DRILL-2508: - Thank you ! My sanity is restored.

[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

[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-tabpanelfocusedCommentId=14541068#comment-14541068 ] Victoria Markman commented on DRILL-1912: - Verified fixed in 1.0.0 0:

[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] [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-tabpanelfocusedCommentId=14540990#comment-14540990 ] Victoria Markman commented on DRILL-2433: - Verified fixed in 1.0.0 #Tue May 12

[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

[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] [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] [Created] (DRILL-3029) Wrong result with correlated not exists subquery

2015-05-11 Thread Victoria Markman (JIRA)
Victoria Markman created DRILL-3029: --- Summary: Wrong result with correlated not exists subquery Key: DRILL-3029 URL: https://issues.apache.org/jira/browse/DRILL-3029 Project: Apache Drill

[jira] [Updated] (DRILL-3028) Exception in correlated subquery with exists when columns in subquery are not qualified

2015-05-11 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3028?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3028: Description: {code} 0: jdbc:drill:schema=dfs select a1 from t1 where exists ( select * from

[jira] [Created] (DRILL-3028) Exception in correlated subquery with exists when columns in subquery are not qualified

2015-05-11 Thread Victoria Markman (JIRA)
Victoria Markman created DRILL-3028: --- Summary: Exception in correlated subquery with exists when columns in subquery are not qualified Key: DRILL-3028 URL: https://issues.apache.org/jira/browse/DRILL-3028

[jira] [Updated] (DRILL-3028) Exception in correlated subquery with exists when columns in subquery are not qualified

2015-05-11 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3028?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3028: Attachment: t2.parquet Exception in correlated subquery with exists when columns in

[jira] [Updated] (DRILL-3028) Exception in correlated subquery with exists when columns in subquery are not qualified

2015-05-11 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3028?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3028: Attachment: t1.parquet Exception in correlated subquery with exists when columns in

[jira] [Created] (DRILL-3018) Queries with scalar aggregate and non equality (non correlated) fail to plan

2015-05-10 Thread Victoria Markman (JIRA)
Victoria Markman created DRILL-3018: --- Summary: Queries with scalar aggregate and non equality (non correlated) fail to plan Key: DRILL-3018 URL: https://issues.apache.org/jira/browse/DRILL-3018

[jira] [Updated] (DRILL-3018) Queries with scalar aggregate and non equality (non correlated) fail to plan

2015-05-10 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3018?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3018: Description: This is a regression. Both queries worked and returned correct result with May

[jira] [Updated] (DRILL-3018) Queries with scalar aggregate and non equality (non correlated) fail to plan

2015-05-10 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3018?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3018: Component/s: Query Planning Optimization Queries with scalar aggregate and non equality

[jira] [Updated] (DRILL-3018) Queries with scalar aggregate and non equality (non correlated) fail to plan

2015-05-10 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3018?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3018: Affects Version/s: 1.0.0 Queries with scalar aggregate and non equality (non correlated)

[jira] [Updated] (DRILL-3018) Queries with scalar aggregate and non equality (non correlated) fail to plan

2015-05-10 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3018?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3018: Attachment: tables.tar Queries with scalar aggregate and non equality (non correlated)

[jira] [Commented] (DRILL-3006) CTAS with interval data type creates invalid parquet file

2015-05-09 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3006?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14536904#comment-14536904 ] Victoria Markman commented on DRILL-3006: - Mehant, I think it is a duplicate of

[jira] [Updated] (DRILL-2974) Make OutOfMemoryException an unchecked exception and remove OutOfMemoryRuntimeException

2015-05-08 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2974?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-2974: Fix Version/s: (was: 1.0.0) 1.1.0 Make OutOfMemoryException an

[jira] [Updated] (DRILL-2915) Regression: Mondrian query5614.q - Query failed: SYSTEM ERROR: This query cannot be planned possibly due to either a cartesian join or an inequality join

2015-05-08 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2915?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-2915: Fix Version/s: (was: 1.0.0) 1.1.0 Regression: Mondrian query5614.q

[jira] [Updated] (DRILL-2903) Update TestDrillbitResilience tests so that they correctly manage canceled queries that get to complete too quickly.

2015-05-08 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2903?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-2903: Fix Version/s: (was: 1.0.0) 1.1.0 Update TestDrillbitResilience

[jira] [Updated] (DRILL-1673) Flatten function can not work well with nested arrays.

2015-05-08 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1673?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-1673: Fix Version/s: (was: 1.0.0) 1.1.0 Flatten function can not work

[jira] [Updated] (DRILL-2677) Query does not go beyond 4096 lines in small JSON files

2015-05-08 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2677?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-2677: Fix Version/s: (was: 1.0.0) 1.1.0 Query does not go beyond 4096

[jira] [Updated] (DRILL-2167) Order by on a repeated index from the output of a flatten on large no of records results in incorrect results

2015-05-08 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2167?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-2167: Fix Version/s: (was: 1.0.0) 1.1.0 Order by on a repeated index from

[jira] [Updated] (DRILL-2441) Throw unsupported error message in case of inequality join

2015-05-08 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2441?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-2441: Labels: no_verified_test (was: ) Throw unsupported error message in case of inequality

[jira] [Commented] (DRILL-2441) Throw unsupported error message in case of inequality join

2015-05-08 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2441?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14535690#comment-14535690 ] Victoria Markman commented on DRILL-2441: - Verified fixed in: 1.0.0 #Thu May 07

[jira] [Closed] (DRILL-1986) Natural join query returns wrong result

2015-05-08 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1986?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman closed DRILL-1986. --- Natural join query returns wrong result ---

[jira] [Commented] (DRILL-1986) Natural join query returns wrong result

2015-05-08 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1986?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14535710#comment-14535710 ] Victoria Markman commented on DRILL-1986: - Verified fixed in 1.0.0 #Thu May 07

[jira] [Updated] (DRILL-1986) Natural join query returns wrong result

2015-05-08 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1986?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-1986: Labels: no_verified_test (was: ) Natural join query returns wrong result

[jira] [Updated] (DRILL-2310) Drill fails to start in embedded mode on windows

2015-05-08 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2310?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-2310: Assignee: Aditya Kishore (was: Steven Phillips) Drill fails to start in embedded mode on

[jira] [Updated] (DRILL-1315) Allow specifying Zookeeper root znode and cluster-id as JDBC parameters

2015-05-08 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1315?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-1315: Fix Version/s: (was: 1.0.0) 1.1.0 Allow specifying Zookeeper root

[jira] [Resolved] (DRILL-2849) Difference in query results over CSV file created by CTAS, compared to results over original CSV file

2015-05-08 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2849?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman resolved DRILL-2849. - Resolution: Fixed Difference in query results over CSV file created by CTAS, compared to

[jira] [Updated] (DRILL-2234) IOOB when streaming aggregate is on the left side of hash join

2015-05-08 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2234?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-2234: Fix Version/s: (was: 1.0.0) 1.1.0 IOOB when streaming aggregate is

[jira] [Updated] (DRILL-2838) Applying flatten after joining 2 sub-queries returns empty maps

2015-05-08 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2838?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-2838: Fix Version/s: (was: 1.0.0) 1.1.0 Applying flatten after joining 2

[jira] [Updated] (DRILL-2100) Drill not deleting spooling files

2015-05-08 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2100?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-2100: Fix Version/s: (was: 1.0.0) 1.1.0 Drill not deleting spooling files

[jira] [Updated] (DRILL-2774) Updated drill-patch-review.py to use git-format-patch

2015-05-08 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2774?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-2774: Fix Version/s: (was: 1.0.0) 1.1.0 Updated drill-patch-review.py to

[jira] [Updated] (DRILL-2516) CTAS fails with NPE when select statement contains join and columns are not specified explicitly

2015-05-08 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2516?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-2516: Fix Version/s: (was: 1.0.0) 1.1.0 CTAS fails with NPE when select

[jira] [Closed] (DRILL-2441) Throw unsupported error message in case of inequality join

2015-05-08 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2441?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman closed DRILL-2441. --- Throw unsupported error message in case of inequality join

[jira] [Created] (DRILL-3002) Can't plan inequality queries when scalar subquery has an expression with at least one distinct aggregate

2015-05-08 Thread Victoria Markman (JIRA)
Victoria Markman created DRILL-3002: --- Summary: Can't plan inequality queries when scalar subquery has an expression with at least one distinct aggregate Key: DRILL-3002 URL:

[jira] [Created] (DRILL-3003) NPE on incorrect query (and instead of where clause)

2015-05-08 Thread Victoria Markman (JIRA)
Victoria Markman created DRILL-3003: --- Summary: NPE on incorrect query (and instead of where clause) Key: DRILL-3003 URL: https://issues.apache.org/jira/browse/DRILL-3003 Project: Apache Drill

[jira] [Commented] (DRILL-3003) NPE on incorrect query (and instead of where clause)

2015-05-08 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3003?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14536044#comment-14536044 ] Victoria Markman commented on DRILL-3003: - As Jason pointed out, this is perfectly

[jira] [Updated] (DRILL-3003) NPE with the query where on clause contains select with scalar aggregate

2015-05-08 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3003?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3003: Summary: NPE with the query where on clause contains select with scalar aggregate (was:

[jira] [Updated] (DRILL-3003) NPE on

2015-05-08 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3003?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3003: Summary: NPE on (was: NPE on incorrect query (and instead of where clause)) NPE on

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

2015-05-07 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2962?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-2962: Description: Filing this bug on Aman's request. It is not the same as DRILL-2949 DRILL-2949

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

2015-05-07 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2988?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-2988: Summary: Correlated exists subquery returns wrong result if join columns in subquery are

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

2015-05-07 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2988?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14533690#comment-14533690 ] Victoria Markman commented on DRILL-2988: - There is one more case that is similar

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

2015-05-07 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2988?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-2988: Labels: document_if_not_fixed (was: ) Correlated exists subquery returns wrong result if

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

2015-05-07 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2988?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14533687#comment-14533687 ] Victoria Markman commented on DRILL-2988: - So in this case, we should have

[jira] [Closed] (DRILL-1957) NULL values in NOT IN sub-queries could lead to incorrect query result.

2015-05-07 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1957?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman closed DRILL-1957. --- NULL values in NOT IN sub-queries could lead to incorrect query result.

[jira] [Commented] (DRILL-1957) NULL values in NOT IN sub-queries could lead to incorrect query result.

2015-05-07 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1957?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14533366#comment-14533366 ] Victoria Markman commented on DRILL-1957: - Verified fixed in: 1.0.0 #Thu May 07

[jira] [Closed] (DRILL-2356) Wrong result when ROUND function is used in expression

2015-05-07 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2356?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman closed DRILL-2356. --- Wrong result when ROUND function is used in expression

[jira] [Commented] (DRILL-2356) Wrong result when ROUND function is used in expression

2015-05-07 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2356?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14533423#comment-14533423 ] Victoria Markman commented on DRILL-2356: - Verified fixed in 1.0.0 #Thu May 07

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

2015-05-07 Thread Victoria Markman (JIRA)
Victoria Markman created DRILL-2988: --- Summary: Correlated exists subquery returns wrong results if join columns in subquery are not fully qualified Key: DRILL-2988 URL:

[jira] [Updated] (DRILL-2967) Incompatible types error reported in a not in query with compatible data types

2015-05-06 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2967?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-2967: Attachment: t2.parquet Incompatible types error reported in a not in query with compatible

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

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

[jira] [Created] (DRILL-2967) Incompatible types error reported in a not in query with compatible data types

2015-05-05 Thread Victoria Markman (JIRA)
Victoria Markman created DRILL-2967: --- Summary: Incompatible types error reported in a not in query with compatible data types Key: DRILL-2967 URL: https://issues.apache.org/jira/browse/DRILL-2967

[jira] [Commented] (DRILL-658) Add support for multiple distinct counts without a grouping key.

2015-05-05 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-658?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14528857#comment-14528857 ] Victoria Markman commented on DRILL-658: Verified fixed in 0.9.0 #Sun May 03

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

2015-05-05 Thread Victoria Markman (JIRA)
Victoria Markman created DRILL-2962: --- Summary: Correlates subquery with scalar aggregate or scalar aggregate with expression throws and error Key: DRILL-2962 URL:

[jira] [Closed] (DRILL-658) Add support for multiple distinct counts without a grouping key.

2015-05-05 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-658?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman closed DRILL-658. -- Add support for multiple distinct counts without a grouping key.

[jira] [Closed] (DRILL-2411) Scalar SUM/AVG over empty result set returns no rows instead of NULL

2015-05-05 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2411?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman closed DRILL-2411. --- Scalar SUM/AVG over empty result set returns no rows instead of NULL

[jira] [Commented] (DRILL-2411) Scalar SUM/AVG over empty result set returns no rows instead of NULL

2015-05-05 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2411?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14528951#comment-14528951 ] Victoria Markman commented on DRILL-2411: - Verified fixed in: 0.9.0 #Sun May 03

[jira] [Closed] (DRILL-2069) Star is not expanded correctly in the query with IN clause containing subquery

2015-05-05 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2069?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman closed DRILL-2069. --- Star is not expanded correctly in the query with IN clause containing subquery

[jira] [Commented] (DRILL-2069) Star is not expanded correctly in the query with IN clause containing subquery

2015-05-05 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2069?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14529332#comment-14529332 ] Victoria Markman commented on DRILL-2069: - Verified fixed in 0.9.0 #Sun May 03

[jira] [Commented] (DRILL-2943) Drill parsing error during deserialization for an Order-By

2015-05-04 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2943?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14526882#comment-14526882 ] Victoria Markman commented on DRILL-2943: - This is the same exception as in bug:

[jira] [Commented] (DRILL-2921) Query with a mix of distinct and not distinct scalar aggregates runs out of memory

2015-05-04 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2921?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14527482#comment-14527482 ] Victoria Markman commented on DRILL-2921: - We've figured it out.

[jira] [Resolved] (DRILL-2921) Query with a mix of distinct and not distinct scalar aggregates runs out of memory

2015-05-04 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2921?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman resolved DRILL-2921. - Resolution: Invalid Query with a mix of distinct and not distinct scalar aggregates runs

[jira] [Closed] (DRILL-2921) Query with a mix of distinct and not distinct scalar aggregates runs out of memory

2015-05-04 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2921?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman closed DRILL-2921. --- Query with a mix of distinct and not distinct scalar aggregates runs out of memory

[jira] [Commented] (DRILL-2865) Drillbit runs out of memory on multiple consecutive CTAS

2015-05-04 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2865?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14527231#comment-14527231 ] Victoria Markman commented on DRILL-2865: - With the same settings as in the

[jira] [Updated] (DRILL-2865) Drillbit runs out of memory on multiple consecutive CTAS

2015-05-04 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2865?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-2865: Attachment: drill-2865-no-compression.log Drillbit runs out of memory on multiple

[jira] [Commented] (DRILL-2865) Drillbit runs out of memory on multiple consecutive CTAS

2015-05-04 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2865?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14527379#comment-14527379 ] Victoria Markman commented on DRILL-2865: - #Sun May 03 18:33:43 EDT 2015

[jira] [Commented] (DRILL-2921) Query with a mix of distinct and not distinct scalar aggregates runs out of memory

2015-04-30 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2921?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14522022#comment-14522022 ] Victoria Markman commented on DRILL-2921: - Jacques, plan is attached. Yes, this is

[jira] [Created] (DRILL-2921) Query with a mix of distinct and not distinct scalar aggregates runs out of memory

2015-04-30 Thread Victoria Markman (JIRA)
Victoria Markman created DRILL-2921: --- Summary: Query with a mix of distinct and not distinct scalar aggregates runs out of memory Key: DRILL-2921 URL: https://issues.apache.org/jira/browse/DRILL-2921

[jira] [Updated] (DRILL-2921) Query with a mix of distinct and not distinct scalar aggregates runs out of memory

2015-04-30 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2921?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-2921: Attachment: drillbit-drill-2921.log Query with a mix of distinct and not distinct scalar

[jira] [Updated] (DRILL-2921) Query with a mix of distinct and not distinct scalar aggregates runs out of memory

2015-04-30 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2921?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-2921: Attachment: plan-drill-2921.txt Query with a mix of distinct and not distinct scalar

[jira] [Updated] (DRILL-2921) Query with a mix of distinct and not distinct scalar aggregates runs out of memory

2015-04-30 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2921?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-2921: Attachment: alltypes Query with a mix of distinct and not distinct scalar aggregates runs

[jira] [Commented] (DRILL-2915) Regression: Mondrian query5614.q - Query failed: SYSTEM ERROR: This query cannot be planned possibly due to either a cartesian join or an inequality join

2015-04-30 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2915?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14522103#comment-14522103 ] Victoria Markman commented on DRILL-2915: - Aman, I have a note in my tests where

[jira] [Commented] (DRILL-2921) Query with a mix of distinct and not distinct scalar aggregates runs out of memory

2015-04-30 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2921?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14522097#comment-14522097 ] Victoria Markman commented on DRILL-2921: - In Operator profiles, Hash aggregate is

[jira] [Created] (DRILL-2925) Strange exception when avg is called with invalid argument type and count(*)

2015-04-30 Thread Victoria Markman (JIRA)
Victoria Markman created DRILL-2925: --- Summary: Strange exception when avg is called with invalid argument type and count(*) Key: DRILL-2925 URL: https://issues.apache.org/jira/browse/DRILL-2925

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

2015-04-30 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2418?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14522528#comment-14522528 ] Victoria Markman commented on DRILL-2418: - [~adeneche] set `planner.slice_target`

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

2015-04-30 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2418?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-2418: Attachment: cast_tbl_1.parquet Memory leak during execution if comparison function is not

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

2015-04-30 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2418?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-2418: Attachment: not_supported_cast.txt Memory leak during execution if comparison function is

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

2015-04-30 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2418?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-2418: Attachment: cast_tbl_2.parquet Memory leak during execution if comparison function is not

[jira] [Created] (DRILL-2912) Exception is not propagated correctly in case when directory contains mix of file types

2015-04-29 Thread Victoria Markman (JIRA)
Victoria Markman created DRILL-2912: --- Summary: Exception is not propagated correctly in case when directory contains mix of file types Key: DRILL-2912 URL: https://issues.apache.org/jira/browse/DRILL-2912

[jira] [Commented] (DRILL-2915) Regression: Mondrian query5614.q - Query failed: SYSTEM ERROR: This query cannot be planned possibly due to either a cartesian join or an inequality join

2015-04-29 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2915?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14520595#comment-14520595 ] Victoria Markman commented on DRILL-2915: - Simple reproduction: {code} 0:

[jira] [Updated] (DRILL-2912) Exception is not propagated correctly in case when directory contains mix of file types

2015-04-29 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2912?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-2912: Component/s: Execution - Flow Exception is not propagated correctly in case when directory

[jira] [Closed] (DRILL-2212) NULLIF function should be documented

2015-04-28 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2212?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman closed DRILL-2212. --- NULLIF function should be documented

[jira] [Commented] (DRILL-2212) NULLIF function should be documented

2015-04-28 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2212?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14518408#comment-14518408 ] Victoria Markman commented on DRILL-2212: - Verified fixed. NULLIF function

[jira] [Commented] (DRILL-2215) COALESCE function needs to be documented

2015-04-28 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2215?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14518410#comment-14518410 ] Victoria Markman commented on DRILL-2215: - Verified fixed. COALESCE function

[jira] [Closed] (DRILL-2215) COALESCE function needs to be documented

2015-04-28 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2215?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman closed DRILL-2215. --- COALESCE function needs to be documented

[jira] [Closed] (DRILL-2131) Selecting boolean column through Web UI throws an error

2015-04-28 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2131?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman closed DRILL-2131. --- Selecting boolean column through Web UI throws an error

[jira] [Commented] (DRILL-2131) Selecting boolean column through Web UI throws an error

2015-04-28 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2131?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14518446#comment-14518446 ] Victoria Markman commented on DRILL-2131: - Verified fixed in 0.9.0 #Mon Apr 27

[jira] [Commented] (DRILL-2016) Remove multiset data type from supported grammar

2015-04-28 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2016?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14518470#comment-14518470 ] Victoria Markman commented on DRILL-2016: - With drill 0.9.0

[jira] [Reopened] (DRILL-2016) Remove multiset data type from supported grammar

2015-04-28 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2016?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman reopened DRILL-2016: - Remove multiset data type from supported grammar

[jira] [Commented] (DRILL-2115) Disable function CARDINALITY in grammar

2015-04-28 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2115?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14518396#comment-14518396 ] Victoria Markman commented on DRILL-2115: - Verified in 0.9.0 #Mon Apr 27 23:19:19

[jira] [Updated] (DRILL-2016) Remove multiset data type from supported grammar

2015-04-28 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2016?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-2016: Labels: error_message_must_fix (was: ) Remove multiset data type from supported grammar

[jira] [Commented] (DRILL-2214) Aggregate function documentation needs to be corrected

2015-04-28 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2214?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14518406#comment-14518406 ] Victoria Markman commented on DRILL-2214: - Verified fixed. Excerpt from docs:

[jira] [Closed] (DRILL-2196) Assert when table.star notation is used in union all query

2015-04-28 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2196?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman closed DRILL-2196. --- Assert when table.star notation is used in union all query

[jira] [Commented] (DRILL-2196) Assert when table.star notation is used in union all query

2015-04-28 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2196?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14518423#comment-14518423 ] Victoria Markman commented on DRILL-2196: - Verified in 0.9.0 #Mon Apr 27 23:19:19

[jira] [Resolved] (DRILL-2196) Assert when table.star notation is used in union all query

2015-04-28 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2196?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman resolved DRILL-2196. - Resolution: Fixed Assert when table.star notation is used in union all query

<    4   5   6   7   8   9   10   11   12   >