[jira] [Resolved] (HIVE-26864) Incremental rebuild of non-transaction materialized view fails

2023-02-08 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26864?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa resolved HIVE-26864. --- Resolution: Fixed Merged to master. Thanks [~veghlaci05] for the review. > Incremental

[jira] [Resolved] (HIVE-26980) CTAS and CMV fails if target table is Iceberg and source table has unsupported column type

2023-01-31 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26980?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa resolved HIVE-26980. --- Resolution: Fixed > CTAS and CMV fails if target table is Iceberg and source table has >

[jira] [Commented] (HIVE-26980) CTAS and CMV fails if target table is Iceberg and source table has unsupported column type

2023-01-31 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26980?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17682463#comment-17682463 ] Krisztian Kasa commented on HIVE-26980: --- Merged to master. Thanks [~dkuzmenko] and

[jira] [Updated] (HIVE-26980) CTAS and CMV fails if target table is Iceberg and source table has unsupported column type

2023-01-31 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26980?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa updated HIVE-26980: -- Summary: CTAS and CMV fails if target table is Iceberg and source table has unsupported column

[jira] [Commented] (HIVE-26980) Creation of materialized view stored by Iceberg fails if source table has tinyint column

2023-01-27 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26980?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17681352#comment-17681352 ] Krisztian Kasa commented on HIVE-26980: --- Issue is not specific to materialized view, CTAS statement

[jira] [Updated] (HIVE-26980) Creation of materialized view stored by Iceberg fails if source table has tinyint column

2023-01-27 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26980?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa updated HIVE-26980: -- Summary: Creation of materialized view stored by Iceberg fails if source table has tinyint

[jira] [Assigned] (HIVE-26980) Creation of materialized view stored by Iceberg fails if source table has tinyint column

2023-01-27 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26980?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa reassigned HIVE-26980: - Assignee: Krisztian Kasa > Creation of materialized view stored by Iceberg fails if

[jira] [Resolved] (HIVE-26967) Deadlock when enabling/disabling Materialized view stored by Iceberg

2023-01-20 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26967?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa resolved HIVE-26967. --- Resolution: Fixed Merged to master. Thanks [~zabetak] for the review. > Deadlock when

[jira] [Updated] (HIVE-26955) Select query fails when decimal column data type is changed to string/char/varchar in Parquet

2023-01-19 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26955?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa updated HIVE-26955: -- Resolution: Fixed Status: Resolved (was: Patch Available) Merged to master. Thanks

[jira] [Resolved] (HIVE-26925) MV with iceberg storage format fails when contains 'PARTITIONED ON' clause due to column number/types difference.

2023-01-19 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26925?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa resolved HIVE-26925. --- Resolution: Fixed Merged to master. Thanks [~zabetak] and [~amansinha100] for review.  > MV

[jira] [Assigned] (HIVE-26967) Deadlock when enabling/disabling Materialized view stored by Iceberg

2023-01-19 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26967?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa reassigned HIVE-26967: - > Deadlock when enabling/disabling Materialized view stored by Iceberg >

[jira] [Commented] (HIVE-26924) Alter materialized view enable rewrite throws SemanticException for source iceberg table

2023-01-19 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26924?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17678636#comment-17678636 ] Krisztian Kasa commented on HIVE-26924: --- Merged to master. Thanks [~amansinha100], [~zabetak],

[jira] [Resolved] (HIVE-26924) Alter materialized view enable rewrite throws SemanticException for source iceberg table

2023-01-19 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26924?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa resolved HIVE-26924. --- Resolution: Fixed > Alter materialized view enable rewrite throws SemanticException for

[jira] [Commented] (HIVE-26924) Alter materialized view enable rewrite throws SemanticException for source iceberg table

2023-01-19 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26924?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17678570#comment-17678570 ] Krisztian Kasa commented on HIVE-26924: --- [~zabetak] The {{SemanticException}} comes from the

[jira] [Resolved] (HIVE-26922) Deadlock when rebuilding Materialized view stored by Iceberg

2023-01-18 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26922?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa resolved HIVE-26922. --- Resolution: Fixed Merged to master. Thanks [~amansinha100], [~zabetak], [~sjc362000] for

