[jira] [Created] (HIVE-27124) Temporarily disable default usage of anti-join

2023-03-07 Thread Steve Carlin (Jira)
Steve Carlin created HIVE-27124: --- Summary: Temporarily disable default usage of anti-join Key: HIVE-27124 URL: https://issues.apache.org/jira/browse/HIVE-27124 Project: Hive Issue Type:

[jira] [Created] (HIVE-27002) PART_COL_STATS metastore query not hitting the index

2023-01-30 Thread Steve Carlin (Jira)
Steve Carlin created HIVE-27002: --- Summary: PART_COL_STATS metastore query not hitting the index Key: HIVE-27002 URL: https://issues.apache.org/jira/browse/HIVE-27002 Project: Hive Issue Type:

[jira] [Created] (HIVE-26737) Subquery returning wrong results when database has materialized views

2022-11-14 Thread Steve Carlin (Jira)
Steve Carlin created HIVE-26737: --- Summary: Subquery returning wrong results when database has materialized views Key: HIVE-26737 URL: https://issues.apache.org/jira/browse/HIVE-26737 Project: Hive

[jira] [Created] (HIVE-26726) tinyint column with windowing fn crashes at runtime

2022-11-10 Thread Steve Carlin (Jira)
Steve Carlin created HIVE-26726: --- Summary: tinyint column with windowing fn crashes at runtime Key: HIVE-26726 URL: https://issues.apache.org/jira/browse/HIVE-26726 Project: Hive Issue Type:

[jira] [Created] (HIVE-26683) Sum over window produces 0 when row contains null

2022-10-31 Thread Steve Carlin (Jira)
Steve Carlin created HIVE-26683: --- Summary: Sum over window produces 0 when row contains null Key: HIVE-26683 URL: https://issues.apache.org/jira/browse/HIVE-26683 Project: Hive Issue Type: Bug

[jira] [Created] (HIVE-26676) Count distinct in subquery returning wrong results

2022-10-28 Thread Steve Carlin (Jira)
Steve Carlin created HIVE-26676: --- Summary: Count distinct in subquery returning wrong results Key: HIVE-26676 URL: https://issues.apache.org/jira/browse/HIVE-26676 Project: Hive Issue Type:

[jira] [Created] (HIVE-26672) Top N Key Operator should not be allowed to pass through group by with grouping sets

2022-10-26 Thread Steve Carlin (Jira)
Steve Carlin created HIVE-26672: --- Summary: Top N Key Operator should not be allowed to pass through group by with grouping sets Key: HIVE-26672 URL: https://issues.apache.org/jira/browse/HIVE-26672

[jira] [Created] (HIVE-26671) Incorrect results for group by/order by/limit query with 2 aggregates

2022-10-26 Thread Steve Carlin (Jira)
Steve Carlin created HIVE-26671: --- Summary: Incorrect results for group by/order by/limit query with 2 aggregates Key: HIVE-26671 URL: https://issues.apache.org/jira/browse/HIVE-26671 Project: Hive

[jira] [Created] (HIVE-26612) Hive cannot read parquet files with int64 (TIMESTAMP_MILLIS)

2022-10-07 Thread Steve Carlin (Jira)
Steve Carlin created HIVE-26612: --- Summary: Hive cannot read parquet files with int64 (TIMESTAMP_MILLIS) Key: HIVE-26612 URL: https://issues.apache.org/jira/browse/HIVE-26612 Project: Hive

[jira] [Created] (HIVE-26573) ClassCastException error on window function

2022-09-28 Thread Steve Carlin (Jira)
Steve Carlin created HIVE-26573: --- Summary: ClassCastException error on window function Key: HIVE-26573 URL: https://issues.apache.org/jira/browse/HIVE-26573 Project: Hive Issue Type: Bug

[jira] [Created] (HIVE-26387) Change UDAF Rank function to return Long

2022-07-12 Thread Steve Carlin (Jira)
Steve Carlin created HIVE-26387: --- Summary: Change UDAF Rank function to return Long Key: HIVE-26387 URL: https://issues.apache.org/jira/browse/HIVE-26387 Project: Hive Issue Type: Improvement

[jira] [Created] (HIVE-26294) Allow substr to take bigint as parameters

