[jira] [Commented] (DRILL-3301) ILIKE does not support escape characters.

[ https://issues.apache.org/jira/browse/DRILL-3301?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14588037#comment-14588037 ] Patrick Toole commented on DRILL-3301: -- See DRILL-2658 for a syntax description in

[jira] [Created] (DRILL-3301) ILIKE does not support escape characters.

Patrick Toole created DRILL-3301: Summary: ILIKE does not support escape characters. Key: DRILL-3301 URL: https://issues.apache.org/jira/browse/DRILL-3301 Project: Apache Drill Issue Type:

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

[ https://issues.apache.org/jira/browse/DRILL-3298?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14588248#comment-14588248 ] Deneche A. Hakim commented on DRILL-3298: - {{test.res}} doesn't seem to match the

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

[ https://issues.apache.org/jira/browse/DRILL-3298?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14588432#comment-14588432 ] Deneche A. Hakim commented on DRILL-3298: - I did some tests, looks like the

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

[ https://issues.apache.org/jira/browse/DRILL-3298?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14588391#comment-14588391 ] Victoria Markman commented on DRILL-3298: - My apologies, wrong file was attached.

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

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

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

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

[jira] [Commented] (DRILL-3301) ILIKE does not support escape characters.

[ https://issues.apache.org/jira/browse/DRILL-3301?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14588412#comment-14588412 ] Steven Phillips commented on DRILL-3301: Escape is supported, e.g.: ilike(a,

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

[ https://issues.apache.org/jira/browse/DRILL-3298?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14588525#comment-14588525 ] Deneche A. Hakim commented on DRILL-3298: - [~amansinha100] can you take a look at

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

[ https://issues.apache.org/jira/browse/DRILL-3298?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Deneche A. Hakim reassigned DRILL-3298: --- Assignee: Deneche A. Hakim (was: Chris Westin) Wrong result with SUM window

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

[ https://issues.apache.org/jira/browse/DRILL-3298?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Deneche A. Hakim updated DRILL-3298: Fix Version/s: 1.1.0 Wrong result with SUM window function and order by without partition

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

[ https://issues.apache.org/jira/browse/DRILL-3204?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14588383#comment-14588383 ] Sean Hsuan-Yi Chu commented on DRILL-3204: -- https://reviews.apache.org/r/35525/

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

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

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

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

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

[ https://issues.apache.org/jira/browse/DRILL-3298?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Deneche A. Hakim updated DRILL-3298: Description: This query returns incorrect result when planner.slice_target = 1 {code}

[jira] [Updated] (DRILL-2604) Make sure implicit casting rules are the same across drill

[ https://issues.apache.org/jira/browse/DRILL-2604?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Daniel Barclay (Drill) updated DRILL-2604: -- Description: This is an enhancement request to standardize rules of implicit

[jira] [Commented] (DRILL-3296) Group By Union Distinct fails at planning

[ https://issues.apache.org/jira/browse/DRILL-3296?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14588384#comment-14588384 ] Sean Hsuan-Yi Chu commented on DRILL-3296: -- https://reviews.apache.org/r/35525/

[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

[ https://issues.apache.org/jira/browse/DRILL-2915?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aman Sinha updated DRILL-2915: -- Fix Version/s: (was: 1.1.0) 1.2.0 Regression: Mondrian query5614.q - Query

[jira] [Updated] (DRILL-2999) Parse-error exception logged to stdout/stderr (visible in SQLLine output)

[ https://issues.apache.org/jira/browse/DRILL-2999?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aman Sinha updated DRILL-2999: -- Fix Version/s: 1.2.0 Parse-error exception logged to stdout/stderr (visible in SQLLine output)

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

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

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

[ https://issues.apache.org/jira/browse/DRILL-3238?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aman Sinha updated DRILL-3238: -- Fix Version/s: Future Cannot Plan Exception is raised when the same window partition is defined in

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

[ https://issues.apache.org/jira/browse/DRILL-3212?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aman Sinha updated DRILL-3212: -- Fix Version/s: Future Passing star as an argument to any drill function results in NPE

[jira] [Updated] (DRILL-745) Drill fails to read the schema of avro tables from hive when the schema is in a separate file

[ https://issues.apache.org/jira/browse/DRILL-745?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Venki Korukanti updated DRILL-745: -- Attachment: DRILL-745-1.patch Doesn't repro anymore. Adding a test. Drill fails to read the

[jira] [Updated] (DRILL-2732) Different logical plan based on field names

[ https://issues.apache.org/jira/browse/DRILL-2732?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aman Sinha updated DRILL-2732: -- Fix Version/s: (was: 1.1.0) 1.2.0 Different logical plan based on field names

[jira] [Updated] (DRILL-3266) Drill's hive storage plugin cannot find RegexSerDe

[ https://issues.apache.org/jira/browse/DRILL-3266?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Venki Korukanti updated DRILL-3266: --- Attachment: DRILL-3266-1.patch Drill's hive storage plugin cannot find RegexSerDe

[jira] [Updated] (DRILL-3292) SUM(constant) OVER(...) returns wrong results

[ https://issues.apache.org/jira/browse/DRILL-3292?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aman Sinha updated DRILL-3292: -- Fix Version/s: 1.1.0 SUM(constant) OVER(...) returns wrong results

[jira] [Updated] (DRILL-2990) Use of limit and offset together results in calcite.tools.ValidationException: java.lang.UnsupportedOperationException

[ https://issues.apache.org/jira/browse/DRILL-2990?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aman Sinha updated DRILL-2990: -- Fix Version/s: Future Use of limit and offset together results in calcite.tools.ValidationException:

[jira] [Updated] (DRILL-3280) Missing OVER clause in window function query results in AssertionError

[ https://issues.apache.org/jira/browse/DRILL-3280?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aman Sinha updated DRILL-3280: -- Fix Version/s: 1.2.0 Missing OVER clause in window function query results in AssertionError

[jira] [Updated] (DRILL-1441) Replace sql function requires backticks to avoid parse error

[ https://issues.apache.org/jira/browse/DRILL-1441?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-1441: -- Fix Version/s: (was: 1.1.0) Future Replace sql function requires backticks to

[jira] [Updated] (DRILL-2929) Join query does not return results/error/exception, appears to be hung

[ https://issues.apache.org/jira/browse/DRILL-2929?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aman Sinha updated DRILL-2929: -- Fix Version/s: (was: 1.1.0) 1.2.0 Join query does not return

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

[ https://issues.apache.org/jira/browse/DRILL-3002?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aman Sinha updated DRILL-3002: -- Fix Version/s: (was: 1.1.0) 1.2.0 Can't plan inequality queries when scalar

[jira] [Updated] (DRILL-3258) Add support for non-scalar subqueries in expressions within HAVING clause

[ https://issues.apache.org/jira/browse/DRILL-3258?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aman Sinha updated DRILL-3258: -- Fix Version/s: 1.2.0 Add support for non-scalar subqueries in expressions within HAVING clause

[jira] [Updated] (DRILL-2335) Error message must be updated to exclude unsupported operators when queries fail to parse

[ https://issues.apache.org/jira/browse/DRILL-2335?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-2335: -- Fix Version/s: (was: 1.1.0) Future Error message must be updated to exclude

[jira] [Updated] (DRILL-2987) Inside an inner query : star should have been expanded (over CSV data)

[ https://issues.apache.org/jira/browse/DRILL-2987?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-2987: -- Fix Version/s: 1.2.0 Inside an inner query : star should have been expanded (over CSV data)

[jira] [Updated] (DRILL-2929) Join query does not return results/error/exception, appears to be hung

[ https://issues.apache.org/jira/browse/DRILL-2929?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aman Sinha updated DRILL-2929: -- Assignee: Sean Hsuan-Yi Chu (was: Jinfeng Ni) Join query does not return results/error/exception,

[jira] [Assigned] (DRILL-3292) SUM(constant) OVER(...) returns wrong results

[ https://issues.apache.org/jira/browse/DRILL-3292?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aman Sinha reassigned DRILL-3292: - Assignee: Aman Sinha (was: Deneche A. Hakim) SUM(constant) OVER(...) returns wrong results

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

[ https://issues.apache.org/jira/browse/DRILL-2903?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sudheesh Katkam updated DRILL-2903: --- Attachment: DRILL-2903.3.patch.txt Update TestDrillbitResilience tests so that they

[jira] [Created] (DRILL-3302) Unable to build drill

Levi Page created DRILL-3302: Summary: Unable to build drill Key: DRILL-3302 URL: https://issues.apache.org/jira/browse/DRILL-3302 Project: Apache Drill Issue Type: Bug Reporter:

[jira] [Closed] (DRILL-3302) Unable to build drill

[ https://issues.apache.org/jira/browse/DRILL-3302?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Levi Page closed DRILL-3302. Resolution: Invalid mistake on my end Unable to build drill - Key:

[jira] [Created] (DRILL-3303) Build doesn't support recent version of Java

Levi Page created DRILL-3303: Summary: Build doesn't support recent version of Java Key: DRILL-3303 URL: https://issues.apache.org/jira/browse/DRILL-3303 Project: Apache Drill Issue Type: Bug

[jira] [Commented] (DRILL-3303) Build doesn't support recent version of Java

[ https://issues.apache.org/jira/browse/DRILL-3303?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14589186#comment-14589186 ] Levi Page commented on DRILL-3303: -- Updating my copy of pom.xml to 1.7,1.9 fixed the

[jira] [Closed] (DRILL-3303) Build doesn't support recent version of Java

[ https://issues.apache.org/jira/browse/DRILL-3303?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chris Westin closed DRILL-3303. --- Resolution: Duplicate Build doesn't support recent version of Java

[jira] [Updated] (DRILL-3262) Rename missed .impl.DrillDatabaseMetaData to .impl.DrillDatabaseMetaDataImpl to

[ https://issues.apache.org/jira/browse/DRILL-3262?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Daniel Barclay (Drill) updated DRILL-3262: -- Attachment: DRILL-3262.5.patch.txt Rename missed .impl.DrillDatabaseMetaData

[jira] [Updated] (DRILL-3216) Fix existing(+) INFORMATION_SCHEMA.COLUMNS columns

[ https://issues.apache.org/jira/browse/DRILL-3216?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Daniel Barclay (Drill) updated DRILL-3216: -- Attachment: DRILL-3216.2Core.6.patch.txt

[jira] [Updated] (DRILL-3198) JDBC driver returns null from DatabaseMetaData.getTypeInfo(...)

[ https://issues.apache.org/jira/browse/DRILL-3198?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Daniel Barclay (Drill) updated DRILL-3198: -- Attachment: DRILL-3198.5.patch.txt JDBC driver returns null from

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

[ https://issues.apache.org/jira/browse/DRILL-3298?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14589218#comment-14589218 ] Aman Sinha commented on DRILL-3298: --- [~adeneche] were you asking about the final sort or

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

[ https://issues.apache.org/jira/browse/DRILL-2101?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mehant Baid updated DRILL-2101: --- Fix Version/s: (was: 1.1.0) Future Decimal literals are treated as double

[jira] [Updated] (DRILL-1706) date_sub function does not accept string as input in Drill

[ https://issues.apache.org/jira/browse/DRILL-1706?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mehant Baid updated DRILL-1706: --- Fix Version/s: (was: 1.1.0) 1.2.0 date_sub function does not accept string as

[jira] [Updated] (DRILL-2549) Implicit Cast between integer and varchar columns in a join should work

[ https://issues.apache.org/jira/browse/DRILL-2549?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mehant Baid updated DRILL-2549: --- Fix Version/s: (was: 1.1.0) Future Implicit Cast between integer and varchar

[jira] [Updated] (DRILL-1650) Add support for repeated_count multi-level array data type?

[ https://issues.apache.org/jira/browse/DRILL-1650?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mehant Baid updated DRILL-1650: --- Fix Version/s: (was: 1.1.0) 1.2.0 Add support for repeated_count multi-level

[jira] [Updated] (DRILL-2538) Project's setupNewSchema() does not create the correct schema for complex vectors with children

[ https://issues.apache.org/jira/browse/DRILL-2538?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mehant Baid updated DRILL-2538: --- Fix Version/s: (was: 1.1.0) 1.2.0 Project's setupNewSchema() does not create

[jira] [Updated] (DRILL-3011) Make Prel.copy abstract and implement for all nodes

[ https://issues.apache.org/jira/browse/DRILL-3011?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mehant Baid updated DRILL-3011: --- Fix Version/s: (was: 1.1.0) 1.2.0 Make Prel.copy abstract and implement for

[jira] [Updated] (DRILL-2125) Add input template file in the source files generated by freemarker

[ https://issues.apache.org/jira/browse/DRILL-2125?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mehant Baid updated DRILL-2125: --- Fix Version/s: (was: 1.1.0) 1.2.0 Add input template file in the source files

[jira] [Updated] (DRILL-2419) UDF that returns string representation of expression type

[ https://issues.apache.org/jira/browse/DRILL-2419?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mehant Baid updated DRILL-2419: --- Fix Version/s: (was: 1.1.0) 1.2.0 UDF that returns string representation of