[jira] [Resolved] (HIVE-28253) Unable to set the value for hplsql.onerror in hplsql mode.

2024-05-13 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-28253?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa resolved HIVE-28253. --- Fix Version/s: 4.1.0 Resolution: Fixed Merged to master. Thanks [~Dayakar] for the

[jira] [Resolved] (HIVE-28247) Execute immediate 'select count(*) from tbl' throwing ClassCastException in hplsql mode.

2024-05-07 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-28247?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa resolved HIVE-28247. --- Fix Version/s: 4.1.0 Resolution: Fixed Merged to master. Thanks [~Dayakar] for the

[jira] [Resolved] (HIVE-28215) Signalling CONDITION HANDLER is not working in HPLSQL.

2024-05-06 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-28215?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa resolved HIVE-28215. --- Fix Version/s: 4.1.0 Resolution: Fixed Merged to master. Thanks [~Dayakar] for the

[jira] [Commented] (HIVE-28213) Incorrect results after insert-select from similar bucketed source & target table

2024-05-02 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-28213?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17842956#comment-17842956 ] Krisztian Kasa commented on HIVE-28213: --- IMHO {{hive.tez.bucket.pruning}} shouldn't be allowed

[jira] [Resolved] (HIVE-28173) Issues with staging dirs with materialized views on HDFS encrypted table

2024-05-02 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-28173?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa resolved HIVE-28173. --- Fix Version/s: 4.1.0 Resolution: Fixed Merged to master. Thanks [~scarlin] for the

[jira] [Resolved] (HIVE-28214) HPLSQL not using the hive variables passed through beeline using --hivevar option

2024-05-02 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-28214?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa resolved HIVE-28214. --- Fix Version/s: 4.1.0 Resolution: Fixed Merged to master. Thanks [~Dayakar]  for the

[jira] [Resolved] (HIVE-28203) Fix qtest mv_iceberg_orc5.q

2024-04-18 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-28203?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa resolved HIVE-28203. --- Fix Version/s: 4.1.0 Resolution: Fixed Merged to master. Thanks [~zhangbutao] for the

[jira] [Assigned] (HIVE-28203) Fix qtest mv_iceberg_orc5.q

2024-04-18 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-28203?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa reassigned HIVE-28203: - Assignee: Butao Zhang > Fix qtest mv_iceberg_orc5.q > --- > >

[jira] [Resolved] (HIVE-28127) Exception when rebuilding materialized view with calculated columns on iceberg sources

2024-04-16 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-28127?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa resolved HIVE-28127. --- Fix Version/s: 4.1.0 Resolution: Fixed Merged to master. Thanks [~dkuzmenko] for

[jira] [Commented] (HIVE-28082) HiveAggregateReduceFunctionsRule could generate an inconsistent result

2024-04-15 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-28082?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17837244#comment-17837244 ] Krisztian Kasa commented on HIVE-28082: --- Some more details about the issue: {code} explain cbo

[jira] [Assigned] (HIVE-28173) Issues with staging dirs with materialized views on HDFS encrypted table

2024-04-12 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-28173?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa reassigned HIVE-28173: - Assignee: Steve Carlin > Issues with staging dirs with materialized views on HDFS

[jira] [Resolved] (HIVE-28126) Use added record count in cost model when rebuilding materialized view stored by iceberg

2024-04-09 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-28126?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa resolved HIVE-28126. --- Fix Version/s: 4.1.0 Resolution: Fixed Merged to master. Thanks [~dkuzmenko]  and

[jira] [Updated] (HIVE-27366) Incorrect incremental rebuild mode shown of materialized view with Iceberg sources

2024-04-02 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-27366?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa updated HIVE-27366: -- Parent: HIVE-26497 Issue Type: Sub-task (was: Bug) > Incorrect incremental rebuild

[jira] [Updated] (HIVE-27307) NPE when generating incremental rebuild plan of materialized view with empty Iceberg source table

