[jira] [Commented] (HIVE-29084) CBO returns incorrect results when WHERE clause filters multiple LATERAL VIEW explode cross-products

2025-07-15 Thread Stamatis Zampetakis (Jira)
[ https://issues.apache.org/jira/browse/HIVE-29084?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18007400#comment-18007400 ] Stamatis Zampetakis commented on HIVE-29084: Thanks for the analysis Konstant

[jira] [Resolved] (HIVE-29032) Enhance qt:database option to expose connection properties in qfiles

2025-07-15 Thread Denys Kuzmenko (Jira)
[ https://issues.apache.org/jira/browse/HIVE-29032?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Denys Kuzmenko resolved HIVE-29032. --- Fix Version/s: 4.2.0 Resolution: Fixed > Enhance qt:database option to expose connecti

[jira] [Commented] (HIVE-29032) Enhance qt:database option to expose connection properties in qfiles

2025-07-15 Thread Denys Kuzmenko (Jira)
[ https://issues.apache.org/jira/browse/HIVE-29032?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18007395#comment-18007395 ] Denys Kuzmenko commented on HIVE-29032: --- Merged to master Thanks [~zabetak] for im

[jira] [Resolved] (HIVE-29087) Add MAX_LIFE_TIME configuration for hikaricp connection pool

2025-07-15 Thread Ayush Saxena (Jira)
[ https://issues.apache.org/jira/browse/HIVE-29087?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ayush Saxena resolved HIVE-29087. - Fix Version/s: Not Applicable Resolution: Not A Problem > Add MAX_LIFE_TIME configuration

[jira] [Updated] (HIVE-29094) Unifying the metastore-site.xml File for HMS Docker and HMS tar

2025-07-15 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/HIVE-29094?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated HIVE-29094: -- Labels: pull-request-available (was: ) > Unifying the metastore-site.xml File for HMS Docker a

[jira] [Created] (HIVE-29094) Unifying the metastore-site.xml File for HMS Docker and HMS tar

2025-07-15 Thread Butao Zhang (Jira)
Butao Zhang created HIVE-29094: -- Summary: Unifying the metastore-site.xml File for HMS Docker and HMS tar Key: HIVE-29094 URL: https://issues.apache.org/jira/browse/HIVE-29094 Project: Hive Iss

[jira] [Updated] (HIVE-29084) CBO returns incorrect results when WHERE clause filters multiple LATERAL VIEW explode cross-products

2025-07-15 Thread Konstantin Bereznyakov (Jira)
[ https://issues.apache.org/jira/browse/HIVE-29084?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Konstantin Bereznyakov updated HIVE-29084: -- Attachment: hive_29084.q.out > CBO returns incorrect results when WHERE clause

[jira] [Updated] (HIVE-29084) CBO returns incorrect results when WHERE clause filters multiple LATERAL VIEW explode cross-products

2025-07-15 Thread Konstantin Bereznyakov (Jira)
[ https://issues.apache.org/jira/browse/HIVE-29084?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Konstantin Bereznyakov updated HIVE-29084: -- Attachment: hive_29084.q > CBO returns incorrect results when WHERE clause filt

[jira] [Commented] (HIVE-29084) CBO returns incorrect results when WHERE clause filters multiple LATERAL VIEW explode cross-products

2025-07-15 Thread Konstantin Bereznyakov (Jira)
[ https://issues.apache.org/jira/browse/HIVE-29084?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18007345#comment-18007345 ] Konstantin Bereznyakov commented on HIVE-29084: --- reproduced via test files:

[jira] [Commented] (HIVE-29084) CBO returns incorrect results when WHERE clause filters multiple LATERAL VIEW explode cross-products

2025-07-15 Thread Konstantin Bereznyakov (Jira)
[ https://issues.apache.org/jira/browse/HIVE-29084?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18007344#comment-18007344 ] Konstantin Bereznyakov commented on HIVE-29084: --- [~zabetak] the explain res

[jira] [Commented] (HIVE-29084) CBO returns incorrect results when WHERE clause filters multiple LATERAL VIEW explode cross-products

2025-07-15 Thread Konstantin Bereznyakov (Jira)
[ https://issues.apache.org/jira/browse/HIVE-29084?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18007343#comment-18007343 ] Konstantin Bereznyakov commented on HIVE-29084: --- uzing Tez, EXPLAN EXTENDED

[jira] [Commented] (HIVE-29084) CBO returns incorrect results when WHERE clause filters multiple LATERAL VIEW explode cross-products

2025-07-15 Thread Konstantin Bereznyakov (Jira)
[ https://issues.apache.org/jira/browse/HIVE-29084?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18007342#comment-18007342 ] Konstantin Bereznyakov commented on HIVE-29084: --- uzing Tez, EXPLAN with CBO

[jira] [Assigned] (HIVE-28880) Query giving incorrect results when case is used along with UDFs upper & trim and a sub-query

2025-07-15 Thread Soumyakanti Das (Jira)
[ https://issues.apache.org/jira/browse/HIVE-28880?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Soumyakanti Das reassigned HIVE-28880: -- Assignee: Soumyakanti Das > Query giving incorrect results when case is used along wit

[jira] [Comment Edited] (HIVE-29084) CBO returns incorrect results when WHERE clause filters multiple LATERAL VIEW explode cross-products

2025-07-15 Thread Konstantin Bereznyakov (Jira)
[ https://issues.apache.org/jira/browse/HIVE-29084?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18007274#comment-18007274 ] Konstantin Bereznyakov edited comment on HIVE-29084 at 7/15/25 7:21 PM: ---

[jira] [Comment Edited] (HIVE-29084) CBO returns incorrect results when WHERE clause filters multiple LATERAL VIEW explode cross-products

2025-07-15 Thread Konstantin Bereznyakov (Jira)
[ https://issues.apache.org/jira/browse/HIVE-29084?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18007274#comment-18007274 ] Konstantin Bereznyakov edited comment on HIVE-29084 at 7/15/25 7:21 PM: ---

[jira] [Commented] (HIVE-29084) CBO returns incorrect results when WHERE clause filters multiple LATERAL VIEW explode cross-products

2025-07-15 Thread Konstantin Bereznyakov (Jira)
[ https://issues.apache.org/jira/browse/HIVE-29084?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18007316#comment-18007316 ] Konstantin Bereznyakov commented on HIVE-29084: --- from what I can tell, the

[jira] [Comment Edited] (HIVE-29084) CBO returns incorrect results when WHERE clause filters multiple LATERAL VIEW explode cross-products

2025-07-15 Thread Konstantin Bereznyakov (Jira)
[ https://issues.apache.org/jira/browse/HIVE-29084?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18007311#comment-18007311 ] Konstantin Bereznyakov edited comment on HIVE-29084 at 7/15/25 7:13 PM: ---

[jira] [Comment Edited] (HIVE-29084) CBO returns incorrect results when WHERE clause filters multiple LATERAL VIEW explode cross-products

2025-07-15 Thread Konstantin Bereznyakov (Jira)
[ https://issues.apache.org/jira/browse/HIVE-29084?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18007313#comment-18007313 ] Konstantin Bereznyakov edited comment on HIVE-29084 at 7/15/25 7:12 PM: ---

[jira] [Commented] (HIVE-29084) CBO returns incorrect results when WHERE clause filters multiple LATERAL VIEW explode cross-products

2025-07-15 Thread Konstantin Bereznyakov (Jira)
[ https://issues.apache.org/jira/browse/HIVE-29084?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18007313#comment-18007313 ] Konstantin Bereznyakov commented on HIVE-29084: --- EXPLAIN EXTENDED with CBO

[jira] [Commented] (HIVE-29073) Overlay modified session level metaconf to new hmsclient connection

2025-07-15 Thread Raghav Aggarwal (Jira)
[ https://issues.apache.org/jira/browse/HIVE-29073?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18007312#comment-18007312 ] Raghav Aggarwal commented on HIVE-29073: Hi [~okumin] [~dkuzmenko] [~seonggon] ,

[jira] [Commented] (HIVE-29084) CBO returns incorrect results when WHERE clause filters multiple LATERAL VIEW explode cross-products

2025-07-15 Thread Konstantin Bereznyakov (Jira)
[ https://issues.apache.org/jira/browse/HIVE-29084?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18007311#comment-18007311 ] Konstantin Bereznyakov commented on HIVE-29084: --- EXPLAIN with MR, CBO ON: {

[jira] [Updated] (HIVE-29073) Overlay modified session level metaconf to new hmsclient connection

2025-07-15 Thread Raghav Aggarwal (Jira)
[ https://issues.apache.org/jira/browse/HIVE-29073?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Raghav Aggarwal updated HIVE-29073: --- Attachment: WIP-HIVE-29073.patch > Overlay modified session level metaconf to new hmsclient c

[jira] [Updated] (HIVE-29073) Overlay modified session level metaconf to new hmsclient connection

2025-07-15 Thread Raghav Aggarwal (Jira)
[ https://issues.apache.org/jira/browse/HIVE-29073?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Raghav Aggarwal updated HIVE-29073: --- Attachment: HIVE-29073.pdf > Overlay modified session level metaconf to new hmsclient connect

[jira] [Updated] (HIVE-29085) CREATE EXTERNAL TABLE fails for JDBC tables when both hive.sql.table and hive.sql.query are set

2025-07-15 Thread Soumyakanti Das (Jira)
[ https://issues.apache.org/jira/browse/HIVE-29085?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Soumyakanti Das updated HIVE-29085: --- Description: When both hive.sql.table and hive.sql.query are set, we get the following excep

[jira] [Resolved] (HIVE-29082) Enhance HiveAuthzContext with a Client Configuration Map

2025-07-15 Thread Sai Hemanth Gantasala (Jira)
[ https://issues.apache.org/jira/browse/HIVE-29082?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sai Hemanth Gantasala resolved HIVE-29082. -- Fix Version/s: 4.2.0 Resolution: Fixed > Enhance HiveAuthzContext with a

[jira] [Commented] (HIVE-29082) Enhance HiveAuthzContext with a Client Configuration Map

2025-07-15 Thread Sai Hemanth Gantasala (Jira)
[ https://issues.apache.org/jira/browse/HIVE-29082?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18007293#comment-18007293 ] Sai Hemanth Gantasala commented on HIVE-29082: -- The patch has been merged in

[jira] [Commented] (HIVE-29084) CBO returns incorrect results when WHERE clause filters multiple LATERAL VIEW explode cross-products

2025-07-15 Thread Konstantin Bereznyakov (Jira)
[ https://issues.apache.org/jira/browse/HIVE-29084?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18007274#comment-18007274 ] Konstantin Bereznyakov commented on HIVE-29084: --- {{It looks like the WHERE

[jira] [Commented] (HIVE-29084) CBO returns incorrect results when WHERE clause filters multiple LATERAL VIEW explode cross-products

2025-07-15 Thread Konstantin Bereznyakov (Jira)
[ https://issues.apache.org/jira/browse/HIVE-29084?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18007256#comment-18007256 ] Konstantin Bereznyakov commented on HIVE-29084: --- [~zabetak] the problem was

[jira] [Commented] (HIVE-20189) Separate metastore client code into its own module

2025-07-15 Thread Denys Kuzmenko (Jira)
[ https://issues.apache.org/jira/browse/HIVE-20189?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18006711#comment-18006711 ] Denys Kuzmenko commented on HIVE-20189: --- Merged to master Thanks for the review, [

[jira] [Resolved] (HIVE-20189) Separate metastore client code into its own module

2025-07-15 Thread Denys Kuzmenko (Jira)
[ https://issues.apache.org/jira/browse/HIVE-20189?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Denys Kuzmenko resolved HIVE-20189. --- Fix Version/s: 4.2.0 Resolution: Fixed > Separate metastore client code into its own m

[jira] [Updated] (HIVE-29029) When stack UDTF is used with UNION ALL throwing ClassCastException in CBO mode.

2025-07-15 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/HIVE-29029?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated HIVE-29029: -- Labels: pull-request-available (was: ) > When stack UDTF is used with UNION ALL throwing Class

[jira] [Updated] (HIVE-29093) Alter Table Add Partition operation fails if the DEFAULT_PARTITION_NAME property is a substring of partition value to be added

2025-07-15 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/HIVE-29093?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated HIVE-29093: -- Labels: pull-request-available (was: ) > Alter Table Add Partition operation fails if the DEFA

[jira] [Assigned] (HIVE-29088) Add a configuration option to skip corrupted ORC files

2025-07-15 Thread Lucas (Jira)
[ https://issues.apache.org/jira/browse/HIVE-29088?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Lucas reassigned HIVE-29088: Assignee: Lucas (was: Abyss-lord) > Add a configuration option to skip corrupted ORC files >

[jira] [Commented] (HIVE-29076) Add the guideline for including the standalone Metastore release notes

2025-07-15 Thread Butao Zhang (Jira)
[ https://issues.apache.org/jira/browse/HIVE-29076?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18005545#comment-18005545 ] Butao Zhang commented on HIVE-29076: We can consider how to incorporate the release n

[jira] [Commented] (HIVE-29090) Remove RELEASE_NOTES from archives

2025-07-15 Thread Butao Zhang (Jira)
[ https://issues.apache.org/jira/browse/HIVE-29090?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18005543#comment-18005543 ] Butao Zhang commented on HIVE-29090: Yes, we need update the relase guide once we rem

[jira] [Updated] (HIVE-29089) MSCK Repair table adding invalid partitions for non string partitions columns

2025-07-15 Thread Vikram Ahuja (Jira)
[ https://issues.apache.org/jira/browse/HIVE-29089?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vikram Ahuja updated HIVE-29089: Description: Steps to repro: create table default_partition_name_1 (key int, value string) partiti

[jira] [Commented] (HIVE-29076) Add the guideline for including the standalone Metastore release notes

2025-07-15 Thread Stamatis Zampetakis (Jira)
[ https://issues.apache.org/jira/browse/HIVE-29076?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18005536#comment-18005536 ] Stamatis Zampetakis commented on HIVE-29076: For the record, in order to "fix

[jira] [Created] (HIVE-29093) Alter Table Add Partition operation fails if the DEFAULT_PARTITION_NAME property is a substring of partition value to be added

2025-07-15 Thread Vikram Ahuja (Jira)
Vikram Ahuja created HIVE-29093: --- Summary: Alter Table Add Partition operation fails if the DEFAULT_PARTITION_NAME property is a substring of partition value to be added Key: HIVE-29093 URL: https://issues.apache.or

[jira] [Commented] (HIVE-28804) The user does not have the permission for the table hdfs, but can delete the metadata

2025-07-15 Thread Denys Kuzmenko (Jira)
[ https://issues.apache.org/jira/browse/HIVE-28804?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18005526#comment-18005526 ] Denys Kuzmenko commented on HIVE-28804: --- [~zengxl] see comments in the PR. This is

[jira] [Commented] (HIVE-29085) CREATE EXTERNAL TABLE fails for JDBC tables when both hive.sql.table and hive.sql.query are set

2025-07-15 Thread Stamatis Zampetakis (Jira)
[ https://issues.apache.org/jira/browse/HIVE-29085?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18005525#comment-18005525 ] Stamatis Zampetakis commented on HIVE-29085: The attached stack trace is part

[jira] [Updated] (HIVE-28804) The user does not have the permission for the table hdfs, but can delete the metadata

2025-07-15 Thread Denys Kuzmenko (Jira)
[ https://issues.apache.org/jira/browse/HIVE-28804?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Denys Kuzmenko updated HIVE-28804: -- Priority: Trivial (was: Critical) > The user does not have the permission for the table hdfs,

[jira] [Commented] (HIVE-29084) CBO returns incorrect results when WHERE clause filters multiple LATERAL VIEW explode cross-products

2025-07-15 Thread Sungwoo Park (Jira)
[ https://issues.apache.org/jira/browse/HIVE-29084?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18005523#comment-18005523 ] Sungwoo Park commented on HIVE-29084: - [~zabetak] I tested with Hive 4.0.1 on Tez 0.1

[jira] [Commented] (HIVE-29084) CBO returns incorrect results when WHERE clause filters multiple LATERAL VIEW explode cross-products

2025-07-15 Thread Stamatis Zampetakis (Jira)
[ https://issues.apache.org/jira/browse/HIVE-29084?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18005518#comment-18005518 ] Stamatis Zampetakis commented on HIVE-29084: Thanks for reporting this [~kons

[jira] [Resolved] (HIVE-29009) Intermittent CI timeouts while running tests

2025-07-15 Thread Stamatis Zampetakis (Jira)
[ https://issues.apache.org/jira/browse/HIVE-29009?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Stamatis Zampetakis resolved HIVE-29009. Fix Version/s: 4.2.0 Resolution: Fixed Fixed in https://github.com/apache/h

[jira] [Commented] (HIVE-29090) Remove RELEASE_NOTES from archives

2025-07-15 Thread Stamatis Zampetakis (Jira)
[ https://issues.apache.org/jira/browse/HIVE-29090?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18005515#comment-18005515 ] Stamatis Zampetakis commented on HIVE-29090: As I commented under HIVE-29076