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

2023-06-09 Thread Naresh P R (Jira)
[ https://issues.apache.org/jira/browse/HIVE-27428?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Naresh P R updated HIVE-27428: -- Description: Repro steps: {code:java} drop table if exists table1; drop table if exists table2;

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

2023-06-09 Thread Naresh P R (Jira)
Naresh P R created HIVE-27428: - Summary: CTAS fails with SemanticException when join subquery has complex type column and false filter predicate Key: HIVE-27428 URL: https://issues.apache.org/jira/browse/HIVE-27428

[jira] [Commented] (HIVE-27964) Support drop stats similar to Impala

2023-12-21 Thread Naresh P R (Jira)
[ https://issues.apache.org/jira/browse/HIVE-27964?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17799522#comment-17799522 ] Naresh P R commented on HIVE-27964: --- Partition table rename gets clogged at PART_COL_STATS for wide

[jira] [Comment Edited] (HIVE-27964) Support drop stats similar to Impala

2023-12-21 Thread Naresh P R (Jira)
[ https://issues.apache.org/jira/browse/HIVE-27964?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17799522#comment-17799522 ] Naresh P R edited comment on HIVE-27964 at 12/21/23 5:47 PM: - Partition table

[jira] [Created] (HIVE-27965) Table/partition rename takes a long time at PART_COL_STATS for wide tables

2023-12-21 Thread Naresh P R (Jira)
Naresh P R created HIVE-27965: - Summary: Table/partition rename takes a long time at PART_COL_STATS for wide tables Key: HIVE-27965 URL: https://issues.apache.org/jira/browse/HIVE-27965 Project: Hive

[jira] [Created] (HIVE-27964) Support drop stats similar to Impala

2023-12-20 Thread Naresh P R (Jira)
Naresh P R created HIVE-27964: - Summary: Support drop stats similar to Impala Key: HIVE-27964 URL: https://issues.apache.org/jira/browse/HIVE-27964 Project: Hive Issue Type: New Feature

[jira] [Commented] (HIVE-27965) Table/partition rename takes a long time at PART_COL_STATS for wide tables

2023-12-21 Thread Naresh P R (Jira)
[ https://issues.apache.org/jira/browse/HIVE-27965?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17799649#comment-17799649 ] Naresh P R commented on HIVE-27965: --- [~zhangbutao]  Yes, this helps. Thanks for letting me know. >

[jira] [Updated] (HIVE-27965) Table/partition rename takes a long time at PART_COL_STATS for wide tables

2023-12-21 Thread Naresh P R (Jira)
[ https://issues.apache.org/jira/browse/HIVE-27965?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Naresh P R updated HIVE-27965: -- Description: Partition table rename gets clogged at PART_COL_STATS for wide tables. {code:java} CREATE

[jira] [Updated] (HIVE-27965) Table/partition rename takes a long time at PART_COL_STATS for wide tables

2023-12-21 Thread Naresh P R (Jira)
[ https://issues.apache.org/jira/browse/HIVE-27965?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Naresh P R updated HIVE-27965: -- Description: Partition table rename gets clogged at PART_COL_STATS for wide tables. {code:java} CREATE

[jira] [Comment Edited] (HIVE-27964) Support drop stats similar to Impala

2023-12-21 Thread Naresh P R (Jira)
[ https://issues.apache.org/jira/browse/HIVE-27964?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17799522#comment-17799522 ] Naresh P R edited comment on HIVE-27964 at 12/21/23 6:17 PM: - Partition table

[jira] [Comment Edited] (HIVE-27964) Support drop stats similar to Impala

2023-12-21 Thread Naresh P R (Jira)
[ https://issues.apache.org/jira/browse/HIVE-27964?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17799522#comment-17799522 ] Naresh P R edited comment on HIVE-27964 at 12/21/23 6:10 PM: - Partition table

[jira] [Commented] (HIVE-27885) Cast decimal from string with space without digits before dot returns NULL

2023-11-24 Thread Naresh P R (Jira)
[ https://issues.apache.org/jira/browse/HIVE-27885?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17789609#comment-17789609 ] Naresh P R commented on HIVE-27885: --- Thank you [~rameshkumar] & [~ngangam] for the review and commit.

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

2023-11-15 Thread Naresh P R (Jira)
Naresh P R created HIVE-27876: - Summary: Incorrect query results on tables with ClusterBy & SortBy Key: HIVE-27876 URL: https://issues.apache.org/jira/browse/HIVE-27876 Project: Hive Issue Type:

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

2023-11-15 Thread Naresh P R (Jira)
[ https://issues.apache.org/jira/browse/HIVE-27876?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Naresh P R updated HIVE-27876: -- Description: Repro:   {code:java} create external table test_bucket(age int, name string, dept

[jira] [Created] (HIVE-27885) Cast decimal from string with space without digits before dot returns NULL

2023-11-17 Thread Naresh P R (Jira)
Naresh P R created HIVE-27885: - Summary: Cast decimal from string with space without digits before dot returns NULL Key: HIVE-27885 URL: https://issues.apache.org/jira/browse/HIVE-27885 Project: Hive

[jira] [Updated] (HIVE-27885) Cast decimal from string with space without digits before dot returns NULL

2023-11-17 Thread Naresh P R (Jira)
[ https://issues.apache.org/jira/browse/HIVE-27885?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Naresh P R updated HIVE-27885: -- Environment: (was: eg., select cast(". " as decimal(8,4)) -- Expected output 0. --

[jira] [Updated] (HIVE-27885) Cast decimal from string with space without digits before dot returns NULL

2023-11-17 Thread Naresh P R (Jira)
[ https://issues.apache.org/jira/browse/HIVE-27885?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Naresh P R updated HIVE-27885: -- Description: eg., select cast(". " as decimal(8,4)) {code:java} – Expected output 0. – Actual

[jira] [Updated] (HIVE-27885) Cast decimal from string with space without digits before dot returns NULL

2023-11-17 Thread Naresh P R (Jira)
[ https://issues.apache.org/jira/browse/HIVE-27885?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Naresh P R updated HIVE-27885: -- Description: eg., select cast(". " as decimal(8,4))   {code:java} – Expected output 0. –

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

2024-04-24 Thread Naresh P R (Jira)
Naresh P R created HIVE-28213: - Summary: Incorrect results after insert-select from similar bucketed source & target table Key: HIVE-28213 URL: https://issues.apache.org/jira/browse/HIVE-28213 Project:

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

2024-04-24 Thread Naresh P R (Jira)
[ https://issues.apache.org/jira/browse/HIVE-28213?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Naresh P R updated HIVE-28213: -- Description: Insert-select is not honoring bucketing if both source & target are bucketed on same

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

2024-04-24 Thread Naresh P R (Jira)
[ https://issues.apache.org/jira/browse/HIVE-28213?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Naresh P R updated HIVE-28213: -- Description: Insert-select is not honoring bucketing if both source & target are bucketed on same

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

2024-04-24 Thread Naresh P R (Jira)
[ https://issues.apache.org/jira/browse/HIVE-28213?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Naresh P R updated HIVE-28213: -- Description: Insert-select is not honoring bucketing if both source & target are bucketed on same

[jira] [Commented] (HIVE-28117) add_months() with output_date_format returning wrong year on leap day

2024-03-14 Thread Naresh P R (Jira)
[ https://issues.apache.org/jira/browse/HIVE-28117?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17827257#comment-17827257 ] Naresh P R commented on HIVE-28117: --- Can you try your usecase with -MM format ? eg., select

<    1   2   3   4