2024-04-02 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-27307?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa updated HIVE-27307: -- Parent: HIVE-26497 Issue Type: Sub-task (was: Bug) > NPE when generating incremental

[jira] [Updated] (HIVE-27101) Support incremental materialized view rebuild when Iceberg source tables have insert operation only.

2024-04-02 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-27101?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa updated HIVE-27101: -- Parent: HIVE-26497 Issue Type: Sub-task (was: Improvement) > Support incremental

[jira] [Updated] (HIVE-27867) Incremental materialized view throws NPE whew Iceberg source table is empty

2024-04-02 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-27867?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa updated HIVE-27867: -- Parent: HIVE-26497 Issue Type: Sub-task (was: Bug) > Incremental materialized view

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

2024-04-02 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: -- Parent: HIVE-26497 Issue Type: Sub-task (was: Bug) > Alter materialized view enable

[jira] [Updated] (HIVE-28127) Exception when rebuilding materialized view with calculated columns on iceberg sources

2024-04-02 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-28127?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa updated HIVE-28127: -- Parent: HIVE-26497 Issue Type: Sub-task (was: Bug) > Exception when rebuilding

[jira] [Updated] (HIVE-28126) Use added record count in cost model when rebuilding materialized view stored by iceberg

2024-04-02 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-28126?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa updated HIVE-28126: -- Parent: HIVE-26497 Issue Type: Sub-task (was: Improvement) > Use added record count

[jira] [Created] (HIVE-28127) Exception when rebuilding materialized view with calculated columns on iceberg sources

2024-03-19 Thread Krisztian Kasa (Jira)
Krisztian Kasa created HIVE-28127: - Summary: Exception when rebuilding materialized view with calculated columns on iceberg sources Key: HIVE-28127 URL: https://issues.apache.org/jira/browse/HIVE-28127

[jira] [Updated] (HIVE-28126) Use added record count in cost model when rebuilding materialized view stored by iceberg

2024-03-19 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-28126?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa updated HIVE-28126: -- Summary: Use added record count in cost model when rebuilding materialized view stored by

[jira] [Created] (HIVE-28126) Use added row count in cost model when rebuilding materialized view stored by iceberg

2024-03-19 Thread Krisztian Kasa (Jira)
Krisztian Kasa created HIVE-28126: - Summary: Use added row count in cost model when rebuilding materialized view stored by iceberg Key: HIVE-28126 URL: https://issues.apache.org/jira/browse/HIVE-28126

[jira] [Resolved] (HIVE-28006) Materialized view with aggregate function incorrectly shows it allows incremental rebuild

2024-03-11 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-28006?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa resolved HIVE-28006. --- Fix Version/s: 4.1.0 Resolution: Fixed Merged to master. Thanks [~abstractdog] and

[jira] [Updated] (HIVE-28098) Fails to copy empty column statistics of materialized CTE

