[jira] [Updated] (DRILL-3543) Add stats for external sort to a query profile

2015-11-12 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3543?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3543: Labels: usability (was: ) > Add stats for external sort to a query profile >

[jira] [Updated] (DRILL-4060) CTAS to csv or json files gives incorrect time values

2015-11-10 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4060?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-4060: Priority: Critical (was: Major) > CTAS to csv or json files gives incorrect time values >

[jira] [Updated] (DRILL-3847) Exception during partition pruning

2015-11-10 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3847?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3847: Attachment: drillbit.log This is the new error I got with the latest 1.3.0 #Sat Nov 07

[jira] [Commented] (DRILL-4071) Partition pruning fails when a Coalesce() function appears with partition filter

2015-11-10 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4071?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14999819#comment-14999819 ] Victoria Markman commented on DRILL-4071: - Similar bug:

[jira] [Commented] (DRILL-3937) We are not pruning when we have a metadata cache and auto partitioned data in some cases

2015-11-05 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3937?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14992105#comment-14992105 ] Victoria Markman commented on DRILL-3937: - [~zfong] this will be my next step. > We are not

[jira] [Commented] (DRILL-3937) We are not pruning when we have a metadata cache and auto partitioned data in some cases

2015-11-05 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3937?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14992049#comment-14992049 ] Victoria Markman commented on DRILL-3937: - [~rkins] does this bug look like DRILL-3847 to you ?

[jira] [Commented] (DRILL-3807) [Regression] Query with equality join and a FALSE condition fails to plan

2015-11-05 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3807?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14992191#comment-14992191 ] Victoria Markman commented on DRILL-3807: - *For QA reference* This bug is affecting following

[jira] [Commented] (DRILL-3937) We are not pruning when we have a metadata cache and auto partitioned data in some cases

2015-11-05 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3937?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14992151#comment-14992151 ] Victoria Markman commented on DRILL-3937: - yep, will do that. Thanks ! > We are not pruning when

[jira] [Commented] (DRILL-4041) Parquet library update causing random "Buffer has negative reference count"

2015-11-05 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4041?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14992919#comment-14992919 ] Victoria Markman commented on DRILL-4041: - I've seen it in a different scenario:

[jira] [Commented] (DRILL-4021) Cannot subract or add between two timestamps

2015-11-04 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4021?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14990300#comment-14990300 ] Victoria Markman commented on DRILL-4021: - You are correct ! Now I can proudly say 'yes' to the

[jira] [Updated] (DRILL-4021) Cannot subract or add between two timestamps

2015-11-04 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4021?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-4021: Attachment: photo-2.JPG > Cannot subract or add between two timestamps >

[jira] [Updated] (DRILL-4021) Cannot subract or add between two timestamps

2015-11-04 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4021?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-4021: Attachment: Screen Shot 2015-11-04 at 8.12.34 AM.png > Cannot subract or add between two

[jira] [Created] (DRILL-4012) Limit 0 on top of query with kvg/flatten results in assert

2015-11-03 Thread Victoria Markman (JIRA)
Victoria Markman created DRILL-4012: --- Summary: Limit 0 on top of query with kvg/flatten results in assert Key: DRILL-4012 URL: https://issues.apache.org/jira/browse/DRILL-4012 Project: Apache Drill

[jira] [Updated] (DRILL-4019) Limit 0 with two flatten operators in a query fails with unsupported exception

2015-11-03 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4019?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-4019: Affects Version/s: (was: 1.2.0) > Limit 0 with two flatten operators in a query fails

[jira] [Commented] (DRILL-4019) Limit 0 with two flatten operators in a query fails with unsupported exception

2015-11-03 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4019?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14987818#comment-14987818 ] Victoria Markman commented on DRILL-4019: - It does work with drill 1.3.0 before Steven's check in

[jira] [Created] (DRILL-4019) Limit 0 with two flatten operators in a query fails with unsupported exception

2015-11-03 Thread Victoria Markman (JIRA)
Victoria Markman created DRILL-4019: --- Summary: Limit 0 with two flatten operators in a query fails with unsupported exception Key: DRILL-4019 URL: https://issues.apache.org/jira/browse/DRILL-4019