[jira] [Resolved] (HIVE-26717) Query based Rebalance compaction on insert-only tables

2023-01-18 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26717?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa resolved HIVE-26717. --- Resolution: Fixed Merged to master. Thanks [~veghlaci05] for the patch and [~dkuzmenko] for

[jira] [Resolved] (HIVE-26936) Floating point zero and signed zero comparison as a part of join predicate is considered as not equal.

2023-01-15 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26936?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa resolved HIVE-26936. --- Resolution: Fixed Merged to master. Thanks [~Dayakar] for the fix. > Floating point zero

[jira] [Assigned] (HIVE-26925) MV with iceberg storage format fails when contains 'PARTITIONED ON' clause due to column number/types difference.

2023-01-12 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26925?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa reassigned HIVE-26925: - Assignee: Krisztian Kasa > MV with iceberg storage format fails when contains

[jira] [Commented] (HIVE-26924) Alter materialized view enable rewrite throws SemanticException for source iceberg table

2023-01-11 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26924?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17667572#comment-17667572 ] Krisztian Kasa commented on HIVE-26924: --- [~dharmikt]  Thanks for reporting this bug. Could you

[jira] [Updated] (HIVE-26924) Alter materialized view enable rewrite throws SemanticException for source iceberg table

2023-01-11 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26924?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa updated HIVE-26924: -- Summary: Alter materialized view enable rewrite throws SemanticException for source iceberg

[jira] [Assigned] (HIVE-26924) Alter materialized view enable rewrite throws SemanticException for source iceberg table

2023-01-11 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26924?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa reassigned HIVE-26924: - Assignee: Krisztian Kasa > Alter materialized view enable rewrite throws

[jira] [Assigned] (HIVE-26922) Deadlock when rebuilding Materialized view stored by Iceberg

2023-01-10 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26922?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa reassigned HIVE-26922: - > Deadlock when rebuilding Materialized view stored by Iceberg >

[jira] [Resolved] (HIVE-26718) Enable initiator to schedule rebalancing compactions

2023-01-09 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26718?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa resolved HIVE-26718. --- Resolution: Fixed Merged to master. Thanks [~veghlaci05] for the patch. > Enable initiator

[jira] [Resolved] (HIVE-26903) Compactor threads should gracefully shutdown

2023-01-09 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26903?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa resolved HIVE-26903. --- Resolution: Fixed Merged to master. Thanks [~veghlaci05] for the patch. > Compactor threads

[jira] [Resolved] (HIVE-23622) Fix orc_merge9

2023-01-07 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-23622?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa resolved HIVE-23622. --- Resolution: Fixed Merged to master. Thanks [~hemanth619] for review. > Fix orc_merge9 >

[jira] [Assigned] (HIVE-23622) Fix orc_merge9

2023-01-05 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-23622?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa reassigned HIVE-23622: - Assignee: Krisztian Kasa > Fix orc_merge9 > --- > > Key:

[jira] [Resolved] (HIVE-26787) Pushdown Timestamp data type to metastore via direct sql / JDO

2022-12-19 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26787?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa resolved HIVE-26787. --- Resolution: Fixed Merged to master. Thanks [~srahman] for the patch. > Pushdown Timestamp

[jira] [Assigned] (HIVE-26864) Incremental rebuild of non-transaction materialized view fails

2022-12-16 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26864?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa reassigned HIVE-26864: - > Incremental rebuild of non-transaction materialized view fails >

[jira] [Commented] (HIVE-26847) Allow a config to disable creation of Materialized Views

2022-12-15 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26847?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17648005#comment-17648005 ] Krisztian Kasa commented on HIVE-26847: --- [~ayushtkn]  Could you please share a usecase when MV

[jira] [Resolved] (HIVE-26817) Set column names in result schema when plan has Values root

2022-12-08 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26817?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa resolved HIVE-26817. --- Resolution: Fixed Merged to master. Thanks [~zabetak] for review. > Set column names in

[jira] [Assigned] (HIVE-26817) Set column names in result schema when plan has Values root

2022-12-07 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26817?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa reassigned HIVE-26817: - > Set column names in result schema when plan has Values root >

