[jira] [Assigned] (DRILL-1867) Case sensitivity of query identifiers is inconstistent

[ https://issues.apache.org/jira/browse/DRILL-1867?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni reassigned DRILL-1867: - Assignee: Jinfeng Ni Case sensitivity of query identifiers is inconstistent

[jira] [Created] (DRILL-1913) Drill did not correctly preserve output field's case sensitivity

Jinfeng Ni created DRILL-1913: - Summary: Drill did not correctly preserve output field's case sensitivity Key: DRILL-1913 URL: https://issues.apache.org/jira/browse/DRILL-1913 Project: Apache Drill

[jira] [Commented] (DRILL-1867) Case sensitivity of query identifiers is inconstistent

[ https://issues.apache.org/jira/browse/DRILL-1867?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14261787#comment-14261787 ] Jinfeng Ni commented on DRILL-1867: --- Add test case for parquet / cdv data sources. Open

[jira] [Commented] (DRILL-1905) UNION ALL of two identical json files fails with exception

[ https://issues.apache.org/jira/browse/DRILL-1905?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14262460#comment-14262460 ] Jinfeng Ni commented on DRILL-1905: --- +1. Looks good to me. For the change in Calcite,

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

[ https://issues.apache.org/jira/browse/DRILL-2069?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14292184#comment-14292184 ] Jinfeng Ni commented on DRILL-2069: --- Upgrade to critical, since it's incorrect result,

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

[ https://issues.apache.org/jira/browse/DRILL-2069?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-2069: -- Priority: Critical (was: Major) Star is not expanded correctly in the query with IN clause containing

[jira] [Assigned] (DRILL-1911) Querying same field multiple times with different case would hit memory leak and return incorrect result.

[ https://issues.apache.org/jira/browse/DRILL-1911?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni reassigned DRILL-1911: - Assignee: Jinfeng Ni (was: Deneche A. Hakim) Querying same field multiple times with different

[jira] [Commented] (DRILL-2168) Wrong result on grouping by expression involving CONCAT function

[ https://issues.apache.org/jira/browse/DRILL-2168?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14306347#comment-14306347 ] Jinfeng Ni commented on DRILL-2168: --- The plan looks invalid. The $1 in the following

[jira] [Updated] (DRILL-2107) Hash Join throw IOBE for a query with exists subquery.

[ https://issues.apache.org/jira/browse/DRILL-2107?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-2107: -- Priority: Blocker (was: Critical) Hash Join throw IOBE for a query with exists subquery.

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

[ https://issues.apache.org/jira/browse/DRILL-2069?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14301871#comment-14301871 ] Jinfeng Ni commented on DRILL-2069: --- Revise patch based on review comments. Add two new

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

[ https://issues.apache.org/jira/browse/DRILL-2069?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-2069: -- Attachment: (was: 0001-DRILL-2069-Fix-star-query-prefix-logic-it-s-used-wit.patch) Star is not

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

[ https://issues.apache.org/jira/browse/DRILL-2069?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-2069: -- Attachment: 0001-DRILL-2069-Fix-star-query-prefix-logic-it-s-used-wit.patch Star is not expanded

[jira] [Updated] (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 ] Jinfeng Ni updated DRILL-2095: -- Fix Version/s: 1.0.0 Order by on a repeated index inside a sub query results in an NPE

[jira] [Updated] (DRILL-2087) Some planner option setting might produce a wrong plan and wrong query result for join query.

[ https://issues.apache.org/jira/browse/DRILL-2087?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-2087: -- Fix Version/s: 0.9.0 Some planner option setting might produce a wrong plan and wrong query result

[jira] [Updated] (DRILL-2081) Filter not being pushed down into the sub query when we use flatten

[ https://issues.apache.org/jira/browse/DRILL-2081?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-2081: -- Fix Version/s: 1.0.0 Filter not being pushed down into the sub query when we use flatten

[jira] [Updated] (DRILL-2155) Subquery in projection list that returns scalar result throws an exception

[ https://issues.apache.org/jira/browse/DRILL-2155?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-2155: -- Fix Version/s: 0.9.0 Assignee: Sean Hsuan-Yi Chu (was: Jinfeng Ni) Subquery in projection

[jira] [Updated] (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 ] Jinfeng Ni updated DRILL-2094: -- Fix Version/s: 1.0.0 Drill has problems with reading json fields when used in a subquery

[jira] [Updated] (DRILL-2173) Enable querying partition information without reading all data

[ https://issues.apache.org/jira/browse/DRILL-2173?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-2173: -- Fix Version/s: 0.8.0 Enable querying partition information without reading all data

[jira] [Updated] (DRILL-2073) Filter on a field in a nested repeated type throws an exception

[ https://issues.apache.org/jira/browse/DRILL-2073?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-2073: -- Component/s: (was: Query Planning Optimization) Execution - Data Types Filter on

[jira] [Updated] (DRILL-2146) Flatten Function on two layer deep field fails to plan

[ https://issues.apache.org/jira/browse/DRILL-2146?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-2146: -- Fix Version/s: 0.9.0 Flatten Function on two layer deep field fails to plan

[jira] [Updated] (DRILL-2053) Column names are case sensitive if column is coming from WITH clause

[ https://issues.apache.org/jira/browse/DRILL-2053?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-2053: -- Fix Version/s: 1.0.0 Column names are case sensitive if column is coming from WITH clause

[jira] [Updated] (DRILL-2157) Directory pruning on subdirectories only and data type conversions for directory filters

[ https://issues.apache.org/jira/browse/DRILL-2157?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-2157: -- Fix Version/s: 1.0.0 Assignee: Aman Sinha (was: Jinfeng Ni) Directory pruning on

[jira] [Commented] (DRILL-2081) Filter not being pushed down into the sub query when we use flatten

[ https://issues.apache.org/jira/browse/DRILL-2081?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14309710#comment-14309710 ] Jinfeng Ni commented on DRILL-2081: --- s.evnts.type = 'cmpgn4' can not pushed into

[jira] [Updated] (DRILL-2170) Wrong result when joining to a subquery that has group-by, order-by and LIMIT

[ https://issues.apache.org/jira/browse/DRILL-2170?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-2170: -- Fix Version/s: 0.8.0 Wrong result when joining to a subquery that has group-by, order-by and LIMIT

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

[ https://issues.apache.org/jira/browse/DRILL-2069?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-2069: -- Fix Version/s: 0.8.0 Star is not expanded correctly in the query with IN clause containing subquery

[jira] [Commented] (DRILL-1921) Throw unsupported error message some set operators that are not currently supported

[ https://issues.apache.org/jira/browse/DRILL-1921?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14310094#comment-14310094 ] Jinfeng Ni commented on DRILL-1921: --- +1 Throw unsupported error message some set

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

[ https://issues.apache.org/jira/browse/DRILL-2139?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14309675#comment-14309675 ] Jinfeng Ni commented on DRILL-2139: --- Probably we want to disable select distinct * in

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

[ https://issues.apache.org/jira/browse/DRILL-2139?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-2139: -- Fix Version/s: 1.0.0 Star is not expanded correctly in select distinct query

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

[ https://issues.apache.org/jira/browse/DRILL-2115?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-2115: -- Fix Version/s: 0.9.0 Disable function CARDINALITY in grammar ---

[jira] [Updated] (DRILL-2116) Add non-reserved keywords to non-reserved keyword list in parser

[ https://issues.apache.org/jira/browse/DRILL-2116?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-2116: -- Fix Version/s: 0.9.0 Assignee: Sean Hsuan-Yi Chu (was: Aman Sinha) Add non-reserved keywords

[jira] [Updated] (DRILL-2055) Drill should error out for Invalid json file if it has the same map key names.

[ https://issues.apache.org/jira/browse/DRILL-2055?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-2055: -- Component/s: (was: Query Planning Optimization) Storage - JSON Assignee:

[jira] [Assigned] (DRILL-1921) Throw unsupported error message some set operators that are not currently supported

[ https://issues.apache.org/jira/browse/DRILL-1921?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni reassigned DRILL-1921: - Assignee: Sean Hsuan-Yi Chu (was: Jinfeng Ni) Throw unsupported error message some set

[jira] [Commented] (DRILL-2054) Support `||` as concat operator for varchar inputs

[ https://issues.apache.org/jira/browse/DRILL-2054?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14304262#comment-14304262 ] Jinfeng Ni commented on DRILL-2054: --- Minor comments: 1. For Junit test, add combination

[jira] [Commented] (DRILL-1921) Throw unsupported error message some set operators that are not currently supported

[ https://issues.apache.org/jira/browse/DRILL-1921?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14304360#comment-14304360 ] Jinfeng Ni commented on DRILL-1921: --- Couple of additional comments: 1.

[jira] [Updated] (DRILL-1889) when 'select *' is used along with an order by on length of a column, Drill is adding the computed length to the list of columns

[ https://issues.apache.org/jira/browse/DRILL-1889?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-1889: -- Attachment: (was: 0001-DRILL-1889-Fix-star-column-prefix-and-subsume-logic-.patch.2) when 'select

[jira] [Commented] (DRILL-1889) when 'select *' is used along with an order by on length of a column, Drill is adding the computed length to the list of columns

[ https://issues.apache.org/jira/browse/DRILL-1889?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14279086#comment-14279086 ] Jinfeng Ni commented on DRILL-1889: --- Revise the code based on the comments. Add the

[jira] [Commented] (DRILL-1889) when 'select *' is used along with an order by on length of a column, Drill is adding the computed length to the list of columns

[ https://issues.apache.org/jira/browse/DRILL-1889?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14277756#comment-14277756 ] Jinfeng Ni commented on DRILL-1889: --- The cause of this wrong result for select * query

[jira] [Updated] (DRILL-1889) when 'select *' is used along with an order by on length of a column, Drill is adding the computed length to the list of columns

[ https://issues.apache.org/jira/browse/DRILL-1889?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-1889: -- Attachment: (was: 0001-DRILL-1889-Fix-star-column-prefix-and-subsume-logic-.patch) when 'select

[jira] [Updated] (DRILL-1889) when 'select *' is used along with an order by on length of a column, Drill is adding the computed length to the list of columns

[ https://issues.apache.org/jira/browse/DRILL-1889?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-1889: -- Attachment: 0001-DRILL-1889-Fix-star-column-prefix-and-subsume-logic-.patch.2 Made small change to the

[jira] [Updated] (DRILL-1889) when 'select *' is used along with an order by on length of a column, Drill is adding the computed length to the list of columns

[ https://issues.apache.org/jira/browse/DRILL-1889?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-1889: -- Attachment: 0001-DRILL-1889-Fix-star-column-prefix-and-subsume-logic-.patch when 'select *' is used

[jira] [Commented] (DRILL-1500) Partition filtering might lead to an unnecessary column in the result set.

[ https://issues.apache.org/jira/browse/DRILL-1500?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14279390#comment-14279390 ] Jinfeng Ni commented on DRILL-1500: --- With patch of DRILL-1889, the incorrect result

[jira] [Updated] (DRILL-2030) CTAS with SELECT * and expression creates column names with prefix

[ https://issues.apache.org/jira/browse/DRILL-2030?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-2030: -- Attachment: 0001-DRILL-2030-fix-column-prefix-for-CTAS-when-query-has.patch CTAS with SELECT * and

[jira] [Commented] (DRILL-1934) Failure to plan queries containing scalar subqueries without correlation

[ https://issues.apache.org/jira/browse/DRILL-1934?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14287938#comment-14287938 ] Jinfeng Ni commented on DRILL-1934: --- The cause for the failiing cases is in the logic of

[jira] [Commented] (DRILL-1655) Cannot plan simple join + group by + order + limit query

[ https://issues.apache.org/jira/browse/DRILL-1655?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14288580#comment-14288580 ] Jinfeng Ni commented on DRILL-1655: --- I could re-produce this same issue with a little

[jira] [Commented] (DRILL-2041) Throw unsupported error message on GROUP BY/ORDER BY array/map types

[ https://issues.apache.org/jira/browse/DRILL-2041?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14284965#comment-14284965 ] Jinfeng Ni commented on DRILL-2041: --- For this particular issue, I'm going to make the

[jira] [Commented] (DRILL-2030) CTAS with SELECT * and expression creates column names with prefix

[ https://issues.apache.org/jira/browse/DRILL-2030?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14285583#comment-14285583 ] Jinfeng Ni commented on DRILL-2030: --- Committed as [a8036d2] CTAS with SELECT * and

[jira] [Commented] (DRILL-1563) IndexOutOfBoundException during change traits when aggregating over subquery with order-by

[ https://issues.apache.org/jira/browse/DRILL-1563?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14288108#comment-14288108 ] Jinfeng Ni commented on DRILL-1563: --- This seems to be have been fixed. I run a simliar

[jira] [Resolved] (DRILL-1563) IndexOutOfBoundException during change traits when aggregating over subquery with order-by

[ https://issues.apache.org/jira/browse/DRILL-1563?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni resolved DRILL-1563. --- Resolution: Fixed IndexOutOfBoundException during change traits when aggregating over subquery

[jira] [Assigned] (DRILL-2199) Wrong results while using case expression with decimal data type

[ https://issues.apache.org/jira/browse/DRILL-2199?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni reassigned DRILL-2199: - Assignee: Mehant Baid (was: Jinfeng Ni) Wrong results while using case expression with decimal

[jira] [Commented] (DRILL-2054) Support `||` as concat operator for varchar inputs

[ https://issues.apache.org/jira/browse/DRILL-2054?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14326400#comment-14326400 ] Jinfeng Ni commented on DRILL-2054: --- LGTM. +1 Support `||` as concat operator for

[jira] [Assigned] (DRILL-2268) Applying flatten after a join fails with IOBE

[ https://issues.apache.org/jira/browse/DRILL-2268?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni reassigned DRILL-2268: - Assignee: Jinfeng Ni (was: Jason Altekruse) Applying flatten after a join fails with IOBE

[jira] [Created] (DRILL-2269) Provide default implementation for getting cost of evaluating an expression in base class of LogicalExpression, in stead of throw Exception

Jinfeng Ni created DRILL-2269: - Summary: Provide default implementation for getting cost of evaluating an expression in base class of LogicalExpression, in stead of throw Exception Key: DRILL-2269 URL:

[jira] [Assigned] (DRILL-2269) Provide default implementation for getting cost of evaluating an expression in base class of LogicalExpression, in stead of throw Exception

[ https://issues.apache.org/jira/browse/DRILL-2269?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni reassigned DRILL-2269: - Assignee: Jinfeng Ni Provide default implementation for getting cost of evaluating an

[jira] [Commented] (DRILL-2168) Wrong result on grouping by expression involving CONCAT function

[ https://issues.apache.org/jira/browse/DRILL-2168?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14318783#comment-14318783 ] Jinfeng Ni commented on DRILL-2168: --- Uploaded the patches. The patches include a unit

[jira] [Updated] (DRILL-2168) Wrong result on grouping by expression involving CONCAT function

[ https://issues.apache.org/jira/browse/DRILL-2168?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-2168: -- Attachment: 0003-Bump-to-version-r18.1.patch

[jira] [Commented] (DRILL-2168) Wrong result on grouping by expression involving CONCAT function

[ https://issues.apache.org/jira/browse/DRILL-2168?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14318789#comment-14318789 ] Jinfeng Ni commented on DRILL-2168: --- Some additional comments: 1. The incorrect plan /

[jira] [Commented] (DRILL-2239) Confusing error message Column 't1' is ambiguous for _table_ name t1

[ https://issues.apache.org/jira/browse/DRILL-2239?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14319334#comment-14319334 ] Jinfeng Ni commented on DRILL-2239: --- The error message seems to be fine. In ON clause,

[jira] [Created] (DRILL-2236) Optimize hash inner join by swapping inputs based on row count comparison.

Jinfeng Ni created DRILL-2236: - Summary: Optimize hash inner join by swapping inputs based on row count comparison. Key: DRILL-2236 URL: https://issues.apache.org/jira/browse/DRILL-2236 Project: Apache

[jira] [Commented] (DRILL-2239) Confusing error message Column 't1' is ambiguous for _table_ name t1

[ https://issues.apache.org/jira/browse/DRILL-2239?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14319338#comment-14319338 ] Jinfeng Ni commented on DRILL-2239: --- Why ambiguous? The reason is that Drill is

[jira] [Updated] (DRILL-2236) Optimize hash inner join by swapping inputs based on row count comparison.

[ https://issues.apache.org/jira/browse/DRILL-2236?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-2236: -- Attachment: 0001-DRILL-2236-Optimize-hash-inner-join-by-swapping-inpu.patch Optimize hash inner join

[jira] [Updated] (DRILL-2236) Optimize hash inner join by swapping inputs based on row count comparison.

[ https://issues.apache.org/jira/browse/DRILL-2236?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-2236: -- Attachment: 0001-DRILL-2236-Optimize-hash-inner-join-by-swapping-inpu.patch Optimize hash inner join

[jira] [Resolved] (DRILL-2271) count(distinct ) against SystemTablePlugin will hit plan serialization/deserialization issue when executed in distributed mode.

[ https://issues.apache.org/jira/browse/DRILL-2271?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni resolved DRILL-2271. --- Resolution: Duplicate count(distinct ) against SystemTablePlugin will hit plan

[jira] [Updated] (DRILL-2242) Wrong result (more rows) when outer query groups by subset of columns that inner query groups by

[ https://issues.apache.org/jira/browse/DRILL-2242?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-2242: -- Attachment: 0002-DRILL-2242-Propagate-distribution-trait-when-Project.patch [~amansinha100], could you

[jira] [Updated] (DRILL-2269) Provide default implementation for getting cost of evaluating an expression in base class of LogicalExpression, in stead of throw Exception

[ https://issues.apache.org/jira/browse/DRILL-2269?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-2269: -- Attachment: 0001-DRILL-2269-Add-default-implementation-for-estimating.patch [~amansinha100], could you

[jira] [Created] (DRILL-2087) Some planner option setting might produce a wrong plan and wrong query result for join query.

Jinfeng Ni created DRILL-2087: - Summary: Some planner option setting might produce a wrong plan and wrong query result for join query. Key: DRILL-2087 URL: https://issues.apache.org/jira/browse/DRILL-2087

[jira] [Created] (DRILL-2107) Hash Join throw IOBE for a query with exists subquery.

Jinfeng Ni created DRILL-2107: - Summary: Hash Join throw IOBE for a query with exists subquery. Key: DRILL-2107 URL: https://issues.apache.org/jira/browse/DRILL-2107 Project: Apache Drill Issue

[jira] [Updated] (DRILL-2107) Hash Join throw IOBE for a query with exists subquery.

[ https://issues.apache.org/jira/browse/DRILL-2107?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-2107: -- Attachment: q4_1_mj.json q4_1_mj_phy.txt q4_1_hj.json

[jira] [Updated] (DRILL-2107) Hash Join throw IOBE for a query with exists subquery.

[ https://issues.apache.org/jira/browse/DRILL-2107?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-2107: -- Assignee: Mehant Baid (was: Chris Westin) Hash Join throw IOBE for a query with exists subquery.

[jira] [Updated] (DRILL-2074) Queries fail with OutOfMemory Exception when Hash Join Agg are turned off

[ https://issues.apache.org/jira/browse/DRILL-2074?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-2074: -- Component/s: (was: Query Planning Optimization) Execution - Operators

[jira] [Commented] (DRILL-2074) Queries fail with OutOfMemory Exception when Hash Join Agg are turned off

[ https://issues.apache.org/jira/browse/DRILL-2074?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14297340#comment-14297340 ] Jinfeng Ni commented on DRILL-2074: --- This exception is thrown in physical operator

[jira] [Commented] (DRILL-2012) Flatten fails when we filter by a non-projected column

[ https://issues.apache.org/jira/browse/DRILL-2012?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14297342#comment-14297342 ] Jinfeng Ni commented on DRILL-2012: --- Sean, Can you please take a look at this issue?

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

[ https://issues.apache.org/jira/browse/DRILL-2115?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-2115: -- Assignee: Sean Hsuan-Yi Chu (was: Jinfeng Ni) Disable function CARDINALITY in grammar

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

[ https://issues.apache.org/jira/browse/DRILL-2069?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-2069: -- Attachment: 0001-DRILL-2069-Fix-star-query-prefix-logic-it-s-used-wit.patch Star is not expanded

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

[ https://issues.apache.org/jira/browse/DRILL-2016?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-2016: -- Assignee: Sean Hsuan-Yi Chu (was: Jinfeng Ni) Remove multiset data type from supported grammar

[jira] [Updated] (DRILL-2008) select a || b from ... fails while select cast(a as varchar) || cast(b as varchar) from ...

[ https://issues.apache.org/jira/browse/DRILL-2008?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-2008: -- Assignee: Sean Hsuan-Yi Chu (was: Jinfeng Ni) select a || b from ... fails while select cast(a as

[jira] [Commented] (DRILL-1969) Error message thrown while querying Hive Views from Drill must be improved

[ https://issues.apache.org/jira/browse/DRILL-1969?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14271870#comment-14271870 ] Jinfeng Ni commented on DRILL-1969: --- +1. Fix looks good to me for this issue. Seems

[jira] [Commented] (DRILL-2087) Some planner option setting might produce a wrong plan and wrong query result for join query.

[ https://issues.apache.org/jira/browse/DRILL-2087?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14318512#comment-14318512 ] Jinfeng Ni commented on DRILL-2087: --- Talked to [~vkorukanti] about the conflict with

[jira] [Created] (DRILL-2250) Parquet reader hit ExecutionSetupException when reading decimal columns created using CTAS from another parquet files

Jinfeng Ni created DRILL-2250: - Summary: Parquet reader hit ExecutionSetupException when reading decimal columns created using CTAS from another parquet files Key: DRILL-2250 URL:

[jira] [Commented] (DRILL-2250) Parquet reader hit ExecutionSetupException when reading decimal columns created using CTAS from another parquet files

[ https://issues.apache.org/jira/browse/DRILL-2250?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14321181#comment-14321181 ] Jinfeng Ni commented on DRILL-2250: --- Here is part of stack trace for the error: {code}

[jira] [Updated] (DRILL-2087) Some planner option setting might produce a wrong plan and wrong query result for join query.

[ https://issues.apache.org/jira/browse/DRILL-2087?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-2087: -- Attachment: 0001-DRILL-2087-Fix-an-incorrect-join-plan-by-ensure-eith.patch Some planner option

[jira] [Assigned] (DRILL-2165) Assert when grouping on expression with extract and concat functions

[ https://issues.apache.org/jira/browse/DRILL-2165?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni reassigned DRILL-2165: - Assignee: Sean Hsuan-Yi Chu Assert when grouping on expression with extract and concat

[jira] [Updated] (DRILL-2458) Extra hash column added when running CTAS with order by

[ https://issues.apache.org/jira/browse/DRILL-2458?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-2458: -- Fix Version/s: 0.9.0 Extra hash column added when running CTAS with order by

[jira] [Commented] (DRILL-2458) Extra hash column added when running CTAS with order by

[ https://issues.apache.org/jira/browse/DRILL-2458?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14370069#comment-14370069 ] Jinfeng Ni commented on DRILL-2458: --- The extra column added seems not to be related to

[jira] [Updated] (DRILL-2458) Extra hash column added when running CTAS with order by

[ https://issues.apache.org/jira/browse/DRILL-2458?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-2458: -- Attachment: 0001-DRILL-2458-Ensure-no-unwanted-columns-are-added-to-C.patch Extra hash column added

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

[ https://issues.apache.org/jira/browse/DRILL-2411?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-2411: -- Component/s: (was: Query Planning Optimization) Execution - Relational Operators

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

[ https://issues.apache.org/jira/browse/DRILL-2411?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-2411: -- Assignee: Steven Phillips (was: Jinfeng Ni) Scalar SUM/AVG over empty result set returns no rows

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

[ https://issues.apache.org/jira/browse/DRILL-2411?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14353860#comment-14353860 ] Jinfeng Ni commented on DRILL-2411: --- The plan for the query seems to be fine, and I feel

[jira] [Assigned] (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 ] Jinfeng Ni reassigned DRILL-2313: - Assignee: Sean Hsuan-Yi Chu (was: Jinfeng Ni) Query fails when one of the operands is a DATE

[jira] [Assigned] (DRILL-2317) UNION ALL on sub-queries with single column projection fails on GROUP BY

[ https://issues.apache.org/jira/browse/DRILL-2317?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni reassigned DRILL-2317: - Assignee: Sean Hsuan-Yi Chu (was: Jinfeng Ni) UNION ALL on sub-queries with single column

[jira] [Created] (DRILL-2400) Drill's query planner did not merge multiple filters into one.

Jinfeng Ni created DRILL-2400: - Summary: Drill's query planner did not merge multiple filters into one. Key: DRILL-2400 URL: https://issues.apache.org/jira/browse/DRILL-2400 Project: Apache Drill

[jira] [Commented] (DRILL-2400) Drill's query planner did not merge multiple filters into one.

[ https://issues.apache.org/jira/browse/DRILL-2400?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14350970#comment-14350970 ] Jinfeng Ni commented on DRILL-2400: --- [~amansinha100], could you please review the patch

[jira] [Updated] (DRILL-2400) Drill's query planner did not merge multiple filters into one.

[ https://issues.apache.org/jira/browse/DRILL-2400?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-2400: -- Attachment: 0006-DRILL-2240-Part-2-Add-merge-filter-rule-to-logical-r.patch

[jira] [Commented] (DRILL-2400) Drill's query planner did not merge multiple filters into one.

[ https://issues.apache.org/jira/browse/DRILL-2400?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14351813#comment-14351813 ] Jinfeng Ni commented on DRILL-2400: --- With the patch, here is the new plan, where the two

[jira] [Resolved] (DRILL-2400) Drill's query planner did not merge multiple filters into one.

[ https://issues.apache.org/jira/browse/DRILL-2400?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni resolved DRILL-2400. --- Resolution: Fixed Fixed in commit 6be9e3b and 6e6f789 Drill's query planner did not merge multiple

[jira] [Updated] (DRILL-2311) Create table with same columns of different case results in a java.lang.IllegalStateException

[ https://issues.apache.org/jira/browse/DRILL-2311?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-2311: -- Assignee: Sean Hsuan-Yi Chu (was: Aman Sinha) Create table with same columns of different case

[jira] [Updated] (DRILL-2329) TPCDS query 95 and simplified variant fail to execute

[ https://issues.apache.org/jira/browse/DRILL-2329?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-2329: -- Fix Version/s: 1.1.0 TPCDS query 95 and simplified variant fail to execute

[jira] [Updated] (DRILL-2346) Star is not expanded correctly in create view if view fields are specified

[ https://issues.apache.org/jira/browse/DRILL-2346?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-2346: -- Fix Version/s: (was: 0.9.0) 1.1.0 Star is not expanded correctly in create view

[jira] [Updated] (DRILL-2346) Star is not expanded correctly in create view if view fields are specified

[ https://issues.apache.org/jira/browse/DRILL-2346?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-2346: -- Fix Version/s: 0.9.0 Star is not expanded correctly in create view if view fields are specified

[jira] [Updated] (DRILL-2398) IS NOT DISTINCT FROM predicate returns incorrect result when used as a join filter

[ https://issues.apache.org/jira/browse/DRILL-2398?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-2398: -- Assignee: Aman Sinha (was: Jinfeng Ni) IS NOT DISTINCT FROM predicate returns incorrect result when

[jira] [Updated] (DRILL-2318) Query fails when an ORDER BY clause is used with CTEs

[ https://issues.apache.org/jira/browse/DRILL-2318?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-2318: -- Fix Version/s: 0.9.0 Query fails when an ORDER BY clause is used with CTEs

  1   2   3   4   5   6   7   8   9   >