[jira] [Created] (DRILL-4656) The inferred nullability of "is null" can at times be incorrect

Sean Hsuan-Yi Chu created DRILL-4656: Summary: The inferred nullability of "is null" can at times be incorrect Key: DRILL-4656 URL: https://issues.apache.org/jira/browse/DRILL-4656 Project: Apache

[jira] [Resolved] (DRILL-4577) Improve performance for query on INFORMATION_SCHEMA when HIVE is plugged in

[ https://issues.apache.org/jira/browse/DRILL-4577?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sean Hsuan-Yi Chu resolved DRILL-4577. -- Resolution: Fixed Resolved in commit-id: b8f6ebc651445ccecd3e393250f6cd2781fc07e3 > Imp

[jira] [Resolved] (DRILL-4573) Zero copy LIKE, REGEXP_MATCHES, SUBSTR

[ https://issues.apache.org/jira/browse/DRILL-4573?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sean Hsuan-Yi Chu resolved DRILL-4573. -- Resolution: Fixed Fix Version/s: 1.7.0 Resolved in 8176fbca6435ea2417a77b99e954ae

[jira] [Resolved] (DRILL-4529) SUM() with windows function result in mismatch nullability

[ https://issues.apache.org/jira/browse/DRILL-4529?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sean Hsuan-Yi Chu resolved DRILL-4529. -- Resolution: Fixed Fix Version/s: 1.7.0 Resolved in commit: 5705d45095bd89fb9d1e7b

[jira] [Created] (DRILL-4642) Let RexBuilder.ensureType() mechanism take place during Rex conversion.

Sean Hsuan-Yi Chu created DRILL-4642: Summary: Let RexBuilder.ensureType() mechanism take place during Rex conversion. Key: DRILL-4642 URL: https://issues.apache.org/jira/browse/DRILL-4642 Project

[jira] [Created] (DRILL-4577) Improve performance for query on INFORMATION_SCHEMA when HIVE is plugged in

Sean Hsuan-Yi Chu created DRILL-4577: Summary: Improve performance for query on INFORMATION_SCHEMA when HIVE is plugged in Key: DRILL-4577 URL: https://issues.apache.org/jira/browse/DRILL-4577 Pro

[jira] [Resolved] (DRILL-4472) Pushing Filter past Union All fails: DRILL-3257 regressed DRILL-2746 but unit test update break test goal

[ https://issues.apache.org/jira/browse/DRILL-4472?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sean Hsuan-Yi Chu resolved DRILL-4472. -- Resolution: Fixed Fix Version/s: 1.7.0 It was resolved when DRILL-4476 > Pushing

[jira] [Created] (DRILL-4552) Treat decimal literals as Double when type inference is taking place

Sean Hsuan-Yi Chu created DRILL-4552: Summary: Treat decimal literals as Double when type inference is taking place Key: DRILL-4552 URL: https://issues.apache.org/jira/browse/DRILL-4552 Project: A

[jira] [Resolved] (DRILL-4476) Enhance Union-All operator for dealing with empty left input or empty both inputs

[ https://issues.apache.org/jira/browse/DRILL-4476?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sean Hsuan-Yi Chu resolved DRILL-4476. -- Resolution: Fixed Fixed in commit#: b979bebe83d7017880b0763adcbf8eb80acfcee8 > Enhance

[jira] [Created] (DRILL-4488) Prefix "-" cause failure (NPE) in constant folding

Sean Hsuan-Yi Chu created DRILL-4488: Summary: Prefix "-" cause failure (NPE) in constant folding Key: DRILL-4488 URL: https://issues.apache.org/jira/browse/DRILL-4488 Project: Apache Drill

[jira] [Created] (DRILL-4477) Wrong Plan (potentially wrong result) if wrapping a query with SELECT * FROM

Sean Hsuan-Yi Chu created DRILL-4477: Summary: Wrong Plan (potentially wrong result) if wrapping a query with SELECT * FROM Key: DRILL-4477 URL: https://issues.apache.org/jira/browse/DRILL-4477 Pr

[jira] [Created] (DRILL-4476) Enhance Union-All operator for dealing with empty left input or empty both inputs

Sean Hsuan-Yi Chu created DRILL-4476: Summary: Enhance Union-All operator for dealing with empty left input or empty both inputs Key: DRILL-4476 URL: https://issues.apache.org/jira/browse/DRILL-4476

[jira] [Created] (DRILL-4372) Let Operators and Functions expose the types

Sean Hsuan-Yi Chu created DRILL-4372: Summary: Let Operators and Functions expose the types Key: DRILL-4372 URL: https://issues.apache.org/jira/browse/DRILL-4372 Project: Apache Drill Is

[jira] [Resolved] (DRILL-4144) AssertionError : Internal error: Error while applying rule HivePushPartitionFilterIntoScan:Filter_On_Project_Hive

[ https://issues.apache.org/jira/browse/DRILL-4144?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sean Hsuan-Yi Chu resolved DRILL-4144. -- Resolution: Cannot Reproduce > AssertionError : Internal error: Error while applying rul

[jira] [Resolved] (DRILL-4150) AssertionError: no provider found (rel=rel#16:Subset#0.ENUMERABLE.ANY([]).[], m=interface org.apache.calcite.rel.metadata.BuiltInMetadata$Collation); a backstop provider

[ https://issues.apache.org/jira/browse/DRILL-4150?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sean Hsuan-Yi Chu resolved DRILL-4150. -- Resolution: Cannot Reproduce > AssertionError: no provider found (rel=rel#16:Subset#0.EN

[jira] [Resolved] (DRILL-4148) NullPointerException in planning when running window function query

[ https://issues.apache.org/jira/browse/DRILL-4148?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sean Hsuan-Yi Chu resolved DRILL-4148. -- Resolution: Cannot Reproduce > NullPointerException in planning when running window func

[jira] [Created] (DRILL-4314) Unit Test Framework Enhancement: Schema check for zero-row query

Sean Hsuan-Yi Chu created DRILL-4314: Summary: Unit Test Framework Enhancement: Schema check for zero-row query Key: DRILL-4314 URL: https://issues.apache.org/jira/browse/DRILL-4314 Project: Apach

[jira] [Created] (DRILL-4309) Make this option store.hive.optimize_scan_with_native_readers=true default

Sean Hsuan-Yi Chu created DRILL-4309: Summary: Make this option store.hive.optimize_scan_with_native_readers=true default Key: DRILL-4309 URL: https://issues.apache.org/jira/browse/DRILL-4309 Proj

[jira] [Resolved] (DRILL-3214) Config option to cast empty string to null does not cast empty string to null

[ https://issues.apache.org/jira/browse/DRILL-3214?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sean Hsuan-Yi Chu resolved DRILL-3214. -- Resolution: Not A Problem > Config option to cast empty string to null does not cast emp

[jira] [Resolved] (DRILL-3214) Config option to cast empty string to null does not cast empty string to null

[ https://issues.apache.org/jira/browse/DRILL-3214?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sean Hsuan-Yi Chu resolved DRILL-3214. -- Resolution: Fixed > Config option to cast empty string to null does not cast empty strin

[jira] [Created] (DRILL-4180) IllegalArgumentException while reading JSON files

Sean Hsuan-Yi Chu created DRILL-4180: Summary: IllegalArgumentException while reading JSON files Key: DRILL-4180 URL: https://issues.apache.org/jira/browse/DRILL-4180 Project: Apache Drill

[jira] [Created] (DRILL-4083) Drill not using HiveDrillNativeParquetScan if no column is needed to be read from HIVE

Sean Hsuan-Yi Chu created DRILL-4083: Summary: Drill not using HiveDrillNativeParquetScan if no column is needed to be read from HIVE Key: DRILL-4083 URL: https://issues.apache.org/jira/browse/DRILL-4083

[jira] [Created] (DRILL-4007) json reader treats empty list inconsistently,

Sean Hsuan-Yi Chu created DRILL-4007: Summary: json reader treats empty list inconsistently, Key: DRILL-4007 URL: https://issues.apache.org/jira/browse/DRILL-4007 Project: Apache Drill Is

[jira] [Created] (DRILL-4006) As json reader reads a field with empty lists, IOOB could happen

Sean Hsuan-Yi Chu created DRILL-4006: Summary: As json reader reads a field with empty lists, IOOB could happen Key: DRILL-4006 URL: https://issues.apache.org/jira/browse/DRILL-4006 Project: Apach

[jira] [Created] (DRILL-3971) to_date(timestamp) is supported

Sean Hsuan-Yi Chu created DRILL-3971: Summary: to_date(timestamp) is supported Key: DRILL-3971 URL: https://issues.apache.org/jira/browse/DRILL-3971 Project: Apache Drill Issue Type: Tas

[jira] [Resolved] (DRILL-3336) to_date(to_timestamp) with group-by in hbase/maprdb table fails with "java.lang.UnsupportedOperationException"

[ https://issues.apache.org/jira/browse/DRILL-3336?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sean Hsuan-Yi Chu resolved DRILL-3336. -- Resolution: Fixed This should be resolved by the patch of DRILL-3769 too. > to_date(to_

[jira] [Created] (DRILL-3950) CAST(...) * (Interval Constant) gives Internal Exception

Sean Hsuan-Yi Chu created DRILL-3950: Summary: CAST(...) * (Interval Constant) gives Internal Exception Key: DRILL-3950 URL: https://issues.apache.org/jira/browse/DRILL-3950 Project: Apache Drill

[jira] [Created] (DRILL-3943) CannotPlanException caused by ExpressionReduction rule

Sean Hsuan-Yi Chu created DRILL-3943: Summary: CannotPlanException caused by ExpressionReduction rule Key: DRILL-3943 URL: https://issues.apache.org/jira/browse/DRILL-3943 Project: Apache Drill

[jira] [Created] (DRILL-3855) Enable FilterSetOpTransposeRule, DrillProjectSetOpTransposeRule

Sean Hsuan-Yi Chu created DRILL-3855: Summary: Enable FilterSetOpTransposeRule, DrillProjectSetOpTransposeRule Key: DRILL-3855 URL: https://issues.apache.org/jira/browse/DRILL-3855 Project: Apache

[jira] [Resolved] (DRILL-3795) TextReader can't read .tsv file contains multiple double quotes

[ https://issues.apache.org/jira/browse/DRILL-3795?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sean Hsuan-Yi Chu resolved DRILL-3795. -- Resolution: Not A Problem The input is not valid. Let's take the second field in the fir

[jira] [Resolved] (DRILL-3808) Let TextReader have the option to treat double quote as a literal

[ https://issues.apache.org/jira/browse/DRILL-3808?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sean Hsuan-Yi Chu resolved DRILL-3808. -- Resolution: Won't Fix > Let TextReader have the option to treat double quote as a litera

[jira] [Created] (DRILL-3808) When reading TSV files, TextReader does not follow the standard

Sean Hsuan-Yi Chu created DRILL-3808: Summary: When reading TSV files, TextReader does not follow the standard Key: DRILL-3808 URL: https://issues.apache.org/jira/browse/DRILL-3808 Project: Apache

[jira] [Resolved] (DRILL-2332) Drill should be consistent with Implicit casting rules across data formats

[ https://issues.apache.org/jira/browse/DRILL-2332?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sean Hsuan-Yi Chu resolved DRILL-2332. -- Resolution: Fixed > Drill should be consistent with Implicit casting rules across data f

[jira] [Resolved] (DRILL-3783) Incorrect results : COUNT() over results returned by UNION ALL

[ https://issues.apache.org/jira/browse/DRILL-3783?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sean Hsuan-Yi Chu resolved DRILL-3783. -- Resolution: Invalid This is fine. Set-Operator (e.g., Union, Intersect) has the least pr

[jira] [Resolved] (DRILL-3393) Quotes not being recognized in tab delimited (tsv) files

[ https://issues.apache.org/jira/browse/DRILL-3393?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sean Hsuan-Yi Chu resolved DRILL-3393. -- Resolution: Fixed Resolved in commit#: 48bc0b9a8916af7191b0a99351c27fd5b69786c3 > Quote

[jira] [Resolved] (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 ] Sean Hsuan-Yi Chu resolved DRILL-3238. -- Resolution: Fixed > Cannot Plan Exception is raised when the same window partition is de

[jira] [Created] (DRILL-3776) count(*) from empty text file does not return 0

Sean Hsuan-Yi Chu created DRILL-3776: Summary: count(*) from empty text file does not return 0 Key: DRILL-3776 URL: https://issues.apache.org/jira/browse/DRILL-3776 Project: Apache Drill

[jira] [Created] (DRILL-3755) UserException: throw Validation type of UserException if ValidationException is thrown from Calcite

Sean Hsuan-Yi Chu created DRILL-3755: Summary: UserException: throw Validation type of UserException if ValidationException is thrown from Calcite Key: DRILL-3755 URL: https://issues.apache.org/jira/browse/DRI

[jira] [Resolved] (DRILL-3737) CTAS from empty text file fails with NPE

[ https://issues.apache.org/jira/browse/DRILL-3737?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sean Hsuan-Yi Chu resolved DRILL-3737. -- Resolution: Duplicate > CTAS from empty text file fails with NPE > -

[jira] [Resolved] (DRILL-2313) Query fails when one of the operands is a DATE literal without an explicit cast

[ https://issues.apache.org/jira/browse/DRILL-2313?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sean Hsuan-Yi Chu resolved DRILL-2313. -- Resolution: Fixed Resolved in commit#: 793884d671ec60c927e8d67e676e5f63f5875d75 > Query

[jira] [Resolved] (DRILL-2190) Failure to order by function if DISTINCT clause is present

[ https://issues.apache.org/jira/browse/DRILL-2190?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sean Hsuan-Yi Chu resolved DRILL-2190. -- Resolution: Fixed > Failure to order by function if DISTINCT clause is present > ---

[jira] [Created] (DRILL-3737) CTAS from empty text file fails with NPE

Sean Hsuan-Yi Chu created DRILL-3737: Summary: CTAS from empty text file fails with NPE Key: DRILL-3737 URL: https://issues.apache.org/jira/browse/DRILL-3737 Project: Apache Drill Issue T

[jira] [Resolved] (DRILL-3348) NPE when two different window functions are used in projection list and order by clauses

[ https://issues.apache.org/jira/browse/DRILL-3348?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sean Hsuan-Yi Chu resolved DRILL-3348. -- Resolution: Fixed > NPE when two different window functions are used in projection list

[jira] [Created] (DRILL-3719) Adding negative sign in front of EXTRACT triggers Assertion Error

Sean Hsuan-Yi Chu created DRILL-3719: Summary: Adding negative sign in front of EXTRACT triggers Assertion Error Key: DRILL-3719 URL: https://issues.apache.org/jira/browse/DRILL-3719 Project: Apac

[jira] [Created] (DRILL-3718) quotes in .tsv trigger exception

Sean Hsuan-Yi Chu created DRILL-3718: Summary: quotes in .tsv trigger exception Key: DRILL-3718 URL: https://issues.apache.org/jira/browse/DRILL-3718 Project: Apache Drill Issue Type: Bu

[jira] [Resolved] (DRILL-3663) Drill View aliases being lost via ‘order by’

[ https://issues.apache.org/jira/browse/DRILL-3663?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sean Hsuan-Yi Chu resolved DRILL-3663. -- Resolution: Cannot Reproduce This is not reproducible. If you could offer the details (

[jira] [Created] (DRILL-3683) [Unit Test] Add expected plan for tests in TestWindowFunctions suite

Sean Hsuan-Yi Chu created DRILL-3683: Summary: [Unit Test] Add expected plan for tests in TestWindowFunctions suite Key: DRILL-3683 URL: https://issues.apache.org/jira/browse/DRILL-3683 Project: A

[jira] [Resolved] (DRILL-3509) Empty JSON files trigger exception when used in a union

[ https://issues.apache.org/jira/browse/DRILL-3509?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sean Hsuan-Yi Chu resolved DRILL-3509. -- Resolution: Cannot Reproduce > Empty JSON files trigger exception when used in a union >

[jira] [Created] (DRILL-3537) Empty Json file can potentially result into wrong results

Sean Hsuan-Yi Chu created DRILL-3537: Summary: Empty Json file can potentially result into wrong results Key: DRILL-3537 URL: https://issues.apache.org/jira/browse/DRILL-3537 Project: Apache Drill

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

[ https://issues.apache.org/jira/browse/DRILL-2967?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sean Hsuan-Yi Chu resolved DRILL-2967. -- Resolution: Cannot Reproduce > Incompatible types error reported in a "not in" query wit

[jira] [Resolved] (DRILL-3348) NPE when two different window functions are used in projection list and order by clauses

[ https://issues.apache.org/jira/browse/DRILL-3348?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sean Hsuan-Yi Chu resolved DRILL-3348. -- Resolution: Cannot Reproduce I cannot reproduce this issue. And in your log, the calcite

[jira] [Created] (DRILL-3499) Using (Column[]) results in parsing error

Sean Hsuan-Yi Chu created DRILL-3499: Summary: Using (Column[]) results in parsing error Key: DRILL-3499 URL: https://issues.apache.org/jira/browse/DRILL-3499 Project: Apache Drill Issue

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

[ https://issues.apache.org/jira/browse/DRILL-3076?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sean Hsuan-Yi Chu resolved DRILL-3076. -- Resolution: Won't Fix > USING clause should not be supported in drill > ---

[jira] [Resolved] (DRILL-2332) Drill should be consistent with Implicit casting rules across data formats

[ https://issues.apache.org/jira/browse/DRILL-2332?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sean Hsuan-Yi Chu resolved DRILL-2332. -- Resolution: Invalid > Drill should be consistent with Implicit casting rules across data

[jira] [Resolved] (DRILL-2830) Self-Join via view gives wrong results

[ https://issues.apache.org/jira/browse/DRILL-2830?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sean Hsuan-Yi Chu resolved DRILL-2830. -- Resolution: Duplicate > Self-Join via view gives wrong results > ---

[jira] [Resolved] (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 ] Sean Hsuan-Yi Chu resolved DRILL-3258. -- Resolution: Fixed > Add support for non-scalar subqueries in expressions within HAVING c

[jira] [Resolved] (DRILL-2874) Concat operator is not supported with complex types, we should throw an error early

[ https://issues.apache.org/jira/browse/DRILL-2874?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sean Hsuan-Yi Chu resolved DRILL-2874. -- Resolution: Won't Fix It is not possible to make that judgement at planning time. Drill

[jira] [Resolved] (DRILL-2724) Implicit cast test fails in Union All query (reports type mismatch)

[ https://issues.apache.org/jira/browse/DRILL-2724?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sean Hsuan-Yi Chu resolved DRILL-2724. -- Resolution: Won't Fix > Implicit cast test fails in Union All query (reports type mismat

[jira] [Resolved] (DRILL-2095) Order by on a repeated index inside a sub query results in an NPE

[ https://issues.apache.org/jira/browse/DRILL-2095?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sean Hsuan-Yi Chu resolved DRILL-2095. -- Resolution: Fixed > Order by on a repeated index inside a sub query results in an NPE >

[jira] [Resolved] (DRILL-1395) UNION ALL query fails "while setting up Foreman"

[ https://issues.apache.org/jira/browse/DRILL-1395?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sean Hsuan-Yi Chu resolved DRILL-1395. -- Resolution: Fixed > UNION ALL query fails "while setting up Foreman" > -

[jira] [Resolved] (DRILL-1784) Ignore boolean type enforcement on filter conditions during validation

[ https://issues.apache.org/jira/browse/DRILL-1784?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sean Hsuan-Yi Chu resolved DRILL-1784. -- Resolution: Duplicate > Ignore boolean type enforcement on filter conditions during vali

[jira] [Resolved] (DRILL-3346) Windowing query over View should display a better error message

[ https://issues.apache.org/jira/browse/DRILL-3346?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sean Hsuan-Yi Chu resolved DRILL-3346. -- Resolution: Fixed Fix Version/s: (was: 1.2.0) 1.1.0 > Wind

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

[ https://issues.apache.org/jira/browse/DRILL-3211?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sean Hsuan-Yi Chu resolved DRILL-3211. -- Resolution: Duplicate > Assert in a query with window function and group by clause > --

[jira] [Resolved] (DRILL-3411) CTAS Partition by column in deeper layer fails

[ https://issues.apache.org/jira/browse/DRILL-3411?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sean Hsuan-Yi Chu resolved DRILL-3411. -- Resolution: Invalid If giving alias in select list, it works! create table t1 (c1, c2)

[jira] [Created] (DRILL-3411) CTAS Partition by column in deeper layer fails

Sean Hsuan-Yi Chu created DRILL-3411: Summary: CTAS Partition by column in deeper layer fails Key: DRILL-3411 URL: https://issues.apache.org/jira/browse/DRILL-3411 Project: Apache Drill I

[jira] [Created] (DRILL-3408) CTAS partition by columns[i] from cdv fails

Sean Hsuan-Yi Chu created DRILL-3408: Summary: CTAS partition by columns[i] from cdv fails Key: DRILL-3408 URL: https://issues.apache.org/jira/browse/DRILL-3408 Project: Apache Drill Issu

[jira] [Created] (DRILL-3400) After shifting CTAS's data, query on CTAS table failed

Sean Hsuan-Yi Chu created DRILL-3400: Summary: After shifting CTAS's data, query on CTAS table failed Key: DRILL-3400 URL: https://issues.apache.org/jira/browse/DRILL-3400 Project: Apache Drill

[jira] [Resolved] (DRILL-3359) Drill should throw and error when window function defined using WINDOW AS uses ROWS UNBOUNDED PRECEDING

[ https://issues.apache.org/jira/browse/DRILL-3359?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sean Hsuan-Yi Chu resolved DRILL-3359. -- Resolution: Fixed > Drill should throw and error when window function defined using WIND

[jira] [Resolved] (DRILL-3214) Config option to cast empty string to null does not cast empty string to null

[ https://issues.apache.org/jira/browse/DRILL-3214?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sean Hsuan-Yi Chu resolved DRILL-3214. -- Resolution: Invalid As DRILL-3363 suggests, users should have been informed the setting

[jira] [Created] (DRILL-3363) Give user exception when users are trying to set system-wide-variable with "alter session set"

Sean Hsuan-Yi Chu created DRILL-3363: Summary: Give user exception when users are trying to set system-wide-variable with "alter session set" Key: DRILL-3363 URL: https://issues.apache.org/jira/browse/DRILL-33

[jira] [Resolved] (DRILL-3326) Query with unsupported windows function containing "AS" blocks correct error message

[ https://issues.apache.org/jira/browse/DRILL-3326?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sean Hsuan-Yi Chu resolved DRILL-3326. -- Resolution: Fixed > Query with unsupported windows function containing "AS" blocks corre

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

Sean Hsuan-Yi Chu created DRILL-3296: Summary: Group By Union Distinct fails at planning Key: DRILL-3296 URL: https://issues.apache.org/jira/browse/DRILL-3296 Project: Apache Drill Issue

[jira] [Created] (DRILL-3295) UNION (distinct type) is supported now

Sean Hsuan-Yi Chu created DRILL-3295: Summary: UNION (distinct type) is supported now Key: DRILL-3295 URL: https://issues.apache.org/jira/browse/DRILL-3295 Project: Apache Drill Issue Typ

[jira] [Resolved] (DRILL-3174) Calcite blocks queries whose type-missmatch can be resolved by Drill's Implicit casting

[ https://issues.apache.org/jira/browse/DRILL-3174?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sean Hsuan-Yi Chu resolved DRILL-3174. -- Resolution: Duplicate > Calcite blocks queries whose type-missmatch can be resolved by D

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

[ https://issues.apache.org/jira/browse/DRILL-2967?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sean Hsuan-Yi Chu resolved DRILL-2967. -- Resolution: Cannot Reproduce > Incompatible types error reported in a "not in" query wit

[jira] [Resolved] (DRILL-2688) Use of ORDER BY on right side of Union All results in SqlValidatorException

[ https://issues.apache.org/jira/browse/DRILL-2688?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sean Hsuan-Yi Chu resolved DRILL-2688. -- Resolution: Invalid Here is the reference: http://docs.oracle.com/cd/B28359_01/server.11

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

Sean Hsuan-Yi Chu created DRILL-3238: Summary: Cannot Plan Exception is raised when the same window partition is defined in select & window clauses Key: DRILL-3238 URL: https://issues.apache.org/jira/browse/DR

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

[ https://issues.apache.org/jira/browse/DRILL-3130?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sean Hsuan-Yi Chu resolved DRILL-3130. -- Resolution: Fixed Fix Version/s: 1.1.0 Target Version/s: (was: Future)

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

[ https://issues.apache.org/jira/browse/DRILL-2746?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sean Hsuan-Yi Chu resolved DRILL-2746. -- Resolution: Fixed Fix Version/s: (was: 1.2.0) 1.1.0 > Filt

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

[ https://issues.apache.org/jira/browse/DRILL-2866?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sean Hsuan-Yi Chu resolved DRILL-2866. -- Resolution: Fixed > Incorrect error message reporting schema change when streaming aggre

[jira] [Resolved] (DRILL-3019) Extra column in Schema of Recordbatch from scanning Values

[ https://issues.apache.org/jira/browse/DRILL-3019?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sean Hsuan-Yi Chu resolved DRILL-3019. -- Resolution: Fixed > Extra column in Schema of Recordbatch from scanning Values > --

[jira] [Created] (DRILL-3174) Calcite blocks queries whose type-missmatch can be resolved by Drill's Implicit casting

Sean Hsuan-Yi Chu created DRILL-3174: Summary: Calcite blocks queries whose type-missmatch can be resolved by Drill's Implicit casting Key: DRILL-3174 URL: https://issues.apache.org/jira/browse/DRILL-3174

[jira] [Resolved] (DRILL-2152) Scalar Subqueries error message should be friendly

[ https://issues.apache.org/jira/browse/DRILL-2152?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sean Hsuan-Yi Chu resolved DRILL-2152. -- Resolution: Invalid Since this type of query is supported now (see DRILL-1957), mark thi

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

Sean Hsuan-Yi Chu created DRILL-3130: Summary: Project can be pushed below union all / union to improve performance Key: DRILL-3130 URL: https://issues.apache.org/jira/browse/DRILL-3130 Project: A

[jira] [Created] (DRILL-3117) Wrong Join-Order when In-List is materialized as a table

Sean Hsuan-Yi Chu created DRILL-3117: Summary: Wrong Join-Order when In-List is materialized as a table Key: DRILL-3117 URL: https://issues.apache.org/jira/browse/DRILL-3117 Project: Apache Drill

[jira] [Resolved] (DRILL-3085) In ExternalSortBatch, Memory Leak in Runtime Generation Code

[ https://issues.apache.org/jira/browse/DRILL-3085?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sean Hsuan-Yi Chu resolved DRILL-3085. -- Resolution: Fixed > In ExternalSortBatch, Memory Leak in Runtime Generation Code > -

[jira] [Resolved] (DRILL-3065) Memory Leak at ExternalSortBatch

[ https://issues.apache.org/jira/browse/DRILL-3065?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sean Hsuan-Yi Chu resolved DRILL-3065. -- Resolution: Fixed > Memory Leak at ExternalSortBatch >

[jira] [Resolved] (DRILL-2378) UNION ALL on Aggregates with GROUP BY and ORDER BY fails when column aliases don't match

[ https://issues.apache.org/jira/browse/DRILL-2378?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sean Hsuan-Yi Chu resolved DRILL-2378. -- Resolution: Pending Closed > UNION ALL on Aggregates with GROUP BY and ORDER BY fails wh

[jira] [Resolved] (DRILL-2377) UNION ALL on Aggregates with GROUP BY returns null when column aliases don't match

[ https://issues.apache.org/jira/browse/DRILL-2377?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sean Hsuan-Yi Chu resolved DRILL-2377. -- Resolution: Pending Closed > UNION ALL on Aggregates with GROUP BY returns null when col

[jira] [Created] (DRILL-3085) In ExternalSortBatch, Memory Leak in Runtime Generation Code

Sean Hsuan-Yi Chu created DRILL-3085: Summary: In ExternalSortBatch, Memory Leak in Runtime Generation Code Key: DRILL-3085 URL: https://issues.apache.org/jira/browse/DRILL-3085 Project: Apache Dr

[jira] [Created] (DRILL-3065) Memory Leak at ExternalSortBatch

Sean Hsuan-Yi Chu created DRILL-3065: Summary: Memory Leak at ExternalSortBatch Key: DRILL-3065 URL: https://issues.apache.org/jira/browse/DRILL-3065 Project: Apache Drill Issue Type: Bug

[jira] [Created] (DRILL-3019) Extra column in Schema of Recordbatch from scanning Values

Sean Hsuan-Yi Chu created DRILL-3019: Summary: Extra column in Schema of Recordbatch from scanning Values Key: DRILL-3019 URL: https://issues.apache.org/jira/browse/DRILL-3019 Project: Apache Dri

[jira] [Resolved] (DRILL-2966) HAVING clause with CASE statement with IN predicate causes assertion

[ https://issues.apache.org/jira/browse/DRILL-2966?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sean Hsuan-Yi Chu resolved DRILL-2966. -- Resolution: Fixed Resolved in a8c938767; Test cases were added also. > HAVING clause wi

[jira] [Resolved] (DRILL-1927) Aggregation or Group-By on a CASE expression with IN subquery fails

[ https://issues.apache.org/jira/browse/DRILL-1927?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sean Hsuan-Yi Chu resolved DRILL-1927. -- Resolution: Fixed Issue was resolved in DRILL-2914 (Calcite update). Test cases are adde

[jira] [Resolved] (DRILL-2181) Throw proper error message when flatten is used within an 'order by' or 'group by'

[ https://issues.apache.org/jira/browse/DRILL-2181?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sean Hsuan-Yi Chu resolved DRILL-2181. -- Resolution: Fixed > Throw proper error message when flatten is used within an 'order by'

[jira] [Resolved] (DRILL-2094) Drill has problems with reading json fields when used in a subquery

[ https://issues.apache.org/jira/browse/DRILL-2094?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sean Hsuan-Yi Chu resolved DRILL-2094. -- Resolution: Fixed > Drill has problems with reading json fields when used in a subquery

[jira] [Resolved] (DRILL-2881) count( col ) fails to plan when streamagg is disabled

[ https://issues.apache.org/jira/browse/DRILL-2881?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sean Hsuan-Yi Chu resolved DRILL-2881. -- Resolution: Invalid > count( col ) fails to plan when streamagg is disabled > --

[jira] [Created] (DRILL-2881) count( col ) fails to plan when streamagg is disabled

Sean Hsuan-Yi Chu created DRILL-2881: Summary: count( col ) fails to plan when streamagg is disabled Key: DRILL-2881 URL: https://issues.apache.org/jira/browse/DRILL-2881 Project: Apache Drill

[jira] [Resolved] (DRILL-2712) Issue with PruneScanRule and filter expressions that evaluate to false

[ https://issues.apache.org/jira/browse/DRILL-2712?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sean Hsuan-Yi Chu resolved DRILL-2712. -- Resolution: Fixed > Issue with PruneScanRule and filter expressions that evaluate to fal

[jira] [Resolved] (DRILL-1978) Using order by with a cast function and array index fails to plan.

[ https://issues.apache.org/jira/browse/DRILL-1978?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sean Hsuan-Yi Chu resolved DRILL-1978. -- Resolution: Fixed This is due to order by a column which is not part of select list. Als

  1   2   >