2022-06-06 Thread Steve Carlin (Jira)
Steve Carlin created HIVE-26294: --- Summary: Allow substr to take bigint as parameters Key: HIVE-26294 URL: https://issues.apache.org/jira/browse/HIVE-26294 Project: Hive Issue Type: Improvement

[jira] [Created] (HIVE-26283) Need better decision making for creating SortedDynPartitionOptimizer

2022-06-01 Thread Steve Carlin (Jira)
Steve Carlin created HIVE-26283: --- Summary: Need better decision making for creating SortedDynPartitionOptimizer Key: HIVE-26283 URL: https://issues.apache.org/jira/browse/HIVE-26283 Project: Hive

[jira] [Created] (HIVE-26208) Exception in Vectorization with Decimal64 to Decimal casting

2022-05-07 Thread Steve Carlin (Jira)
Steve Carlin created HIVE-26208: --- Summary: Exception in Vectorization with Decimal64 to Decimal casting Key: HIVE-26208 URL: https://issues.apache.org/jira/browse/HIVE-26208 Project: Hive

[jira] [Created] (HIVE-26139) URL Encoding from HIVE-26015 was a bit too aggressive

2022-04-12 Thread Steve Carlin (Jira)
Steve Carlin created HIVE-26139: --- Summary: URL Encoding from HIVE-26015 was a bit too aggressive Key: HIVE-26139 URL: https://issues.apache.org/jira/browse/HIVE-26139 Project: Hive Issue Type:

[jira] [Created] (HIVE-26117) Remove 2 superfluous lines of code in genJoinRelNode

2022-04-05 Thread Steve Carlin (Jira)
Steve Carlin created HIVE-26117: --- Summary: Remove 2 superfluous lines of code in genJoinRelNode Key: HIVE-26117 URL: https://issues.apache.org/jira/browse/HIVE-26117 Project: Hive Issue Type:

[jira] [Created] (HIVE-26108) Hive hardcodes hasMoreRows to false in thrift interface

2022-04-01 Thread Steve Carlin (Jira)
Steve Carlin created HIVE-26108: --- Summary: Hive hardcodes hasMoreRows to false in thrift interface Key: HIVE-26108 URL: https://issues.apache.org/jira/browse/HIVE-26108 Project: Hive Issue

[jira] [Created] (HIVE-26094) Compaction Worker thread not freeing the lock when lock status returned as WAITING

2022-03-30 Thread Steve Carlin (Jira)
Steve Carlin created HIVE-26094: --- Summary: Compaction Worker thread not freeing the lock when lock status returned as WAITING Key: HIVE-26094 URL: https://issues.apache.org/jira/browse/HIVE-26094

[jira] [Created] (HIVE-26015) HBase table with Ranger authentication fails; needs URLEncoding

2022-03-08 Thread Steve Carlin (Jira)
Steve Carlin created HIVE-26015: --- Summary: HBase table with Ranger authentication fails; needs URLEncoding Key: HIVE-26015 URL: https://issues.apache.org/jira/browse/HIVE-26015 Project: Hive

[jira] [Created] (HIVE-25812) GetResultSchema service called in ERROR state

2021-12-15 Thread Steve Carlin (Jira)
Steve Carlin created HIVE-25812: --- Summary: GetResultSchema service called in ERROR state Key: HIVE-25812 URL: https://issues.apache.org/jira/browse/HIVE-25812 Project: Hive Issue Type:

[jira] [Created] (HIVE-25670) Avoid getTable() calls for foreign key tables not used in a query

2021-11-03 Thread Steve Carlin (Jira)
Steve Carlin created HIVE-25670: --- Summary: Avoid getTable() calls for foreign key tables not used in a query Key: HIVE-25670 URL: https://issues.apache.org/jira/browse/HIVE-25670 Project: Hive

[jira] [Created] (HIVE-25528) Avoid recalculating types after CBO on second AST pass

2021-09-15 Thread Steve Carlin (Jira)
Steve Carlin created HIVE-25528: --- Summary: Avoid recalculating types after CBO on second AST pass Key: HIVE-25528 URL: https://issues.apache.org/jira/browse/HIVE-25528 Project: Hive Issue

[jira] [Created] (HIVE-25515) Allow optional "AS" in column aliases in Values clause