[jira] [Commented] (DRILL-4012) Limit 0 on top of query with kvg/flatten results in assert

2015-11-03 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4012?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14987854#comment-14987854 ] Victoria Markman commented on DRILL-4012: - This works for me in 1.3.0 as well (pre-union type

[jira] [Updated] (DRILL-4019) Limit 0 with two flatten operators in a query fails with unsupported exception

2015-11-03 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4019?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-4019: Labels: private_branch (was: ) > Limit 0 with two flatten operators in a query fails with

[jira] [Commented] (DRILL-4021) Cannot subract or add between two timestamps

2015-11-03 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4021?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14988604#comment-14988604 ] Victoria Markman commented on DRILL-4021: - Julian, We need to remove addition from the title, it

[jira] [Updated] (DRILL-4021) Cannot subract or add between two timestamps

2015-11-03 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4021?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-4021: Attachment: Screen Shot 2015-11-03 at 3.44.30 PM.png > Cannot subract or add between two

[jira] [Updated] (DRILL-4012) Limit 0 on top of query with kvg/flatten results in assert

2015-11-03 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4012?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-4012: Description: I've found couple of bugs that are very similar, but none of them are quite

[jira] [Created] (DRILL-4009) Assert in a query with concat function in a group by and limit in outer query

2015-11-02 Thread Victoria Markman (JIRA)
Victoria Markman created DRILL-4009: --- Summary: Assert in a query with concat function in a group by and limit in outer query Key: DRILL-4009 URL: https://issues.apache.org/jira/browse/DRILL-4009

[jira] [Commented] (DRILL-4009) Assert in a query with concat function in a group by and limit in outer query

2015-11-02 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4009?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14986206#comment-14986206 ] Victoria Markman commented on DRILL-4009: - drillbit.log {code} 2015-11-02 22:21:00,219

[jira] [Updated] (DRILL-4009) Assert in a query with concat function when wrapped in another subquery

