[jira] [Assigned] (HIVE-28265) Improve the error message for hive.query.timeout.seconds

2024-09-20 Thread Shohei Okumiya (Jira)
[ https://issues.apache.org/jira/browse/HIVE-28265?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Shohei Okumiya reassigned HIVE-28265: - Assignee: (was: Shohei Okumiya) > Improve the error message for hive.query.timeout.s

[jira] [Comment Edited] (HIVE-28483) String date cast giving wrong result

2024-09-18 Thread Shohei Okumiya (Jira)
[ https://issues.apache.org/jira/browse/HIVE-28483?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17882720#comment-17882720 ] Shohei Okumiya edited comment on HIVE-28483 at 9/18/24 1:57 PM: ---

[jira] [Commented] (HIVE-28483) String date cast giving wrong result

2024-09-18 Thread Shohei Okumiya (Jira)
[ https://issues.apache.org/jira/browse/HIVE-28483?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17882720#comment-17882720 ] Shohei Okumiya commented on HIVE-28483: --- I'm checking SQL:2023 Part 2. This comment

[jira] [Comment Edited] (HIVE-28483) String date cast giving wrong result

2024-09-18 Thread Shohei Okumiya (Jira)
[ https://issues.apache.org/jira/browse/HIVE-28483?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17882714#comment-17882714 ] Shohei Okumiya edited comment on HIVE-28483 at 9/18/24 1:35 PM: ---

[jira] [Commented] (HIVE-28483) String date cast giving wrong result

2024-09-18 Thread Shohei Okumiya (Jira)
[ https://issues.apache.org/jira/browse/HIVE-28483?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17882714#comment-17882714 ] Shohei Okumiya commented on HIVE-28483: --- I'm just adding some more examples. *Hive

[jira] [Commented] (HIVE-24167) TPC-DS query 14 fails while generating plan for the filter

2024-09-18 Thread Shohei Okumiya (Jira)
[ https://issues.apache.org/jira/browse/HIVE-24167?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17882696#comment-17882696 ] Shohei Okumiya commented on HIVE-24167: --- [~zabetak] Thanks. I created a new PR. [h

[jira] [Commented] (HIVE-24167) TPC-DS query 14 fails while generating plan for the filter

2024-09-09 Thread Shohei Okumiya (Jira)
[ https://issues.apache.org/jira/browse/HIVE-24167?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17880300#comment-17880300 ] Shohei Okumiya commented on HIVE-24167: --- [~zabetak] Thanks for checking. I love tha

[jira] [Resolved] (HIVE-27734) Add Iceberg's storage-partitioned join capabilities to Hive's [sorted-]bucket-map-join

2024-09-02 Thread Shohei Okumiya (Jira)
[ https://issues.apache.org/jira/browse/HIVE-27734?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Shohei Okumiya resolved HIVE-27734. --- Fix Version/s: 4.1.0 Resolution: Duplicate I split this ticket into HIVE-28411 and HIV

[jira] [Updated] (HIVE-28411) Bucket Map Join on Iceberg tables

2024-08-28 Thread Shohei Okumiya (Jira)
[ https://issues.apache.org/jira/browse/HIVE-28411?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Shohei Okumiya updated HIVE-28411: -- Status: Patch Available (was: In Progress) > Bucket Map Join on Iceberg tables > -

[jira] [Resolved] (HIVE-19741) Update documentation to reflect list of reserved words

2024-08-25 Thread Shohei Okumiya (Jira)
[ https://issues.apache.org/jira/browse/HIVE-19741?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Shohei Okumiya resolved HIVE-19741. --- Fix Version/s: 4.0.1 Resolution: Fixed > Update documentation to reflect list of reser

[jira] [Commented] (HIVE-19741) Update documentation to reflect list of reserved words

2024-08-25 Thread Shohei Okumiya (Jira)
[ https://issues.apache.org/jira/browse/HIVE-19741?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17876566#comment-17876566 ] Shohei Okumiya commented on HIVE-19741: --- I am closing this ticket as no issue has b

[jira] [Commented] (HIVE-19741) Update documentation to reflect list of reserved words

2024-08-22 Thread Shohei Okumiya (Jira)
[ https://issues.apache.org/jira/browse/HIVE-19741?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17875798#comment-17875798 ] Shohei Okumiya commented on HIVE-19741: --- Updated the document > Update documentati

[jira] [Commented] (HIVE-19741) Update documentation to reflect list of reserved words

2024-08-22 Thread Shohei Okumiya (Jira)
[ https://issues.apache.org/jira/browse/HIVE-19741?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17875787#comment-17875787 ] Shohei Okumiya commented on HIVE-19741: --- I checked differences using commands in th

[jira] [Comment Edited] (HIVE-19741) Update documentation to reflect list of reserved words

2024-08-22 Thread Shohei Okumiya (Jira)
[ https://issues.apache.org/jira/browse/HIVE-19741?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17874832#comment-17874832 ] Shohei Okumiya edited comment on HIVE-19741 at 8/22/24 9:36 AM: ---

[jira] [Comment Edited] (HIVE-19741) Update documentation to reflect list of reserved words

2024-08-22 Thread Shohei Okumiya (Jira)
[ https://issues.apache.org/jira/browse/HIVE-19741?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17874832#comment-17874832 ] Shohei Okumiya edited comment on HIVE-19741 at 8/22/24 7:41 AM: ---

[jira] [Comment Edited] (HIVE-19741) Update documentation to reflect list of reserved words

2024-08-19 Thread Shohei Okumiya (Jira)
[ https://issues.apache.org/jira/browse/HIVE-19741?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17874832#comment-17874832 ] Shohei Okumiya edited comment on HIVE-19741 at 8/20/24 3:41 AM: ---

[jira] [Comment Edited] (HIVE-19741) Update documentation to reflect list of reserved words

2024-08-19 Thread Shohei Okumiya (Jira)
[ https://issues.apache.org/jira/browse/HIVE-19741?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17874832#comment-17874832 ] Shohei Okumiya edited comment on HIVE-19741 at 8/20/24 3:39 AM: ---

[jira] [Comment Edited] (HIVE-19741) Update documentation to reflect list of reserved words

2024-08-19 Thread Shohei Okumiya (Jira)
[ https://issues.apache.org/jira/browse/HIVE-19741?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17874832#comment-17874832 ] Shohei Okumiya edited comment on HIVE-19741 at 8/20/24 3:38 AM: ---

[jira] [Commented] (HIVE-19741) Update documentation to reflect list of reserved words

2024-08-19 Thread Shohei Okumiya (Jira)
[ https://issues.apache.org/jira/browse/HIVE-19741?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17874879#comment-17874879 ] Shohei Okumiya commented on HIVE-19741: --- Cool. Thanks! I think I can check the late

[jira] [Comment Edited] (HIVE-19741) Update documentation to reflect list of reserved words

2024-08-19 Thread Shohei Okumiya (Jira)
[ https://issues.apache.org/jira/browse/HIVE-19741?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17874832#comment-17874832 ] Shohei Okumiya edited comment on HIVE-19741 at 8/19/24 11:05 AM: --

[jira] [Commented] (HIVE-19741) Update documentation to reflect list of reserved words

2024-08-19 Thread Shohei Okumiya (Jira)
[ https://issues.apache.org/jira/browse/HIVE-19741?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17874849#comment-17874849 ] Shohei Okumiya commented on HIVE-19741: --- [~zabetak] No, I don't. Could you please

[jira] [Comment Edited] (HIVE-19741) Update documentation to reflect list of reserved words

2024-08-19 Thread Shohei Okumiya (Jira)
[ https://issues.apache.org/jira/browse/HIVE-19741?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17874832#comment-17874832 ] Shohei Okumiya edited comment on HIVE-19741 at 8/19/24 10:00 AM: --

[jira] [Commented] (HIVE-19741) Update documentation to reflect list of reserved words

2024-08-19 Thread Shohei Okumiya (Jira)
[ https://issues.apache.org/jira/browse/HIVE-19741?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17874832#comment-17874832 ] Shohei Okumiya commented on HIVE-19741: --- (WIP) Checking changes. h2. Hive 2.2.0 h3.

[jira] [Assigned] (HIVE-19741) Update documentation to reflect list of reserved words

2024-08-19 Thread Shohei Okumiya (Jira)
[ https://issues.apache.org/jira/browse/HIVE-19741?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Shohei Okumiya reassigned HIVE-19741: - Assignee: Shohei Okumiya > Update documentation to reflect list of reserved words >

[jira] [Created] (HIVE-28446) Convert some reserved words to non-reserved words

2024-08-14 Thread Shohei Okumiya (Jira)
Shohei Okumiya created HIVE-28446: - Summary: Convert some reserved words to non-reserved words Key: HIVE-28446 URL: https://issues.apache.org/jira/browse/HIVE-28446 Project: Hive Issue Type:

[jira] [Updated] (HIVE-28439) Iceberg: Bucket partition transform with DECIMAL can throw NPE

2024-08-07 Thread Shohei Okumiya (Jira)
[ https://issues.apache.org/jira/browse/HIVE-28439?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Shohei Okumiya updated HIVE-28439: -- Status: Patch Available (was: Open) > Iceberg: Bucket partition transform with DECIMAL can thr

[jira] [Updated] (HIVE-28439) Iceberg: Bucket partition transform with DECIMAL can throw NPE

2024-08-07 Thread Shohei Okumiya (Jira)
[ https://issues.apache.org/jira/browse/HIVE-28439?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Shohei Okumiya updated HIVE-28439: -- Summary: Iceberg: Bucket partition transform with DECIMAL can throw NPE (was: Iceberg: Bucket

[jira] [Created] (HIVE-28439) Iceberg: Bucket partition transform with DECIMAL fails with NPE

2024-08-07 Thread Shohei Okumiya (Jira)
Shohei Okumiya created HIVE-28439: - Summary: Iceberg: Bucket partition transform with DECIMAL fails with NPE Key: HIVE-28439 URL: https://issues.apache.org/jira/browse/HIVE-28439 Project: Hive

[jira] [Work started] (HIVE-28411) Bucket Map Join on Iceberg tables

2024-08-05 Thread Shohei Okumiya (Jira)
[ https://issues.apache.org/jira/browse/HIVE-28411?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Work on HIVE-28411 started by Shohei Okumiya. - > Bucket Map Join on Iceberg tables > - > >

[jira] [Commented] (HIVE-24167) TPC-DS query 14 fails while generating plan for the filter

2024-08-05 Thread Shohei Okumiya (Jira)
[ https://issues.apache.org/jira/browse/HIVE-24167?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17871026#comment-17871026 ] Shohei Okumiya commented on HIVE-24167: --- Thanks. I agree that this should be resolv

[jira] [Updated] (HIVE-20318) NullPointerException when union with lateral view

2024-08-04 Thread Shohei Okumiya (Jira)
[ https://issues.apache.org/jira/browse/HIVE-20318?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Shohei Okumiya updated HIVE-20318: -- Fix Version/s: Not Applicable Resolution: Duplicate Status: Resolved (was: Pa

[jira] [Updated] (HIVE-14481) Remove the comments from the query

2024-08-04 Thread Shohei Okumiya (Jira)
[ https://issues.apache.org/jira/browse/HIVE-14481?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Shohei Okumiya updated HIVE-14481: -- Fix Version/s: Not Applicable Resolution: Duplicate Status: Resolved (was: Pa

[jira] [Commented] (HIVE-14481) Remove the comments from the query

2024-08-04 Thread Shohei Okumiya (Jira)
[ https://issues.apache.org/jira/browse/HIVE-14481?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17870889#comment-17870889 ] Shohei Okumiya commented on HIVE-14481: --- We confirmed this error happens with Hive

[jira] [Comment Edited] (HIVE-27734) Add Iceberg's storage-partitioned join capabilities to Hive's [sorted-]bucket-map-join

2024-07-27 Thread Shohei Okumiya (Jira)
[ https://issues.apache.org/jira/browse/HIVE-27734?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17869144#comment-17869144 ] Shohei Okumiya edited comment on HIVE-27734 at 7/28/24 6:54 AM: ---

[jira] [Commented] (HIVE-27734) Add Iceberg's storage-partitioned join capabilities to Hive's [sorted-]bucket-map-join

2024-07-27 Thread Shohei Okumiya (Jira)
[ https://issues.apache.org/jira/browse/HIVE-27734?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17869144#comment-17869144 ] Shohei Okumiya commented on HIVE-27734: --- Thanks. I see some positive reactions in [

[jira] [Created] (HIVE-28414) Flexible join optimization based on partition transform specs

2024-07-27 Thread Shohei Okumiya (Jira)
Shohei Okumiya created HIVE-28414: - Summary: Flexible join optimization based on partition transform specs Key: HIVE-28414 URL: https://issues.apache.org/jira/browse/HIVE-28414 Project: Hive

[jira] [Created] (HIVE-28413) Group By Optimization for Iceberg tables

2024-07-27 Thread Shohei Okumiya (Jira)
Shohei Okumiya created HIVE-28413: - Summary: Group By Optimization for Iceberg tables Key: HIVE-28413 URL: https://issues.apache.org/jira/browse/HIVE-28413 Project: Hive Issue Type: Sub-task

[jira] [Created] (HIVE-28412) Sort Merge Bucket Join for Iceberg tables

2024-07-27 Thread Shohei Okumiya (Jira)
Shohei Okumiya created HIVE-28412: - Summary: Sort Merge Bucket Join for Iceberg tables Key: HIVE-28412 URL: https://issues.apache.org/jira/browse/HIVE-28412 Project: Hive Issue Type: Sub-task

[jira] [Created] (HIVE-28411) Bucket Map Join on Iceberg tables

2024-07-27 Thread Shohei Okumiya (Jira)
Shohei Okumiya created HIVE-28411: - Summary: Bucket Map Join on Iceberg tables Key: HIVE-28411 URL: https://issues.apache.org/jira/browse/HIVE-28411 Project: Hive Issue Type: Sub-task

[jira] [Created] (HIVE-28410) Partition-Aware Optimization for Iceberg or OTF

2024-07-27 Thread Shohei Okumiya (Jira)
Shohei Okumiya created HIVE-28410: - Summary: Partition-Aware Optimization for Iceberg or OTF Key: HIVE-28410 URL: https://issues.apache.org/jira/browse/HIVE-28410 Project: Hive Issue Type: Ne

[jira] [Updated] (HIVE-28363) Improve heuristics of FilterStatsRule without column stats

2024-07-09 Thread Shohei Okumiya (Jira)
[ https://issues.apache.org/jira/browse/HIVE-28363?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Shohei Okumiya updated HIVE-28363: -- Status: Patch Available (was: Open) > Improve heuristics of FilterStatsRule without column sta

[jira] [Updated] (HIVE-28363) Improve heuristics of FilterStatsRule without column stats

2024-07-08 Thread Shohei Okumiya (Jira)
[ https://issues.apache.org/jira/browse/HIVE-28363?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Shohei Okumiya updated HIVE-28363: -- Description: HIVE-19097 changed the formula to estimate # of rows selected by FilterOperator.

[jira] [Updated] (HIVE-28363) Improve heuristics of FilterStatsRule without column stats

2024-07-08 Thread Shohei Okumiya (Jira)
[ https://issues.apache.org/jira/browse/HIVE-28363?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Shohei Okumiya updated HIVE-28363: -- Description: HIVE-13287 gave a better estimation on the selectivity of IN operators. This tick

[jira] [Updated] (HIVE-28363) Improve heuristics of FilterStatsRule without column stats

2024-07-08 Thread Shohei Okumiya (Jira)
[ https://issues.apache.org/jira/browse/HIVE-28363?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Shohei Okumiya updated HIVE-28363: -- Description: HIVE-13287 gave a better estimation of the selectivity of IN operators, especiall

[jira] [Updated] (HIVE-28363) Improve heuristics of FilterStatsRule without column stats

2024-07-08 Thread Shohei Okumiya (Jira)
[ https://issues.apache.org/jira/browse/HIVE-28363?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Shohei Okumiya updated HIVE-28363: -- Description: HIVE-13287 enables Hive to estimate the selectivity of IN operators better. It al

[jira] [Updated] (HIVE-28363) Improve heuristics of FilterStatsRule without column stats

2024-07-07 Thread Shohei Okumiya (Jira)
[ https://issues.apache.org/jira/browse/HIVE-28363?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Shohei Okumiya updated HIVE-28363: -- Description: HIVE-19647 enables Hive to estimate the selectivity of IN operators using new col

[jira] [Updated] (HIVE-28363) Improve heuristics of FilterStatsRule without column stats

2024-07-07 Thread Shohei Okumiya (Jira)
[ https://issues.apache.org/jira/browse/HIVE-28363?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Shohei Okumiya updated HIVE-28363: -- Description: HIVE-19647 enables Hive to estimate the selectivity of IN operators using new col

[jira] [Updated] (HIVE-28363) Improve heuristics of FilterStatsRule without column stats

2024-07-07 Thread Shohei Okumiya (Jira)
[ https://issues.apache.org/jira/browse/HIVE-28363?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Shohei Okumiya updated HIVE-28363: -- Description: HIVE-19647 enables Hive to estimate the selectivity of IN operators using new col

[jira] [Created] (HIVE-28363) Improve heuristics of FilterStatsRule without column stats

2024-07-07 Thread Shohei Okumiya (Jira)
Shohei Okumiya created HIVE-28363: - Summary: Improve heuristics of FilterStatsRule without column stats Key: HIVE-28363 URL: https://issues.apache.org/jira/browse/HIVE-28363 Project: Hive Iss

[jira] [Commented] (HIVE-28362) Fail to materialize a CTE with VOID

2024-07-07 Thread Shohei Okumiya (Jira)
[ https://issues.apache.org/jira/browse/HIVE-28362?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17863667#comment-17863667 ] Shohei Okumiya commented on HIVE-28362: --- I noticed VOID is not listed as an officia

[jira] [Commented] (HIVE-28362) Fail to materialize a CTE with VOID

2024-07-05 Thread Shohei Okumiya (Jira)
[ https://issues.apache.org/jira/browse/HIVE-28362?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17863199#comment-17863199 ] Shohei Okumiya commented on HIVE-28362: --- Thanks. I understand VOID is troublesome n

[jira] [Updated] (HIVE-28362) Fail to materialize a CTE with VOID

2024-07-05 Thread Shohei Okumiya (Jira)
[ https://issues.apache.org/jira/browse/HIVE-28362?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Shohei Okumiya updated HIVE-28362: -- Summary: Fail to materialize a CTE with VOID (was: Fail to materialize a CTE with a VOID type)

[jira] [Updated] (HIVE-28362) Fail to materialize a CTE with a VOID type

2024-07-05 Thread Shohei Okumiya (Jira)
[ https://issues.apache.org/jira/browse/HIVE-28362?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Shohei Okumiya updated HIVE-28362: -- Summary: Fail to materialize a CTE with a VOID type (was: Fail to materialize a CTE with VOID

[jira] [Created] (HIVE-28362) Fail to materialize a CTE with VOID a type

2024-07-05 Thread Shohei Okumiya (Jira)
Shohei Okumiya created HIVE-28362: - Summary: Fail to materialize a CTE with VOID a type Key: HIVE-28362 URL: https://issues.apache.org/jira/browse/HIVE-28362 Project: Hive Issue Type: Bug

[jira] [Updated] (HIVE-28352) Schematool fails to upgradeSchema on dbType=hive

2024-06-26 Thread Shohei Okumiya (Jira)
[ https://issues.apache.org/jira/browse/HIVE-28352?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Shohei Okumiya updated HIVE-28352: -- Status: Patch Available (was: Open) https://github.com/apache/hive/pull/5324 > Schematool fai

[jira] [Updated] (HIVE-28352) Schematool fails to upgradeSchema on dbType=hive

2024-06-26 Thread Shohei Okumiya (Jira)
[ https://issues.apache.org/jira/browse/HIVE-28352?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Shohei Okumiya updated HIVE-28352: -- Component/s: Standalone Metastore (was: Metastore) > Schematool fails to u

[jira] [Updated] (HIVE-28352) Schematool fails to upgradeSchema on dbType=hive

2024-06-26 Thread Shohei Okumiya (Jira)
[ https://issues.apache.org/jira/browse/HIVE-28352?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Shohei Okumiya updated HIVE-28352: -- Summary: Schematool fails to upgradeSchema on dbType=hive (was: Schematool fails to upgradeSch

[jira] [Updated] (HIVE-28352) Schematool fails to upgradeSchema for dbType=hive

2024-06-26 Thread Shohei Okumiya (Jira)
[ https://issues.apache.org/jira/browse/HIVE-28352?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Shohei Okumiya updated HIVE-28352: -- Description: Schematool tries to refer to incorrect file names. {code:java} $ schematool -metaD

[jira] [Created] (HIVE-28352) Schematool fails to upgradeSchema for dbType=hive

2024-06-26 Thread Shohei Okumiya (Jira)
Shohei Okumiya created HIVE-28352: - Summary: Schematool fails to upgradeSchema for dbType=hive Key: HIVE-28352 URL: https://issues.apache.org/jira/browse/HIVE-28352 Project: Hive Issue Type:

[jira] [Commented] (HIVE-27734) Add Iceberg's storage-partitioned join capabilities to Hive's [sorted-]bucket-map-join

2024-06-25 Thread Shohei Okumiya (Jira)
[ https://issues.apache.org/jira/browse/HIVE-27734?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17860052#comment-17860052 ] Shohei Okumiya commented on HIVE-27734: --- Hi Denys, thanks for your response. Please

[jira] [Commented] (HIVE-28193) Skip CBO fallback when EXCEPT/INTERSECT/QUALIFY are used

2024-06-18 Thread Shohei Okumiya (Jira)
[ https://issues.apache.org/jira/browse/HIVE-28193?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17855963#comment-17855963 ] Shohei Okumiya commented on HIVE-28193: --- New PR is this one. https://github.com/ap

[jira] [Updated] (HIVE-28193) Skip CBO fallback when EXCEPT/INTERSECT/QUALIFY are used

2024-06-18 Thread Shohei Okumiya (Jira)
[ https://issues.apache.org/jira/browse/HIVE-28193?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Shohei Okumiya updated HIVE-28193: -- Summary: Skip CBO fallback when EXCEPT/INTERSECT/QUALIFY are used (was: Ignore CBO fallback st

[jira] [Commented] (HIVE-28193) Ignore CBO fallback strategy when EXCEPT/INTERSECT/QUALIFY are used

2024-06-18 Thread Shohei Okumiya (Jira)
[ https://issues.apache.org/jira/browse/HIVE-28193?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17855940#comment-17855940 ] Shohei Okumiya commented on HIVE-28193: --- I revised the title because I found that Q

[jira] [Updated] (HIVE-28193) Ignore CBO fallback strategy when EXCEPT/INTERSECT/QUALIFY are used

2024-06-18 Thread Shohei Okumiya (Jira)
[ https://issues.apache.org/jira/browse/HIVE-28193?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Shohei Okumiya updated HIVE-28193: -- Summary: Ignore CBO fallback strategy when EXCEPT/INTERSECT/QUALIFY are used (was: CBO fallbac

[jira] [Updated] (HIVE-28193) CBO fallback can overwrite the real error message when EXCEPT or INTERSECT are used

2024-06-18 Thread Shohei Okumiya (Jira)
[ https://issues.apache.org/jira/browse/HIVE-28193?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Shohei Okumiya updated HIVE-28193: -- Description: With `hive.cbo.fallback.strategy=CONSERVATIVE`, Hive retries to compile an SQL wi

[jira] [Updated] (HIVE-28302) Let SUM UDF return NULL when all rows have non-numeric texts

2024-06-07 Thread Shohei Okumiya (Jira)
[ https://issues.apache.org/jira/browse/HIVE-28302?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Shohei Okumiya updated HIVE-28302: -- Status: Patch Available (was: Open) > Let SUM UDF return NULL when all rows have non-numeric t

[jira] [Created] (HIVE-28302) Let SUM UDF return NULL when all rows have non-numeric texts

2024-06-04 Thread Shohei Okumiya (Jira)
Shohei Okumiya created HIVE-28302: - Summary: Let SUM UDF return NULL when all rows have non-numeric texts Key: HIVE-28302 URL: https://issues.apache.org/jira/browse/HIVE-28302 Project: Hive

[jira] [Updated] (HIVE-27847) Prevent query Failures on Numeric <-> Timestamp

2024-06-04 Thread Shohei Okumiya (Jira)
[ https://issues.apache.org/jira/browse/HIVE-27847?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Shohei Okumiya updated HIVE-27847: -- Status: Patch Available (was: In Progress) > Prevent query Failures on Numeric <-> Timestamp

[jira] [Commented] (HIVE-27847) Prevent query Failures on Numeric <-> Timestamp

2024-06-04 Thread Shohei Okumiya (Jira)
[ https://issues.apache.org/jira/browse/HIVE-27847?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17852234#comment-17852234 ] Shohei Okumiya commented on HIVE-27847: --- I took it over based on the discussion in

[jira] [Assigned] (HIVE-27847) Prevent query Failures on Numeric <-> Timestamp

2024-06-04 Thread Shohei Okumiya (Jira)
[ https://issues.apache.org/jira/browse/HIVE-27847?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Shohei Okumiya reassigned HIVE-27847: - Assignee: Shohei Okumiya (was: Basapuram Kumar) > Prevent query Failures on Numeric <-

[jira] [Updated] (HIVE-28254) CBO (Calcite Return Path): Multiple DISTINCT leads to wrong results

2024-05-16 Thread Shohei Okumiya (Jira)
[ https://issues.apache.org/jira/browse/HIVE-28254?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Shohei Okumiya updated HIVE-28254: -- Status: Patch Available (was: Open) > CBO (Calcite Return Path): Multiple DISTINCT leads to wr

[jira] [Created] (HIVE-28265) Improve the error message for hive.query.timeout.seconds

2024-05-16 Thread Shohei Okumiya (Jira)
Shohei Okumiya created HIVE-28265: - Summary: Improve the error message for hive.query.timeout.seconds Key: HIVE-28265 URL: https://issues.apache.org/jira/browse/HIVE-28265 Project: Hive Issue

[jira] [Commented] (HIVE-27847) Prevent query Failures on Numeric <-> Timestamp

2024-05-14 Thread Shohei Okumiya (Jira)
[ https://issues.apache.org/jira/browse/HIVE-27847?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17846196#comment-17846196 ] Shohei Okumiya commented on HIVE-27847: --- [~basapuram.kumar] We are also hitting the

[jira] [Created] (HIVE-28254) CBO (Calcite Return Path): Multiple DISTINCT leads to wrong results

2024-05-11 Thread Shohei Okumiya (Jira)
Shohei Okumiya created HIVE-28254: - Summary: CBO (Calcite Return Path): Multiple DISTINCT leads to wrong results Key: HIVE-28254 URL: https://issues.apache.org/jira/browse/HIVE-28254 Project: Hive

[jira] [Updated] (HIVE-28208) WITH column list doesn't work with CTE materialization

2024-05-02 Thread Shohei Okumiya (Jira)
[ https://issues.apache.org/jira/browse/HIVE-28208?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Shohei Okumiya updated HIVE-28208: -- Status: Patch Available (was: Open) > WITH column list doesn't work with CTE materialization >

[jira] [Created] (HIVE-28208) WITH column list doesn't work with CTE materialization

2024-04-23 Thread Shohei Okumiya (Jira)
Shohei Okumiya created HIVE-28208: - Summary: WITH column list doesn't work with CTE materialization Key: HIVE-28208 URL: https://issues.apache.org/jira/browse/HIVE-28208 Project: Hive Issue T

[jira] [Updated] (HIVE-28207) NullPointerException is thrown when checking column uniqueness

2024-04-22 Thread Shohei Okumiya (Jira)
[ https://issues.apache.org/jira/browse/HIVE-28207?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Shohei Okumiya updated HIVE-28207: -- Description: In some cases, we skip checking null. For example, the last statement in the foll

[jira] [Commented] (HIVE-28207) NullPointerException is thrown when checking column uniqueness

2024-04-22 Thread Shohei Okumiya (Jira)
[ https://issues.apache.org/jira/browse/HIVE-28207?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17839600#comment-17839600 ] Shohei Okumiya commented on HIVE-28207: --- Thanks. I attached a stack trace to the de

[jira] [Updated] (HIVE-28207) NullPointerException is thrown when checking column uniqueness

2024-04-21 Thread Shohei Okumiya (Jira)
[ https://issues.apache.org/jira/browse/HIVE-28207?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Shohei Okumiya updated HIVE-28207: -- Status: Patch Available (was: Open) > NullPointerException is thrown when checking column uniq

[jira] [Created] (HIVE-28207) NullPointerException is thrown when checking column uniqueness

2024-04-21 Thread Shohei Okumiya (Jira)
Shohei Okumiya created HIVE-28207: - Summary: NullPointerException is thrown when checking column uniqueness Key: HIVE-28207 URL: https://issues.apache.org/jira/browse/HIVE-28207 Project: Hive

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

2024-04-17 Thread Shohei Okumiya (Jira)
[ https://issues.apache.org/jira/browse/HIVE-28082?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17838155#comment-17838155 ] Shohei Okumiya commented on HIVE-28082: --- It seems to be correct, and those behavior

[jira] [Commented] (HIVE-27734) Add Iceberg's storage-partitioned join capabilities to Hive's [sorted-]bucket-map-join

2024-04-15 Thread Shohei Okumiya (Jira)
[ https://issues.apache.org/jira/browse/HIVE-27734?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17837264#comment-17837264 ] Shohei Okumiya commented on HIVE-27734: --- [~dkuzmenko]  I surveyed some optimizatio

[jira] [Updated] (HIVE-28193) CBO fallback can overwrite the real error message when EXCEPT or INTERSECT are used

2024-04-10 Thread Shohei Okumiya (Jira)
[ https://issues.apache.org/jira/browse/HIVE-28193?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Shohei Okumiya updated HIVE-28193: -- Status: Patch Available (was: Open) > CBO fallback can overwrite the real error message when E

[jira] [Created] (HIVE-28193) CBO fallback can overwrite the real error message when EXCEPT or INTERSECT are used

2024-04-09 Thread Shohei Okumiya (Jira)
Shohei Okumiya created HIVE-28193: - Summary: CBO fallback can overwrite the real error message when EXCEPT or INTERSECT are used Key: HIVE-28193 URL: https://issues.apache.org/jira/browse/HIVE-28193 P

[jira] [Commented] (HIVE-24167) TPC-DS query 14 fails while generating plan for the filter

2024-04-08 Thread Shohei Okumiya (Jira)
[ https://issues.apache.org/jira/browse/HIVE-24167?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17835152#comment-17835152 ] Shohei Okumiya commented on HIVE-24167: --- [~zabetak], I rebased #5077 and passed int

[jira] [Commented] (HIVE-24167) TPC-DS query 14 fails while generating plan for the filter

2024-04-08 Thread Shohei Okumiya (Jira)
[ https://issues.apache.org/jira/browse/HIVE-24167?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17834896#comment-17834896 ] Shohei Okumiya commented on HIVE-24167: --- Oh, Zoltan gave +1 to the approach. There

[jira] [Comment Edited] (HIVE-27734) Add Iceberg's storage-partitioned join capabilities to Hive's [sorted-]bucket-map-join

2024-04-07 Thread Shohei Okumiya (Jira)
[ https://issues.apache.org/jira/browse/HIVE-27734?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17834642#comment-17834642 ] Shohei Okumiya edited comment on HIVE-27734 at 4/7/24 1:16 PM:

[jira] [Commented] (HIVE-27734) Add Iceberg's storage-partitioned join capabilities to Hive's [sorted-]bucket-map-join

2024-04-07 Thread Shohei Okumiya (Jira)
[ https://issues.apache.org/jira/browse/HIVE-27734?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17834642#comment-17834642 ] Shohei Okumiya commented on HIVE-27734: --- Thanks. I have some quick updates. * What

[jira] [Assigned] (HIVE-27734) Add Iceberg's storage-partitioned join capabilities to Hive's [sorted-]bucket-map-join

2024-03-28 Thread Shohei Okumiya (Jira)
[ https://issues.apache.org/jira/browse/HIVE-27734?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Shohei Okumiya reassigned HIVE-27734: - Assignee: Shohei Okumiya > Add Iceberg's storage-partitioned join capabilities to Hive's