2021-09-10 Thread Steve Carlin (Jira)
Steve Carlin created HIVE-25515: --- Summary: Allow optional "AS" in column aliases in Values clause Key: HIVE-25515 URL: https://issues.apache.org/jira/browse/HIVE-25515 Project: Hive Issue

[jira] [Created] (HIVE-25505) Incorrect results with header. skip.header.line.count if first line is blank

2021-09-07 Thread Steve Carlin (Jira)
Steve Carlin created HIVE-25505: --- Summary: Incorrect results with header. skip.header.line.count if first line is blank Key: HIVE-25505 URL: https://issues.apache.org/jira/browse/HIVE-25505 Project:

[jira] [Created] (HIVE-25283) Schema Evolution tests for IntToNumericGroup and BigintToNumericGroup conversion fails on output mismatch after alter table

2021-06-23 Thread Steve Carlin (Jira)
Steve Carlin created HIVE-25283: --- Summary: Schema Evolution tests for IntToNumericGroup and BigintToNumericGroup conversion fails on output mismatch after alter table Key: HIVE-25283 URL:

[jira] [Created] (HIVE-25189) Cache the validWriteIdList in query cache before fetching tables from HMS

2021-06-02 Thread Steve Carlin (Jira)
Steve Carlin created HIVE-25189: --- Summary: Cache the validWriteIdList in query cache before fetching tables from HMS Key: HIVE-25189 URL: https://issues.apache.org/jira/browse/HIVE-25189 Project: Hive

[jira] [Created] (HIVE-25085) MetaStore Clients are being shared across different sessions

2021-05-02 Thread Steve Carlin (Jira)
Steve Carlin created HIVE-25085: --- Summary: MetaStore Clients are being shared across different sessions Key: HIVE-25085 URL: https://issues.apache.org/jira/browse/HIVE-25085 Project: Hive

[jira] [Created] (HIVE-25070) SessionHiveMetaStoreClient.getValidWriteIdList should handle "Retrying" exceptions

2021-04-28 Thread Steve Carlin (Jira)
Steve Carlin created HIVE-25070: --- Summary: SessionHiveMetaStoreClient.getValidWriteIdList should handle "Retrying" exceptions Key: HIVE-25070 URL: https://issues.apache.org/jira/browse/HIVE-25070

[jira] [Created] (HIVE-24926) Correlated fields not detected if subquery has where and group clauses.

2021-03-23 Thread Steve Carlin (Jira)
Steve Carlin created HIVE-24926: --- Summary: Correlated fields not detected if subquery has where and group clauses. Key: HIVE-24926 URL: https://issues.apache.org/jira/browse/HIVE-24926 Project: Hive

[jira] [Created] (HIVE-24817) "not in" clause returns incorrect data when there is coercion

2021-02-23 Thread Steve Carlin (Jira)
Steve Carlin created HIVE-24817: --- Summary: "not in" clause returns incorrect data when there is coercion Key: HIVE-24817 URL: https://issues.apache.org/jira/browse/HIVE-24817 Project: Hive

[jira] [Created] (HIVE-24105) Refactor partition pruning

2020-09-01 Thread Steve Carlin (Jira)
Steve Carlin created HIVE-24105: --- Summary: Refactor partition pruning Key: HIVE-24105 URL: https://issues.apache.org/jira/browse/HIVE-24105 Project: Hive Issue Type: Improvement

[jira] [Created] (HIVE-23977) Consolidate partition fetch to one place

2020-08-03 Thread Steve Carlin (Jira)
Steve Carlin created HIVE-23977: --- Summary: Consolidate partition fetch to one place Key: HIVE-23977 URL: https://issues.apache.org/jira/browse/HIVE-23977 Project: Hive Issue Type: Improvement

[jira] [Created] (HIVE-23941) Refactor TypeCheckProcFactory to be database agnostic

2020-07-27 Thread Steve Carlin (Jira)
Steve Carlin created HIVE-23941: --- Summary: Refactor TypeCheckProcFactory to be database agnostic Key: HIVE-23941 URL: https://issues.apache.org/jira/browse/HIVE-23941 Project: Hive Issue Type:

[jira] [Created] (HIVE-23932) Test TypeCheckProcFactory reorg