2015-11-02 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4009?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-4009: Summary: Assert in a query with concat function when wrapped in another subquery (was:

[jira] [Commented] (DRILL-4009) Assert in a query with concat function in a group by and limit in outer query

2015-11-02 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4009?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14986221#comment-14986221 ] Victoria Markman commented on DRILL-4009: - No limit is necessary, just wrap it in subquery:

[jira] [Commented] (DRILL-4009) Assert in a query with concat function when wrapped in another subquery

2015-11-02 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4009?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14986234#comment-14986234 ] Victoria Markman commented on DRILL-4009: - And this could be even more generic, I can reproduce

[jira] [Updated] (DRILL-3871) Off by one error while reading binary fields with one terminal null in parquet

2015-11-02 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3871?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3871: Summary: Off by one error while reading binary fields with one terminal null in parquet

[jira] [Created] (DRILL-3996) Project/filter pushdown logic is causing excessive planning time as number of joins in the query increases

2015-10-29 Thread Victoria Markman (JIRA)
Victoria Markman created DRILL-3996: --- Summary: Project/filter pushdown logic is causing excessive planning time as number of joins in the query increases Key: DRILL-3996 URL:

[jira] [Commented] (DRILL-2726) Display Drill version in sys.version

2015-10-29 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2726?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14981506#comment-14981506 ] Victoria Markman commented on DRILL-2726: - {code} 0: jdbc:drill:schema=dfs> select * from

[jira] [Commented] (DRILL-3958) Improve error message when JDBC driver not found

2015-10-23 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3958?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14971443#comment-14971443 ] Victoria Markman commented on DRILL-3958: - Related if not the same:

[jira] [Updated] (DRILL-3958) Improve error message when JDBC driver not found

2015-10-23 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3958?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3958: Priority: Major (was: Minor) > Improve error message when JDBC driver not found >

[jira] [Updated] (DRILL-3543) Add stats for external sort to a query profile

2015-10-22 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3543?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3543: Assignee: Sudheesh Katkam > Add stats for external sort to a query profile >

[jira] [Updated] (DRILL-3961) CONVERT_FROM should return INTEGER when converting from TINYINT/SMALLINT types

2015-10-21 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3961?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3961: Priority: Critical (was: Major) > CONVERT_FROM should return INTEGER when converting from

[jira] [Closed] (DRILL-2687) TINYINT/SMALLINT's clean not-implemented-yet messages are missing or late for views

2015-10-20 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2687?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman closed DRILL-2687. --- > TINYINT/SMALLINT's clean not-implemented-yet messages are missing or late for > views >

[jira] [Resolved] (DRILL-2687) TINYINT/SMALLINT's clean not-implemented-yet messages are missing or late for views

2015-10-20 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2687?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman resolved DRILL-2687. - Resolution: Fixed > TINYINT/SMALLINT's clean not-implemented-yet messages are missing or

[jira] [Commented] (DRILL-2687) TINYINT/SMALLINT's clean not-implemented-yet messages are missing or late for views

2015-10-20 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2687?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14965853#comment-14965853 ] Victoria Markman commented on DRILL-2687: - This bug has been fixed in DRILL-2057 by disabling

[jira] [Created] (DRILL-3961) CONVERT_FROM should return INTEGER when converting from TINYINT/SMALLINT types

2015-10-20 Thread Victoria Markman (JIRA)
Victoria Markman created DRILL-3961: --- Summary: CONVERT_FROM should return INTEGER when converting from TINYINT/SMALLINT types Key: DRILL-3961 URL: https://issues.apache.org/jira/browse/DRILL-3961

[jira] [Updated] (DRILL-3942) IS NOT NULL filter is not pushed pass aggregation

2015-10-15 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3942?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3942: Description: It seems to me that we should be able to do that, x is a grouping column:

[jira] [Created] (DRILL-3942) IS NOT NULL filter is not pushed pass aggregation

2015-10-15 Thread Victoria Markman (JIRA)
Victoria Markman created DRILL-3942: --- Summary: IS NOT NULL filter is not pushed pass aggregation Key: DRILL-3942 URL: https://issues.apache.org/jira/browse/DRILL-3942 Project: Apache Drill

[jira] [Created] (DRILL-3936) We don't handle out of memory condition during build phase of hash join

2015-10-14 Thread Victoria Markman (JIRA)
Victoria Markman created DRILL-3936: --- Summary: We don't handle out of memory condition during build phase of hash join Key: DRILL-3936 URL: https://issues.apache.org/jira/browse/DRILL-3936 Project:

[jira] [Commented] (DRILL-2015) Casting numeric value that does not fit in integer data type produces incorrect result

2015-10-08 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2015?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14949351#comment-14949351 ] Victoria Markman commented on DRILL-2015: - Changed priority to critical, since it is incorrect

[jira] [Updated] (DRILL-2015) Casting numeric value that does not fit in integer data type produces incorrect result

2015-10-08 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2015?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-2015: Affects Version/s: 1.2.0 > Casting numeric value that does not fit in integer data type

[jira] [Updated] (DRILL-2015) Casting numeric value that does not fit in integer data type produces incorrect result

2015-10-08 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2015?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-2015: Priority: Critical (was: Major) > Casting numeric value that does not fit in integer data

[jira] [Updated] (DRILL-2101) Decimal literals are treated as double

2015-10-08 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2101?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-2101: Labels: decimal (was: ) > Decimal literals are treated as double >

[jira] [Commented] (DRILL-2543) Correlated subquery where outer table contains NULL values returns seemingly wrong result

2015-10-08 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2543?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14949526#comment-14949526 ] Victoria Markman commented on DRILL-2543: - [~jni] it does make sense after you spelled it out with

[jira] [Commented] (DRILL-2001) Poor error message when arithmetic expression with MIN/MAX functions on a string type

2015-10-08 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2001?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14949346#comment-14949346 ] Victoria Markman commented on DRILL-2001: - in 1.2.0 we return a better error, however it should be

[jira] [Updated] (DRILL-2355) TRUNC function returns incorrect result when second parameter is specified

2015-10-08 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2355?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-2355: Priority: Critical (was: Minor) > TRUNC function returns incorrect result when second

[jira] [Resolved] (DRILL-2246) select from sys.options fails in a weird way when slice_target=1

2015-10-08 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2246?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman resolved DRILL-2246. - Resolution: Fixed > select from sys.options fails in a weird way when slice_target=1 >

[jira] [Updated] (DRILL-2860) Unable to cast integer column from parquet file to interval day

2015-10-08 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2860?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-2860: Labels: interval (was: ) > Unable to cast integer column from parquet file to interval day

[jira] [Commented] (DRILL-1895) Improve message where implicit cast fails (e.g. with IN clause)

2015-10-08 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1895?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14949304#comment-14949304 ] Victoria Markman commented on DRILL-1895: - Tried with 1.2.0, error is much more descriptive now.

[jira] [Resolved] (DRILL-2051) NPE when querying view with where clause and derived table

2015-10-08 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2051?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman resolved DRILL-2051. - Resolution: Fixed > NPE when querying view with where clause and derived table >

[jira] [Comment Edited] (DRILL-2859) Unexpected exception in the query with an interval data type

2015-10-08 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2859?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14949550#comment-14949550 ] Victoria Markman edited comment on DRILL-2859 at 10/8/15 10:43 PM: --- As

[jira] [Commented] (DRILL-2859) Unexpected exception in the query with an interval data type

2015-10-08 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2859?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14949551#comment-14949551 ] Victoria Markman commented on DRILL-2859: - I marked this bug as critical because this looks like

[jira] [Updated] (DRILL-2859) Unexpected exception in the query with an interval data type

2015-10-08 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2859?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-2859: Priority: Critical (was: Major) > Unexpected exception in the query with an interval data

[jira] [Commented] (DRILL-2859) Unexpected exception in the query with an interval data type

2015-10-08 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2859?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14949550#comment-14949550 ] Victoria Markman commented on DRILL-2859: - {code} 0: jdbc:drill:schema=dfs> select cast(cast(a1 as

[jira] [Commented] (DRILL-2891) Allowing ROUND function on boolean type can cause all sorts of problems

2015-10-08 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2891?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14949561#comment-14949561 ] Victoria Markman commented on DRILL-2891: - Now that I think about it, first case is technically

[jira] [Updated] (DRILL-2139) Star is not expanded correctly in "select distinct" query

2015-10-08 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2139?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-2139: Priority: Critical (was: Major) > Star is not expanded correctly in "select distinct"

[jira] [Resolved] (DRILL-1998) Confusing error message when you pass character data type to SUM aggregate function

2015-10-08 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1998?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman resolved DRILL-1998. - Resolution: Fixed > Confusing error message when you pass character data type to SUM

[jira] [Commented] (DRILL-2759) Improve error message when reading from an empty csv file

2015-10-08 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2759?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14949537#comment-14949537 ] Victoria Markman commented on DRILL-2759: - As of 1.2.0 I think expected result is 0 and not an

[jira] [Updated] (DRILL-2759) Improve error message when reading from an empty csv file

2015-10-08 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2759?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-2759: Priority: Critical (was: Minor) > Improve error message when reading from an empty csv

[jira] [Commented] (DRILL-1998) Confusing error message when you pass character data type to SUM aggregate function

2015-10-08 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1998?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14949337#comment-14949337 ] Victoria Markman commented on DRILL-1998: - This bug is fixed in version 1.1.0, see comments in:

[jira] [Commented] (DRILL-2235) Assert when NOT IN clause contains multiple columns

2015-10-08 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2235?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14949417#comment-14949417 ] Victoria Markman commented on DRILL-2235: - Here is the new runtime error without count(*): {code}

[jira] [Commented] (DRILL-2123) Order of columns in the Web UI is wrong when columns are explicitly specified in projection list

2015-10-08 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2123?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14949406#comment-14949406 ] Victoria Markman commented on DRILL-2123: - [~sudheeshkatkam] I just ran this query and it looks

[jira] [Updated] (DRILL-2543) Correlated subquery where outer table contains NULL values returns seemingly wrong result

2015-10-08 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2543?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-2543: Priority: Critical (was: Major) > Correlated subquery where outer table contains NULL

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

2015-10-08 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: Priority: Critical (was: Major) > Query runs out of memory and remains in

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

2015-10-08 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: Priority: Critical (was: Major) > Query runs out of memory, reported as FAILED and leaves

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

2015-10-08 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3241?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3241: Priority: Critical (was: Major) > Query with window function runs out of direct memory and

[jira] [Commented] (DRILL-1951) Can't cast numeric value with decimal point read from CSV file into integer data type

2015-10-08 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1951?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14949380#comment-14949380 ] Victoria Markman commented on DRILL-1951: - In 1.2.0 it throws a new error: {code} 0:

[jira] [Updated] (DRILL-2759) Wrong result on count(*) from empty csv file

2015-10-08 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2759?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-2759: Summary: Wrong result on count(*) from empty csv file (was: Improve error message when

[jira] [Updated] (DRILL-3913) Possible memory leak during CTAS using 30 TB TPC-H dataset

2015-10-07 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3913?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3913: Priority: Critical (was: Major) > Possible memory leak during CTAS using 30 TB TPC-H

[jira] [Commented] (DRILL-3913) Possible memory leak during CTAS using 30 TB TPC-H dataset

2015-10-07 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3913?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14947825#comment-14947825 ] Victoria Markman commented on DRILL-3913: - [~agirish] 1. Can you please run one single CTAS query

[jira] [Commented] (DRILL-3639) Internal error: Error while applying rule PruneScanRule:Filter_On_Scan_Parquet

2015-10-06 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3639?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14945283#comment-14945283 ] Victoria Markman commented on DRILL-3639: - Ivan, Assertion in your case looks different. I will

[jira] [Reopened] (DRILL-3639) Internal error: Error while applying rule PruneScanRule:Filter_On_Scan_Parquet

2015-10-06 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3639?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman reopened DRILL-3639: - > Internal error: Error while applying rule PruneScanRule:Filter_On_Scan_Parquet >

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

2015-10-06 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3732?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14945442#comment-14945442 ] Victoria Markman commented on DRILL-3732: - Memory leak is gone now, something still not right with

[jira] [Updated] (DRILL-3898) NPE during external sort when there is not enough space for spilling

2015-10-06 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3898?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3898: Affects Version/s: 1.2.0 > NPE during external sort when there is not enough space for

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

2015-10-06 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3732?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman closed DRILL-3732. --- > Drill leaks memory if external sort hits out of disk space exception >

[jira] [Created] (DRILL-3898) NPE during external sort when there is not enough space for spilling

2015-10-06 Thread Victoria Markman (JIRA)
Victoria Markman created DRILL-3898: --- Summary: NPE during external sort when there is not enough space for spilling Key: DRILL-3898 URL: https://issues.apache.org/jira/browse/DRILL-3898 Project:

[jira] [Updated] (DRILL-3898) NPE during external sort when there is not enough space for spilling

2015-10-06 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3898?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3898: Component/s: Execution - Relational Operators > NPE during external sort when there is not

[jira] [Updated] (DRILL-3898) NPE during external sort when there is not enough space for spilling

2015-10-06 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3898?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3898: Attachment: drillbit.log > NPE during external sort when there is not enough space for

[jira] [Created] (DRILL-3895) Can not join on int96 column coming from two different sources: hive and impala

2015-10-05 Thread Victoria Markman (JIRA)
Victoria Markman created DRILL-3895: --- Summary: Can not join on int96 column coming from two different sources: hive and impala Key: DRILL-3895 URL: https://issues.apache.org/jira/browse/DRILL-3895

[jira] [Closed] (DRILL-3895) Can not join on int96 column coming from two different sources: hive and impala

2015-10-05 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3895?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman closed DRILL-3895. --- > Can not join on int96 column coming from two different sources: hive and > impala >

[jira] [Commented] (DRILL-3895) Can not join on int96 column coming from two different sources: hive and impala

2015-10-05 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3895?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14944333#comment-14944333 ] Victoria Markman commented on DRILL-3895: - This is not a bug, but my favorite issue where column

[jira] [Resolved] (DRILL-3895) Can not join on int96 column coming from two different sources: hive and impala

2015-10-05 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3895?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman resolved DRILL-3895. - Resolution: Invalid > Can not join on int96 column coming from two different sources:

[jira] [Updated] (DRILL-3895) Can not join on int96 column coming from two different sources: hive and impala

2015-10-05 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3895?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3895: Labels: (was: documentaion) > Can not join on int96 column coming from two different

[jira] [Reopened] (DRILL-3130) Project can be pushed below union all / union to improve performance

2015-10-05 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3130?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman reopened DRILL-3130: - Sean, I think this fix was rolled back because it was causing regression:

[jira] [Reopened] (DRILL-2746) Filter is not pushed into subquery past UNION ALL

2015-10-05 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2746?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman reopened DRILL-2746: - > Filter is not pushed into subquery past UNION ALL >

[jira] [Commented] (DRILL-2746) Filter is not pushed into subquery past UNION ALL

2015-10-05 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2746?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14944231#comment-14944231 ] Victoria Markman commented on DRILL-2746: - Sean, I think this fix was rolled back because it was

[jira] [Closed] (DRILL-3639) Internal error: Error while applying rule PruneScanRule:Filter_On_Scan_Parquet

2015-10-05 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3639?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman closed DRILL-3639. --- > Internal error: Error while applying rule PruneScanRule:Filter_On_Scan_Parquet >

[jira] [Closed] (DRILL-1457) Limit operator optimization : push limit operator past exchange operator

2015-10-05 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1457?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman closed DRILL-1457. --- > Limit operator optimization : push limit operator past exchange operator >

[jira] [Commented] (DRILL-3639) Internal error: Error while applying rule PruneScanRule:Filter_On_Scan_Parquet

2015-10-05 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3639?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14943566#comment-14943566 ] Victoria Markman commented on DRILL-3639: - This issue is fixed in 1.2.0 #Thu Oct 01 23:19:53 UTC

[jira] [Updated] (DRILL-3639) Internal error: Error while applying rule PruneScanRule:Filter_On_Scan_Parquet

2015-10-05 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3639?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3639: Fix Version/s: 1.2.0 > Internal error: Error while applying rule

[jira] [Commented] (DRILL-1457) Limit operator optimization : push limit operator past exchange operator; disable parallel plan if no order is required.

2015-10-05 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1457?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14943540#comment-14943540 ] Victoria Markman commented on DRILL-1457: - I'm removing "disable parallel plan if no order is

[jira] [Updated] (DRILL-1457) Limit operator optimization : push limit operator past exchange operator

2015-10-05 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1457?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-1457: Summary: Limit operator optimization : push limit operator past exchange operator (was:

[jira] [Commented] (DRILL-3871) Exception on inner join when join predicate is int96 field generated by impala

2015-10-02 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3871?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14941581#comment-14941581 ] Victoria Markman commented on DRILL-3871: - Workaround for this particular situation for both 1.1

[jira] [Assigned] (DRILL-3890) TPCH Concurrency test hit foremanException even when all the drillbits are alive

2015-10-02 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3890?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman reassigned DRILL-3890: --- Assignee: Victoria Markman > TPCH Concurrency test hit foremanException even when

[jira] [Updated] (DRILL-3890) TPCH Concurrency test hit foremanException even when all the drillbits are alive

2015-10-02 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3890?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3890: Assignee: (was: Victoria Markman) > TPCH Concurrency test hit foremanException even

[jira] [Updated] (DRILL-1457) Limit operator optimization : push limit operator past exchange operator; disable parallel plan if no order is required.

2015-10-02 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1457?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-1457: Labels: no_verified_test (was: ) > Limit operator optimization : push limit operator past

[jira] [Commented] (DRILL-1457) Limit operator optimization : push limit operator past exchange operator; disable parallel plan if no order is required.

2015-10-02 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1457?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14941907#comment-14941907 ] Victoria Markman commented on DRILL-1457: - Verified that it works for couple of simple test cases:

[jira] [Commented] (DRILL-3257) TPCDS query 74 results in a StackOverflowError on Scale Factor 1

2015-10-01 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3257?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14940068#comment-14940068 ] Victoria Markman commented on DRILL-3257: - [~agirish] Can you please add this query to sf1 and

[jira] [Updated] (DRILL-3257) TPCDS query 74 results in a StackOverflowError on Scale Factor 1

2015-10-01 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3257?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3257: Assignee: Abhishek Girish (was: Sean Hsuan-Yi Chu) > TPCDS query 74 results in a

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