[jira] [Resolved] (HIVE-26771) Use DDLTask to created Iceberg table when running ctas statement

2022-12-07 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26771?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa resolved HIVE-26771. --- Resolution: Fixed Merged to master. Thanks [~dkuzmenko] for review. > Use DDLTask to

[jira] [Resolved] (HIVE-26762) Remove operand pruning in HiveFilterSetOpTransposeRule

2022-12-05 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26762?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa resolved HIVE-26762. --- Resolution: Fixed Merged to master. Thanks [~asolimando] for the patch. > Remove operand

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

2022-12-05 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26737?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17643166#comment-17643166 ] Krisztian Kasa edited comment on HIVE-26737 at 12/5/22 8:51 AM:

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

2022-12-05 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26737?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa resolved HIVE-26737. --- Resolution: Fixed Merged to master. Thanks [~scarlin] for the patch. > Subquery returning

[jira] [Resolved] (HIVE-26778) Pushdown Date data type to metastore via direct sql / JDO

2022-11-30 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26778?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa resolved HIVE-26778. --- Resolution: Fixed > Pushdown Date data type to metastore via direct sql / JDO >

[jira] [Commented] (HIVE-26778) Pushdown Date data type to metastore via direct sql / JDO

2022-11-30 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26778?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17641264#comment-17641264 ] Krisztian Kasa commented on HIVE-26778: --- Merged to master, thanks [~srahman] for the patch. >

[jira] [Resolved] (HIVE-26768) HPLSQL UDF is not working if it is applied on a column of type varchar/char/decimal in a table.

2022-11-28 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26768?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa resolved HIVE-26768. --- Resolution: Fixed Merged to master. Thanks [~Dayakar] for the patch. > HPLSQL UDF is not

[jira] [Updated] (HIVE-26771) Use DDLTask to created Iceberg table when running ctas statement

2022-11-24 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26771?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa updated HIVE-26771: -- Description: When Iceberg table is created via ctas statement the table is created in

[jira] [Assigned] (HIVE-26771) Use DDLTask to created Iceberg table when running ctas statement

2022-11-23 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26771?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa reassigned HIVE-26771: - > Use DDLTask to created Iceberg table when running ctas statement >

[jira] [Updated] (HIVE-26671) Incorrect results with Top N Key optimization

