[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-tabpanel&focusedCommentId=14589218#comment-14589218 ] Aman Sinha commented on DRILL-3298: --- [~adeneche] were you asking about the final sort or

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

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

[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 DRILL-3216.1Hygiene.6.pa

[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] [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-tabpanel&focusedCommentId=14589186#comment-14589186 ] Levi Page commented on DRILL-3303: -- Updating my copy of pom.xml to 1.7,1.9 fixed the issu

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

[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: Levi

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

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

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

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

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

[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-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 results/error/exce

[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, app

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

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

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

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

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

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

[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-tabpanel&focusedCommentId=14588525#comment-14588525 ] Deneche A. Hakim commented on DRILL-3298: - [~amansinha100] can you take a look at

[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} select

[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-tabpanel&focusedCommentId=14588432#comment-14588432 ] Deneche A. Hakim commented on DRILL-3298: - I did some tests, looks like the result

[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-tabpanel&focusedCommentId=14588412#comment-14588412 ] Steven Phillips commented on DRILL-3301: Escape is supported, e.g.: ilike(a, 'abc

[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: 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 ] Victoria Markman updated DRILL-3298: Attachment: (was: test.res) > Wrong result with SUM window function and order by without

[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-tabpanel&focusedCommentId=14588391#comment-14588391 ] Victoria Markman commented on DRILL-3298: - My apologies, wrong file was attached.

[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-tabpanel&focusedCommentId=14588384#comment-14588384 ] Sean Hsuan-Yi Chu commented on DRILL-3296: -- https://reviews.apache.org/r/35525/

[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-tabpanel&focusedCommentId=14588383#comment-14588383 ] Sean Hsuan-Yi Chu commented on DRILL-3204: -- https://reviews.apache.org/r/35525/

[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-tabpanel&focusedCommentId=14588248#comment-14588248 ] Deneche A. Hakim commented on DRILL-3298: - {{test.res}} doesn't seem to match the

[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-tabpanel&focusedCommentId=14588037#comment-14588037 ] Patrick Toole commented on DRILL-3301: -- See DRILL-2658 for a syntax description in th

[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: Bu