2020-07-24 Thread Steve Carlin (Jira)
Steve Carlin created HIVE-23932: --- Summary: Test TypeCheckProcFactory reorg Key: HIVE-23932 URL: https://issues.apache.org/jira/browse/HIVE-23932 Project: Hive Issue Type: Improvement

[jira] [Created] (HIVE-23892) Test Interpretation String fix

2020-07-21 Thread Steve Carlin (Jira)
Steve Carlin created HIVE-23892: --- Summary: Test Interpretation String fix Key: HIVE-23892 URL: https://issues.apache.org/jira/browse/HIVE-23892 Project: Hive Issue Type: Improvement

[jira] [Created] (HIVE-23497) Change RexNodeExprFactory so it doesn't instantiate a factory every call

2020-05-18 Thread Steve Carlin (Jira)
Steve Carlin created HIVE-23497: --- Summary: Change RexNodeExprFactory so it doesn't instantiate a factory every call Key: HIVE-23497 URL: https://issues.apache.org/jira/browse/HIVE-23497 Project: Hive

[jira] [Created] (HIVE-23206) Project not defined correctly after reordering a join

2020-04-14 Thread Steve Carlin (Jira)
Steve Carlin created HIVE-23206: --- Summary: Project not defined correctly after reordering a join Key: HIVE-23206 URL: https://issues.apache.org/jira/browse/HIVE-23206 Project: Hive Issue Type:

[jira] [Created] (HIVE-22456) When one branch from inner join produces max 0 rows, then we can introduce limit 0 on the other branch.

2019-11-04 Thread Steve Carlin (Jira)
Steve Carlin created HIVE-22456: --- Summary: When one branch from inner join produces max 0 rows, then we can introduce limit 0 on the other branch. Key: HIVE-22456 URL:

[jira] [Created] (HIVE-22455) Union branch removal rule does not kick in.

2019-11-04 Thread Steve Carlin (Jira)
Steve Carlin created HIVE-22455: --- Summary: Union branch removal rule does not kick in. Key: HIVE-22455 URL: https://issues.apache.org/jira/browse/HIVE-22455 Project: Hive Issue Type:

[jira] [Created] (HIVE-22454) Remove subplan under "Limit 0"

2019-11-04 Thread Steve Carlin (Jira)
Steve Carlin created HIVE-22454: --- Summary: Remove subplan under "Limit 0" Key: HIVE-22454 URL: https://issues.apache.org/jira/browse/HIVE-22454 Project: Hive Issue Type: Improvement

[jira] [Created] (HIVE-22408) The fix for CALCITE-2991 creates wrong results on edge case

2019-10-26 Thread Steve Carlin (Jira)
Steve Carlin created HIVE-22408: --- Summary: The fix for CALCITE-2991 creates wrong results on edge case Key: HIVE-22408 URL: https://issues.apache.org/jira/browse/HIVE-22408 Project: Hive

[jira] [Created] (HIVE-22324) Checkin test output changes due to Calcite 1.21 upgrade

2019-10-10 Thread Steve Carlin (Jira)
Steve Carlin created HIVE-22324: --- Summary: Checkin test output changes due to Calcite 1.21 upgrade Key: HIVE-22324 URL: https://issues.apache.org/jira/browse/HIVE-22324 Project: Hive Issue

[jira] [Created] (HIVE-22288) Add tests for grouping sets for correlated subqueries

2019-10-02 Thread Steve Carlin (Jira)
Steve Carlin created HIVE-22288: --- Summary: Add tests for grouping sets for correlated subqueries Key: HIVE-22288 URL: https://issues.apache.org/jira/browse/HIVE-22288 Project: Hive Issue Type:

[jira] [Created] (HIVE-22274) Upgrade Calcite version to 1.21.0

2019-09-30 Thread Steve Carlin (Jira)
Steve Carlin created HIVE-22274: --- Summary: Upgrade Calcite version to 1.21.0 Key: HIVE-22274 URL: https://issues.apache.org/jira/browse/HIVE-22274 Project: Hive Issue Type: Task Affects

[jira] [Created] (HIVE-22265) Ordinals in view are not being picked up in materialized view

2019-09-27 Thread Steve Carlin (Jira)
Steve Carlin created HIVE-22265: --- Summary: Ordinals in view are not being picked up in materialized view Key: HIVE-22265 URL: https://issues.apache.org/jira/browse/HIVE-22265 Project: Hive