2024-03-11 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-28098?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa updated HIVE-28098: -- Fix Version/s: 4.1.0 Resolution: Fixed Status: Resolved (was: Patch

[jira] [Resolved] (HIVE-28076) Selecting data from a bucketed table with decimal column type throwing NPE.

2024-03-05 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-28076?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa resolved HIVE-28076. --- Fix Version/s: 4.1.0 Resolution: Fixed Merged to master. Thanks [~Dayakar] for the

[jira] [Resolved] (HIVE-27490) HPL/SQL says it support default value for parameters but not considering them when no value is passed

2024-02-29 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-27490?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa resolved HIVE-27490. --- Fix Version/s: 4.1.0 Resolution: Fixed Merged to master. Thanks [~Dayakar] for the

[jira] [Updated] (HIVE-28080) Propagate statistics from a source table to the materialized CTE

2024-02-27 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-28080?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa updated HIVE-28080: -- Fix Version/s: 4.1.0 Resolution: Fixed Status: Resolved (was: Patch

[jira] [Updated] (HIVE-27636) Exception in HiveMaterializedViewsRegistry is leaving staging directories behind

2024-02-22 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-27636?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa updated HIVE-27636: -- Description: In case of any exception while query parsing in

[jira] [Updated] (HIVE-27924) Incremental rebuild goes wrong when inserts and deletes overlap between the source tables

2024-02-21 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-27924?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa updated HIVE-27924: -- Fix Version/s: 4.1.0 Resolution: Fixed Status: Resolved (was: Patch

[jira] [Commented] (HIVE-27924) Incremental rebuild goes wrong when inserts and deletes overlap between the source tables

2024-02-21 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-27924?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17819506#comment-17819506 ] Krisztian Kasa commented on HIVE-27924: --- Merged to master. Thanks [~dkuzmenko] for review the patch

[jira] [Resolved] (HIVE-28050) Disable Incremental non aggregated materialized view rebuild in presence of delete operations

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

[jira] [Commented] (HIVE-28050) Disable Incremental non aggregated materialized view rebuild in presence of delete operations

2024-02-07 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-28050?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17815523#comment-17815523 ] Krisztian Kasa commented on HIVE-28050: --- [~zabetak] Another example without join: {code} set

[jira] [Commented] (HIVE-28050) Disable Incremental non aggregated materialized view rebuild in presence of delete operations

2024-02-07 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-28050?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17815276#comment-17815276 ] Krisztian Kasa commented on HIVE-28050: --- [~zabetak] Updated the description with an example. The

[jira] [Updated] (HIVE-28050) Disable Incremental non aggregated materialized view rebuild in presence of delete operations

2024-02-07 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-28050?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa updated HIVE-28050: -- Description: To support incremental rebuild of materialized views which definition does not

[jira] [Updated] (HIVE-28050) Disable Incremental non aggregated materialized view rebuild in presence of delete operations

2024-02-07 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-28050?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa updated HIVE-28050: -- Description: To support incremental rebuild of materialized views which definition does not

[jira] [Resolved] (HIVE-28054) SemanticException for join condition in subquery

2024-02-07 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-28054?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa resolved HIVE-28054. --- Fix Version/s: 4.1.0 Resolution: Fixed Merged to master. Thanks [~soumyakanti.das]

[jira] [Resolved] (HIVE-28000) Hive QL : "not in" clause gives incorrect results when type coercion cannot take place.

2024-01-31 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-28000?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa resolved HIVE-28000. --- Fix Version/s: 4.1.0 Resolution: Fixed Merged to master. Thanks [~AnmolSun] for the

[jira] [Assigned] (HIVE-28000) Hive QL : "not in" clause gives incorrect results when type coercion cannot take place.

2024-01-31 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-28000?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa reassigned HIVE-28000: - Assignee: Anmol Sundaram > Hive QL : "not in" clause gives incorrect results when type

[jira] [Created] (HIVE-28050) Disable Incremental non aggregated materialized view rebuild in presence of delete operations

2024-01-30 Thread Krisztian Kasa (Jira)
Krisztian Kasa created HIVE-28050: - Summary: Disable Incremental non aggregated materialized view rebuild in presence of delete operations Key: HIVE-28050 URL: https://issues.apache.org/jira/browse/HIVE-28050

[jira] [Resolved] (HIVE-28009) Shared work optimizer ignores schema merge setting in case of virtual column difference

2024-01-22 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-28009?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa resolved HIVE-28009. --- Fix Version/s: 4.1.0 Resolution: Fixed Merged to master. Thanks [~dkuzmenko] for

[jira] [Resolved] (HIVE-27489) HPL/SQL does not support table aliases on column names in loops

2024-01-21 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-27489?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa resolved HIVE-27489. --- Fix Version/s: 4.1.0 Resolution: Fixed Merged to master. Thanks [~Dayakar] for the

[jira] [Created] (HIVE-28009) Shared work optimizer ignores schema merge setting in case of virtual column difference

2024-01-18 Thread Krisztian Kasa (Jira)
Krisztian Kasa created HIVE-28009: - Summary: Shared work optimizer ignores schema merge setting in case of virtual column difference Key: HIVE-28009 URL: https://issues.apache.org/jira/browse/HIVE-28009

[jira] [Created] (HIVE-28006) Materialized view with aggregate function incorrectly shows it allows incremental rebuild

2024-01-17 Thread Krisztian Kasa (Jira)
Krisztian Kasa created HIVE-28006: - Summary: Materialized view with aggregate function incorrectly shows it allows incremental rebuild Key: HIVE-28006 URL: https://issues.apache.org/jira/browse/HIVE-28006

[jira] [Resolved] (HIVE-27492) HPL/SQL built-in functions like sysdate not working

2024-01-14 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-27492?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa resolved HIVE-27492. --- Fix Version/s: 4.1.0 Resolution: Fixed Merged to master. Thanks [~Dayakar] for the

[jira] [Updated] (HIVE-27948) Wrong results when using materialized views with non-deterministic/dynamic functions

2024-01-08 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-27948?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa updated HIVE-27948: -- Fix Version/s: 4.1.0 Resolution: Fixed Status: Resolved (was: Patch

[jira] [Updated] (HIVE-27948) Wrong results when using materialized views with non-deterministic/dynamic functions

2024-01-08 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-27948?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa updated HIVE-27948: -- Component/s: Materialized views > Wrong results when using materialized views with

[jira] [Updated] (HIVE-27161) MetaException when executing CTAS query in Druid storage handler

2023-12-21 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-27161?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa updated HIVE-27161: -- Fix Version/s: 4.1.0 Resolution: Fixed Status: Resolved (was: Patch

[jira] [Resolved] (HIVE-27876) Incorrect query results on tables with ClusterBy & SortBy

2023-12-20 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-27876?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa resolved HIVE-27876. --- Fix Version/s: 4.1.0 Resolution: Fixed Megred to master. Thanks [~rameshkumar] for

[jira] [Updated] (HIVE-27924) Incremental rebuild goes wrong when inserts and deletes overlap between the source tables

2023-12-19 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-27924?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa updated HIVE-27924: -- Status: Patch Available (was: In Progress) > Incremental rebuild goes wrong when inserts and

[jira] [Resolved] (HIVE-27428) CTAS fails with SemanticException when join subquery has complex type column and false filter predicate

2023-12-17 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-27428?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa resolved HIVE-27428. --- Fix Version/s: 4.1.0 Resolution: Resolved Resolved by HIVE-27690 > CTAS fails with

[jira] [Resolved] (HIVE-27690) Handle casting NULL literal to complex type

2023-12-17 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-27690?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa resolved HIVE-27690. --- Fix Version/s: 4.0.0 Resolution: Fixed Merged to master. Thanks [~lvegh] for review.

[jira] [Updated] (HIVE-27690) Handle casting NULL literal to complex type

2023-12-17 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-27690?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa updated HIVE-27690: -- Fix Version/s: 4.1.0 (was: 4.0.0) > Handle casting NULL literal to

[jira] [Commented] (HIVE-27948) Wrong results when using materialized views with non-deterministic/dynamic functions

2023-12-15 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-27948?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17797157#comment-17797157 ] Krisztian Kasa commented on HIVE-27948: --- The general rule is if there is any error message during

[jira] [Assigned] (HIVE-27948) Wrong results when using materialized views with non-deterministic/dynamic functions

2023-12-14 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-27948?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa reassigned HIVE-27948: - Assignee: Krisztian Kasa > Wrong results when using materialized views with

[jira] [Resolved] (HIVE-27446) Exception when rebuild materialized view incrementally in presence of delete operations

2023-12-12 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-27446?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa resolved HIVE-27446. --- Fix Version/s: 4.0.0 Resolution: Fixed Merged to master. Thanks [~lvegh] for review.

[jira] [Commented] (HIVE-27924) Incremental rebuild goes wrong when inserts and deletes overlap between the source tables

2023-12-12 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-27924?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17795740#comment-17795740 ] Krisztian Kasa commented on HIVE-27924: --- A draft patch created to address the issue when the MV

[jira] [Work started] (HIVE-27924) Incremental rebuild goes wrong when inserts and deletes overlap between the source tables

2023-12-05 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-27924?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Work on HIVE-27924 started by Krisztian Kasa. - > Incremental rebuild goes wrong when inserts and deletes overlap between the

[jira] [Assigned] (HIVE-27924) Incremental rebuild goes wrong when inserts and deletes overlap between the source tables

2023-12-05 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-27924?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa reassigned HIVE-27924: - Assignee: Krisztian Kasa > Incremental rebuild goes wrong when inserts and deletes

[jira] [Assigned] (HIVE-26505) Case When Some result data is lost when there are common column conditions and partitioned column conditions

2023-11-30 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26505?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa reassigned HIVE-26505: - Assignee: Krisztian Kasa > Case When Some result data is lost when there are common

[jira] [Resolved] (HIVE-27867) Incremental materialized view throws NPE whew Iceberg source table is empty

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

[jira] [Commented] (HIVE-26505) Case When Some result data is lost when there are common column conditions and partitioned column conditions

2023-11-27 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26505?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17790021#comment-17790021 ] Krisztian Kasa commented on HIVE-26505: --- This is the expression sent by {{PartitionPruner}} to HMS

[jira] [Comment Edited] (HIVE-27876) Incorrect query results on tables with ClusterBy & SortBy

2023-11-23 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-27876?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17789050#comment-17789050 ] Krisztian Kasa edited comment on HIVE-27876 at 11/23/23 10:10 AM: -- I

[jira] [Commented] (HIVE-27876) Incorrect query results on tables with ClusterBy & SortBy

2023-11-23 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-27876?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17789050#comment-17789050 ] Krisztian Kasa commented on HIVE-27876: --- I found another data correctness issue regarding this

[jira] [Commented] (HIVE-27876) Incorrect query results on tables with ClusterBy & SortBy

2023-11-23 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-27876?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17789045#comment-17789045 ] Krisztian Kasa commented on HIVE-27876: --- [~rameshkumar] 1. Based on cwiki sort by ensures the

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

2023-11-22 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26618?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa resolved HIVE-26618. --- Resolution: Won't Fix > Add setting to turn on/off removing sections of a query plan known

[jira] [Resolved] (HIVE-27788) Exception when join has 2 Group By operators in the same branch in the same reducer

2023-11-21 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-27788?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa resolved HIVE-27788. --- Resolution: Fixed Merged to master. Thanks [~zabetak] for review. > Exception when join has

[jira] [Commented] (HIVE-27876) Incorrect query results on tables with ClusterBy & SortBy

2023-11-20 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-27876?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17788031#comment-17788031 ] Krisztian Kasa commented on HIVE-27876: --- The query in the description has a plan: {code} POSTHOOK:

[jira] [Resolved] (HIVE-27491) HPL/SQL does not allow variables in update statements

2023-11-19 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-27491?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa resolved HIVE-27491. --- Resolution: Fixed Merged to master. Thanks [~Dayakar] for the patch. > HPL/SQL does not

[jira] [Commented] (HIVE-26660) TPC-DS query 71 returns wrong results

2023-11-17 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26660?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17787207#comment-17787207 ] Krisztian Kasa commented on HIVE-26660: --- [~glapark] 1. Could you please describe how HIVE-26986

[jira] [Updated] (HIVE-27788) Exception when join has 2 Group By operators in the same branch in the same reducer

2023-11-16 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-27788?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa updated HIVE-27788: -- Summary: Exception when join has 2 Group By operators in the same branch in the same reducer

[jira] [Resolved] (HIVE-27828) Iceberg integration: enable copy on write update when split update is on

2023-11-16 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-27828?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa resolved HIVE-27828. --- Resolution: Fixed Merged to master. Thanks [~dkuzmenko] for review. > Iceberg integration:

[jira] [Commented] (HIVE-27788) Exception in Sort Merge join with Group By + PTF Operator

2023-11-15 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-27788?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17786353#comment-17786353 ] Krisztian Kasa commented on HIVE-27788: --- [~zabetak], [~amansinha] I think the summary of this jira

[jira] [Resolved] (HIVE-27533) Incorrect FOREIGN KEY constraints in SHOW CREATE TABLE

2023-11-14 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-27533?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa resolved HIVE-27533. --- Resolution: Fixed Merged to master. Thanks [~soumyakanti.das]  for the patch. > Incorrect

[jira] [Commented] (HIVE-26986) A DAG created by OperatorGraph is not equal to the Tez DAG.

2023-11-10 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26986?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17784956#comment-17784956 ] Krisztian Kasa commented on HIVE-26986: --- [~seonggon]  1. It is not clear why adding extra

[jira] [Work started] (HIVE-27867) Incremental materialized view throws NPE whew Iceberg source table is empty

2023-11-09 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-27867?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Work on HIVE-27867 started by Krisztian Kasa. - > Incremental materialized view throws NPE whew Iceberg source table is empty

[jira] [Created] (HIVE-27867) Incremental materialized view throws NPE whew Iceberg source table is empty

2023-11-09 Thread Krisztian Kasa (Jira)
Krisztian Kasa created HIVE-27867: - Summary: Incremental materialized view throws NPE whew Iceberg source table is empty Key: HIVE-27867 URL: https://issues.apache.org/jira/browse/HIVE-27867 Project:

[jira] [Updated] (HIVE-27867) Incremental materialized view throws NPE whew Iceberg source table is empty

2023-11-09 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-27867?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa updated HIVE-27867: -- Labels: iceberg materializedviews (was: ) > Incremental materialized view throws NPE whew

[jira] [Assigned] (HIVE-27788) Exception in Sort Merge join with Group By + PTF Operator

2023-11-08 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-27788?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa reassigned HIVE-27788: - Assignee: Krisztian Kasa > Exception in Sort Merge join with Group By + PTF Operator >

[jira] [Comment Edited] (HIVE-27533) Incorrect FOREIGN KEY constraints in SHOW CREATE TABLE

2023-11-07 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-27533?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17783601#comment-17783601 ] Krisztian Kasa edited comment on HIVE-27533 at 11/7/23 12:26 PM: -

[jira] [Commented] (HIVE-27533) Incorrect FOREIGN KEY constraints in SHOW CREATE TABLE

2023-11-07 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-27533?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17783601#comment-17783601 ] Krisztian Kasa commented on HIVE-27533: --- [~soumyakanti.das]  Could you please add the full repro

[jira] [Resolved] (HIVE-27531) Unparse identifiers in show create table output

2023-11-07 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-27531?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa resolved HIVE-27531. --- Resolution: Fixed Merged to master. Thanks [~soumyakanti.das] for the patch. > Unparse

[jira] [Created] (HIVE-27828) Iceberg integration: enable copy on write update when split update is on

2023-10-27 Thread Krisztian Kasa (Jira)
Krisztian Kasa created HIVE-27828: - Summary: Iceberg integration: enable copy on write update when split update is on Key: HIVE-27828 URL: https://issues.apache.org/jira/browse/HIVE-27828 Project:

[jira] [Commented] (HIVE-27788) Exception in Sort Merge join with Group By + PTF Operator

2023-10-17 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-27788?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17776189#comment-17776189 ] Krisztian Kasa commented on HIVE-27788: --- Another repro with 3 records and inner join {code} set

[jira] [Resolved] (HIVE-27761) Compilation of nested CTEs throws SemanticException

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

[jira] [Commented] (HIVE-27754) Query Filter with OR condition updates every record in the table

2023-10-02 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-27754?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17771097#comment-17771097 ] Krisztian Kasa commented on HIVE-27754: --- If the expression in the where clause has logical

[jira] [Commented] (HIVE-27754) Query Filter with OR condition updates every record in the table

2023-09-28 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-27754?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17770037#comment-17770037 ] Krisztian Kasa commented on HIVE-27754: --- {code} set hive.cbo.fallback.strategy=NEVER; {code} Can be

[jira] [Commented] (HIVE-27754) Query Filter with OR condition updates every record in the table

2023-09-28 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-27754?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17770032#comment-17770032 ] Krisztian Kasa commented on HIVE-27754: --- A simple repro with a query: {code}  create table t1 (a

[jira] [Resolved] (HIVE-27727) Materialized view query rewrite fails if query has decimal derived aggregate

2023-09-26 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-27727?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa resolved HIVE-27727. --- Resolution: Fixed Merged to master. Thanks [~zabetak] for review. > Materialized view query

[jira] [Updated] (HIVE-27727) Materialized view query rewrite fails if query has decimal derived aggregate

2023-09-25 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-27727?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa updated HIVE-27727: -- Description: {code} create table t1 (a int, b decimal(3,2)) stored as orc TBLPROPERTIES

[jira] [Updated] (HIVE-27727) Materialized view query rewrite fails if query has decimal derived aggregate

2023-09-25 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-27727?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa updated HIVE-27727: -- Labels: cbo materializedviews (was: ) > Materialized view query rewrite fails if query has

[jira] [Assigned] (HIVE-27727) Materialized view query rewrite fails if query has decimal derived aggregate

2023-09-25 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-27727?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa reassigned HIVE-27727: - Assignee: Krisztian Kasa > Materialized view query rewrite fails if query has decimal

[jira] [Created] (HIVE-27727) Materialized view query rewrite fails if query has decimal derived aggregate

2023-09-25 Thread Krisztian Kasa (Jira)
Krisztian Kasa created HIVE-27727: - Summary: Materialized view query rewrite fails if query has decimal derived aggregate Key: HIVE-27727 URL: https://issues.apache.org/jira/browse/HIVE-27727

[jira] [Resolved] (HIVE-27558) HBase table query does not push BETWEEN predicate to storage layer

2023-09-15 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-27558?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa resolved HIVE-27558. --- Resolution: Fixed Merged to master. Thanks [~Dayakar] for the patch. > HBase table query

[jira] [Updated] (HIVE-27558) HBase table query does not push BETWEEN predicate to storage layer

2023-09-15 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-27558?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa updated HIVE-27558: -- Fix Version/s: 4.0.0 > HBase table query does not push BETWEEN predicate to storage layer >

[jira] [Resolved] (HIVE-27138) MapJoinOperator throws NPE when computing OuterJoin with filter expressions on small table

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

[jira] [Assigned] (HIVE-27138) MapJoinOperator throws NPE when computing OuterJoin with filter expressions on small table

2023-09-15 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-27138?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa reassigned HIVE-27138: - Assignee: Seonggon Namgung (was: Sönke Liebau) > MapJoinOperator throws NPE when

[jira] [Updated] (HIVE-24606) Multi-stage materialized CTEs can lose intermediate data

2023-09-15 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-24606?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa updated HIVE-24606: -- Fix Version/s: 4.0.0 > Multi-stage materialized CTEs can lose intermediate data >

[jira] [Resolved] (HIVE-24606) Multi-stage materialized CTEs can lose intermediate data

2023-09-15 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-24606?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa resolved HIVE-24606. --- Resolution: Fixed Merged [4363|https://github.com/apache/hive/pull/4363] to master. Thanks

[jira] [Created] (HIVE-27690) Handle casting NULL literal to complex type

2023-09-14 Thread Krisztian Kasa (Jira)
Krisztian Kasa created HIVE-27690: - Summary: Handle casting NULL literal to complex type Key: HIVE-27690 URL: https://issues.apache.org/jira/browse/HIVE-27690 Project: Hive Issue Type:

[jira] [Resolved] (HIVE-27648) CREATE TABLE with CHECK constraint fails with SemanticException

2023-09-13 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-27648?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa resolved HIVE-27648. --- Resolution: Fixed Merged to master. Thanks [~dkuzmenko] and [~soumyakanti.das] for review.

  1   2   3   4   5   6   7   8   9   10   >