2022-11-22 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26671?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa updated HIVE-26671: -- Summary: Incorrect results with Top N Key optimization (was: Incorrect results for group

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

2022-11-21 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26737?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa reassigned HIVE-26737: - Assignee: Steve Carlin > Subquery returning wrong results when database has

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

2022-11-18 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26726?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa resolved HIVE-26726. --- Resolution: Fixed Merged to master. Thanks [~scarlin] for the fix and [~amansinha100] for

[jira] [Resolved] (HIVE-26747) Remove implementor from HiveRelNode

2022-11-16 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26747?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa resolved HIVE-26747. --- Resolution: Fixed Merged to master. Thanks [~zabetak] for review. > Remove implementor from

[jira] [Assigned] (HIVE-26747) Remove implementor from HiveRelNode

2022-11-16 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26747?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa reassigned HIVE-26747: - > Remove implementor from HiveRelNode > --- > >

[jira] [Resolved] (HIVE-26628) Iceberg table is created when running explain ctas command

2022-11-15 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26628?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa resolved HIVE-26628. --- Resolution: Fixed [https://github.com/apache/hive/pull/3745] was merged to master. Thanks

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

2022-10-30 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26671?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa resolved HIVE-26671. --- Resolution: Fixed Merged to master. Thanks [~scarlin] for the patch. > Incorrect results

[jira] [Resolved] (HIVE-26652) HiveSortPullUpConstantsRule produces an invalid plan when pulling up constants for nullable fields

2022-10-24 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26652?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa resolved HIVE-26652. --- Resolution: Fixed Merged to master. Thanks [~asolimando] for the patch. >

[jira] [Resolved] (HIVE-26370) Check stats are up-to-date when getting materialized view state

2022-10-21 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26370?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa resolved HIVE-26370. --- Resolution: Won't Fix HIVE-25656 was reverted by HIVE-26375. > Check stats are up-to-date

[jira] [Commented] (HIVE-26618) Add setting to turn on/off removing sections of a query plan known never produces rows

2022-10-13 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26618?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17616967#comment-17616967 ] Krisztian Kasa commented on HIVE-26618: --- The main responsibility of the new setting to control

[jira] [Updated] (HIVE-26618) Add setting to turn on/off removing sections of a query plan known never produces rows

2022-10-11 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26618?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa updated HIVE-26618: -- Fix Version/s: 4.0.0 4.0.0-alpha-2 > Add setting to turn on/off removing

[jira] [Updated] (HIVE-26524) Use Calcite to remove sections of a query plan known never produces rows

2022-10-11 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26524?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa updated HIVE-26524: -- Issue Type: New Feature (was: Improvement) > Use Calcite to remove sections of a query plan

[jira] [Assigned] (HIVE-26618) Add setting to turn on/off removing sections of a query plan known never produces rows

2022-10-11 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26618?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa reassigned HIVE-26618: - > Add setting to turn on/off removing sections of a query plan known never > produces rows

[jira] [Commented] (HIVE-26524) Use Calcite to remove sections of a query plan known never produces rows

2022-10-06 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26524?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17613851#comment-17613851 ] Krisztian Kasa commented on HIVE-26524: --- Merged to master. Thanks [~asolimando] and [~zabetak] for

[jira] [Resolved] (HIVE-26524) Use Calcite to remove sections of a query plan known never produces rows

2022-10-06 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26524?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa resolved HIVE-26524. --- Resolution: Fixed > Use Calcite to remove sections of a query plan known never produces rows

[jira] [Resolved] (HIVE-24313) Optimise stats collection for file sizes on cloud storage

2022-10-06 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-24313?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa resolved HIVE-24313. --- Resolution: Fixed [#3639|https://github.com/apache/hive/pull/3639] was merged to master.

[jira] [Commented] (HIVE-26582) Cartesian join fails if the query has an empty table when cartesian product edge is used

2022-10-04 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26582?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17612573#comment-17612573 ] Krisztian Kasa commented on HIVE-26582: --- [~zabetak] no worries. In theory using

[jira] [Commented] (HIVE-26582) Cartesian join fails if the query has an empty table when cartesian product edge is used

2022-10-03 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26582?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17612309#comment-17612309 ] Krisztian Kasa commented on HIVE-26582: --- [~zabetak]  I don't think HIVE-26524 helps here because we

[jira] [Commented] (HIVE-26524) Use Calcite to remove sections of a query plan known never produces rows

2022-10-03 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26524?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17612291#comment-17612291 ] Krisztian Kasa commented on HIVE-26524: --- The [PR #3588|https://github.com/apache/hive/pull/3588]

[jira] [Assigned] (HIVE-26578) Enable Iceberg storage format for materialized views

2022-09-30 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26578?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa reassigned HIVE-26578: - > Enable Iceberg storage format for materialized views >

[jira] [Resolved] (HIVE-26498) Implement MV maintenance with Iceberg sources using full rebuild

2022-09-12 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26498?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa resolved HIVE-26498. --- Resolution: Fixed Pushed to master. Thanks [~lpinter] for review. > Implement MV

[jira] [Updated] (HIVE-26524) Use Calcite to remove sections of a query plan known never produces rows

2022-09-09 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26524?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa updated HIVE-26524: -- Description: Calcite has a set of rules to remove sections of a query plan known never

[jira] [Assigned] (HIVE-26524) Use Calcite to remove sections of a query plan known never produces rows

2022-09-08 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26524?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa reassigned HIVE-26524: - > Use Calcite to remove sections of a query plan known never produces rows >

[jira] [Comment Edited] (HIVE-17342) Where condition with 1=0 should be treated similar to limit 0

2022-08-30 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-17342?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17598180#comment-17598180 ] Krisztian Kasa edited comment on HIVE-17342 at 8/31/22 5:41 AM:

[jira] [Resolved] (HIVE-17342) Where condition with 1=0 should be treated similar to limit 0

2022-08-30 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-17342?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa resolved HIVE-17342. --- Resolution: Information Provided > Where condition with 1=0 should be treated similar to

[jira] [Commented] (HIVE-17342) Where condition with 1=0 should be treated similar to limit 0

2022-08-30 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-17342?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17598180#comment-17598180 ] Krisztian Kasa commented on HIVE-17342: --- [~amansinha] Found that in some cases CBO ends up with a

[jira] [Comment Edited] (HIVE-17342) Where condition with 1=0 should be treated similar to limit 0

2022-08-30 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-17342?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17597866#comment-17597866 ] Krisztian Kasa edited comment on HIVE-17342 at 8/30/22 1:25 PM: This

[jira] [Commented] (HIVE-17342) Where condition with 1=0 should be treated similar to limit 0

2022-08-30 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-17342?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17597866#comment-17597866 ] Krisztian Kasa commented on HIVE-17342: --- This seems to be fixed on the master branch: The plan of

[jira] [Assigned] (HIVE-17342) Where condition with 1=0 should be treated similar to limit 0

2022-08-30 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-17342?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa reassigned HIVE-17342: - Assignee: Krisztian Kasa > Where condition with 1=0 should be treated similar to limit

[jira] [Assigned] (HIVE-26498) Implement MV maintenance with Iceberg sources using full rebuild

2022-08-25 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26498?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa reassigned HIVE-26498: - > Implement MV maintenance with Iceberg sources using full rebuild >

[jira] [Assigned] (HIVE-26497) Support materialized views on Iceberg source tables

2022-08-25 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26497?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa reassigned HIVE-26497: - > Support materialized views on Iceberg source tables >

[jira] [Resolved] (HIVE-26452) NPE when converting join to mapjoin and join column referenced more than once

2022-08-08 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26452?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa resolved HIVE-26452. --- Resolution: Fixed Pushed to master. Thanks [~amansinha100] and [~ayushtkn] for review. >

[jira] [Assigned] (HIVE-26452) NPE when converting join to mapjoin and join column referenced more than once

2022-08-05 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26452?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa reassigned HIVE-26452: - > NPE when converting join to mapjoin and join column referenced more than once >

[jira] [Resolved] (HIVE-26417) Iceberg integration: disable update and merge iceberg table when split update is off

2022-07-22 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26417?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa resolved HIVE-26417. --- Resolution: Fixed Pushed to master. Thanks [~pvary] for review. > Iceberg integration:

[jira] [Resolved] (HIVE-26375) Invalid materialized view after rebuild if source table was compacted

2022-07-22 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26375?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa resolved HIVE-26375. --- Resolution: Fixed Pushed to master. Thanks [~lpinter] and [~amansinha100] for review. >

[jira] [Assigned] (HIVE-26417) Iceberg integration: disable update and merge iceberg table when split update is off

2022-07-20 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26417?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa reassigned HIVE-26417: - > Iceberg integration: disable update and merge iceberg table when split update > is off >

[jira] [Resolved] (HIVE-26385) Iceberg integration: Implement merge into iceberg table

2022-07-20 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26385?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa resolved HIVE-26385. --- Resolution: Fixed Pushed to master. Thanks [~pvary] for review. > Iceberg integration:

[jira] [Updated] (HIVE-26385) Iceberg integration: Implement merge into iceberg table

2022-07-12 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26385?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa updated HIVE-26385: -- Component/s: File Formats > Iceberg integration: Implement merge into iceberg table >

[jira] [Assigned] (HIVE-26385) Iceberg integration: Implement merge into iceberg table

2022-07-12 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26385?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa reassigned HIVE-26385: - > Iceberg integration: Implement merge into iceberg table >

[jira] [Resolved] (HIVE-26371) Constant propagation does not evaluate constraint expressions at merge when CBO is enabled

2022-07-08 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26371?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa resolved HIVE-26371. --- Resolution: Fixed Pushed to master. Thanks [~zabetak] for review. > Constant propagation

[jira] [Resolved] (HIVE-26372) QTests depend on mysql docker image are fail

2022-07-07 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26372?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa resolved HIVE-26372. --- Resolution: Fixed It seems mysql prints less details to stderr in 5.7.38. I don't know if

[jira] [Updated] (HIVE-26370) Check stats are up-to-date when getting materialized view state

2022-07-07 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26370?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa updated HIVE-26370: -- Labels: (was: pull-request-available) > Check stats are up-to-date when getting materialized

[jira] [Commented] (HIVE-26370) Check stats are up-to-date when getting materialized view state

2022-07-07 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26370?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17563594#comment-17563594 ] Krisztian Kasa commented on HIVE-26370: --- Seems that relying on statistic only when querying MV

[jira] [Assigned] (HIVE-26375) Invalid materialized view after rebuild if source table was compacted

2022-07-06 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26375?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa reassigned HIVE-26375: - > Invalid materialized view after rebuild if source table was compacted >

[jira] [Assigned] (HIVE-26372) QTests depend on mysql docker image are fail

2022-07-06 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26372?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa reassigned HIVE-26372: - > QTests depend on mysql docker image are fail >

[jira] [Updated] (HIVE-26371) Constant propagation does not evaluate constraint expressions at merge when CBO is enabled

2022-07-06 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26371?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa updated HIVE-26371: -- Description: Prior HIVE-23089 check and not null constraint violations may detected faster

[jira] [Assigned] (HIVE-26371) Constant propagation does not evaluate constraint expressions at merge when CBO is enabled

2022-07-06 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26371?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa reassigned HIVE-26371: - > Constant propagation does not evaluate constraint expressions at merge when > CBO is

[jira] [Assigned] (HIVE-26370) Check stats are up-to-date when getting materialized view state

2022-07-05 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26370?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa reassigned HIVE-26370: - > Check stats are up-to-date when getting materialized view state >

[jira] [Resolved] (HIVE-26365) Remove column statistics collection task from merge statement plan

2022-06-30 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26365?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa resolved HIVE-26365. --- Resolution: Fixed Pushed to master. Thanks [~pvary], [~amansinha100], [~asolimando] for

[jira] [Commented] (HIVE-26365) Remove column statistics collection task from merge statement plan

2022-06-30 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26365?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17560928#comment-17560928 ] Krisztian Kasa commented on HIVE-26365: --- [~zabetak]  Yes, this is a perf improvement. Currently we

[jira] [Commented] (HIVE-26365) Remove column statistics collection task from merge statement plan

2022-06-29 Thread Krisztian Kasa (Jira)
Title: Message Title Krisztian Kasa

[jira] [Assigned] (HIVE-26365) Remove column statistics collection task from merge statement plan

2022-06-29 Thread Krisztian Kasa (Jira)
Title: Message Title Krisztian Kasa

[jira] [Resolved] (HIVE-26361) Merge statement compile fails if split update is off

2022-06-28 Thread Krisztian Kasa (Jira)
Title: Message Title Krisztian Kasa

[jira] [Updated] (HIVE-26319) Iceberg integration: Perform update split early

2022-06-28 Thread Krisztian Kasa (Jira)
Title: Message Title Krisztian Kasa

[jira] [Resolved] (HIVE-26319) Iceberg integration: Perform update split early

2022-06-28 Thread Krisztian Kasa (Jira)
Title: Message Title Krisztian Kasa

[jira] [Work started] (HIVE-26361) Merge statement compile fails if split update is off

2022-06-28 Thread Krisztian Kasa (Jira)
Title: Message Title Krisztian Kasa

[jira] [Updated] (HIVE-26361) Merge statement compile fails if split update is off

2022-06-28 Thread Krisztian Kasa (Jira)
Title: Message Title Krisztian Kasa

[jira] [Updated] (HIVE-26361) Merge statement compile fails if split update is off

2022-06-28 Thread Krisztian Kasa (Jira)
Title: Message Title Krisztian Kasa

[jira] [Assigned] (HIVE-26361) Merge statement compile fails if split update is off

2022-06-28 Thread Krisztian Kasa (Jira)
Title: Message Title Krisztian Kasa

[jira] [Resolved] (HIVE-26340) Vectorized PTF operator fails if query has upper case window function

2022-06-17 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26340?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa resolved HIVE-26340. --- Resolution: Fixed Pushed to master! Thanks [~abstractdog] for review. > Vectorized PTF

<    1   2   3   4   5   6   7   8   9   10   >