[jira] [Created] (HIVE-22264) Degenerate case where mv not being used: computing aggregate on group by field

2019-09-27 Thread Steve Carlin (Jira)
Steve Carlin created HIVE-22264: --- Summary: Degenerate case where mv not being used: computing aggregate on group by field Key: HIVE-22264 URL: https://issues.apache.org/jira/browse/HIVE-22264 Project:

[jira] [Created] (HIVE-22263) MV has distinct on columns and query has count(distinct) on one of the columns, we do not trigger rewritin

2019-09-27 Thread Steve Carlin (Jira)
Steve Carlin created HIVE-22263: --- Summary: MV has distinct on columns and query has count(distinct) on one of the columns, we do not trigger rewritin Key: HIVE-22263 URL:

[jira] [Created] (HIVE-22262) Aggregate pushdown through join may generate additional rewriting opportunities

2019-09-27 Thread Steve Carlin (Jira)
Steve Carlin created HIVE-22262: --- Summary: Aggregate pushdown through join may generate additional rewriting opportunities Key: HIVE-22262 URL: https://issues.apache.org/jira/browse/HIVE-22262 Project:

[jira] [Created] (HIVE-22261) Materialized view rewriting does not support window functions

2019-09-27 Thread Steve Carlin (Jira)
Steve Carlin created HIVE-22261: --- Summary: Materialized view rewriting does not support window functions Key: HIVE-22261 URL: https://issues.apache.org/jira/browse/HIVE-22261 Project: Hive

[jira] [Created] (HIVE-22260) Materialized view rewriting does not support `UNION` operator, exact match can work under view

2019-09-27 Thread Steve Carlin (Jira)
Steve Carlin created HIVE-22260: --- Summary: Materialized view rewriting does not support `UNION` operator, exact match can work under view Key: HIVE-22260 URL: https://issues.apache.org/jira/browse/HIVE-22260

[jira] [Created] (HIVE-22259) Rewriting fails for `BETWEEN` clauses with different ranges in MV and query

2019-09-27 Thread Steve Carlin (Jira)
Steve Carlin created HIVE-22259: --- Summary: Rewriting fails for `BETWEEN` clauses with different ranges in MV and query Key: HIVE-22259 URL: https://issues.apache.org/jira/browse/HIVE-22259 Project:

[jira] [Created] (HIVE-22258) Rewriting fails for `IN` clauses in MV and query when we use equals or subset in the query

2019-09-27 Thread Steve Carlin (Jira)
Steve Carlin created HIVE-22258: --- Summary: Rewriting fails for `IN` clauses in MV and query when we use equals or subset in the query Key: HIVE-22258 URL: https://issues.apache.org/jira/browse/HIVE-22258

[jira] [Created] (HIVE-22257) Commutativity of operations is not taken into account, e.g., '+'

2019-09-27 Thread Steve Carlin (Jira)
Steve Carlin created HIVE-22257: --- Summary: Commutativity of operations is not taken into account, e.g., '+' Key: HIVE-22257 URL: https://issues.apache.org/jira/browse/HIVE-22257 Project: Hive

[jira] [Created] (HIVE-22256) Rewriting fails when `IN` clause has items in different order in MV and query.

2019-09-27 Thread Steve Carlin (Jira)
Steve Carlin created HIVE-22256: --- Summary: Rewriting fails when `IN` clause has items in different order in MV and query. Key: HIVE-22256 URL: https://issues.apache.org/jira/browse/HIVE-22256 Project:

[jira] [Created] (HIVE-22254) Mappings.NoElementException: no target in mapping, in `MaterializedViewAggregateRule

2019-09-27 Thread Steve Carlin (Jira)
Steve Carlin created HIVE-22254: --- Summary: Mappings.NoElementException: no target in mapping, in `MaterializedViewAggregateRule Key: HIVE-22254 URL: https://issues.apache.org/jira/browse/HIVE-22254

[jira] [Created] (HIVE-22253) General task tracking improvements for materialized views

2019-09-27 Thread Steve Carlin (Jira)
Steve Carlin created HIVE-22253: --- Summary: General task tracking improvements for materialized views Key: HIVE-22253 URL: https://issues.apache.org/jira/browse/HIVE-22253 Project: Hive Issue