[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] [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] [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

[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] [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] [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:10 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] [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] [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] [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-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] [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] [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: -- Environment: (was: eg., select cast(". " as decimal(8,4)) -- Expected output 0. --

[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-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-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-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] [Created] (HIVE-27280) Query on View fails in SemanticAnalyzer if view select has grouping sets

2023-04-20 Thread Naresh P R (Jira)
Naresh P R created HIVE-27280: - Summary: Query on View fails in SemanticAnalyzer if view select has grouping sets Key: HIVE-27280 URL: https://issues.apache.org/jira/browse/HIVE-27280 Project: Hive

[jira] [Updated] (HIVE-27164) Create Temp Txn Table As Select is failing at tablePath validation

2023-03-21 Thread Naresh P R (Jira)
[ https://issues.apache.org/jira/browse/HIVE-27164?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Naresh P R updated HIVE-27164: -- Description: After HIVE-25303, every CTAS goes for   HiveMetaStore$HMSHandler#translate_table_dryrun()

[jira] [Updated] (HIVE-27164) Create Temp Txn Table As Select is failing at tablePath validation

2023-03-21 Thread Naresh P R (Jira)
[ https://issues.apache.org/jira/browse/HIVE-27164?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Naresh P R updated HIVE-27164: -- Description: After HIVE-25303, every CTAS goes for   HiveMetaStore$HMSHandler#translate_table_dryrun()

[jira] [Updated] (HIVE-27164) Create Temp Txn Table As Select is failing at tablePath validation

2023-03-21 Thread Naresh P R (Jira)
[ https://issues.apache.org/jira/browse/HIVE-27164?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Naresh P R updated HIVE-27164: -- Attachment: mm_cttas.q > Create Temp Txn Table As Select is failing at tablePath validation >

[jira] [Updated] (HIVE-27164) Create Temp Txn Table As Select is failing at tablePath validation

2023-03-21 Thread Naresh P R (Jira)
[ https://issues.apache.org/jira/browse/HIVE-27164?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Naresh P R updated HIVE-27164: -- Description: After HIVE-25303, every CTAS goes for   HiveMetaStore$HMSHandler#translate_table_dryrun()

[jira] [Updated] (HIVE-27164) Create Temp Txn Table As Select is failing at tablePath validation

2023-03-21 Thread Naresh P R (Jira)
[ https://issues.apache.org/jira/browse/HIVE-27164?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Naresh P R updated HIVE-27164: -- Description: After HIVE-25303, every CTAS goes for   HiveMetaStore$HMSHandler#translate_table_dryrun()

[jira] [Updated] (HIVE-27114) Provide a configurable filter for removing useless properties in Partition objects from listPartitions HMS Calls

2023-02-28 Thread Naresh P R (Jira)
[ https://issues.apache.org/jira/browse/HIVE-27114?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Naresh P R updated HIVE-27114: -- Summary: Provide a configurable filter for removing useless properties in Partition objects from

[jira] [Updated] (HIVE-27114) Provide a configurable filter for removing useless properties in Partition objects from getPartitions HMS Calls

2023-02-28 Thread Naresh P R (Jira)
[ https://issues.apache.org/jira/browse/HIVE-27114?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Naresh P R updated HIVE-27114: -- Description: HMS API calls are throwing following exception because of thrift upgrade {code:java}

[jira] [Updated] (HIVE-27114) Provide a configurable filter for removing useless properties in Partition objects from getPartitions HMS Calls

2023-02-28 Thread Naresh P R (Jira)
[ https://issues.apache.org/jira/browse/HIVE-27114?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Naresh P R updated HIVE-27114: -- Description: HMS API calls are throwing following exception because of thrift upgrade {code:java}

[jira] [Updated] (HIVE-27114) Provide a configurable filter for removing useless properties in Partition objects from getPartitions HMS Calls

2023-02-28 Thread Naresh P R (Jira)
[ https://issues.apache.org/jira/browse/HIVE-27114?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Naresh P R updated HIVE-27114: -- Summary: Provide a configurable filter for removing useless properties in Partition objects from

[jira] [Commented] (HIVE-26495) MSCK repair perf issue HMSChecker ThreadPool is blocked at fs.listStatus

2022-09-26 Thread Naresh P R (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26495?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17609601#comment-17609601 ] Naresh P R commented on HIVE-26495: --- Thank you for the the review & merge [~srahman] [~ayushtkn]  >

[jira] [Updated] (HIVE-26526) MSCK sync is not removing partitions with special characters

2022-09-08 Thread Naresh P R (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26526?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Naresh P R updated HIVE-26526: -- Attachment: test.q > MSCK sync is not removing partitions with special characters >

[jira] [Updated] (HIVE-26526) MSCK sync is not removing partitions with special characters

2022-09-08 Thread Naresh P R (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26526?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Naresh P R updated HIVE-26526: -- Issue Type: Bug (was: New Feature) > MSCK sync is not removing partitions with special characters >

[jira] [Commented] (HIVE-26495) MSCK repair perf issue HMSChecker ThreadPool is blocked at fs.listStatus

2022-08-26 Thread Naresh P R (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26495?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17585622#comment-17585622 ] Naresh P R commented on HIVE-26495: --- [~srahman] I dint see much improvement. I was missing HIVE-21040

[jira] [Comment Edited] (HIVE-26495) MSCK repair perf issue HMSChecker ThreadPool is blocked at fs.listStatus

2022-08-26 Thread Naresh P R (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26495?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17585622#comment-17585622 ] Naresh P R edited comment on HIVE-26495 at 8/26/22 9:52 PM: [~srahman] I dint

[jira] [Updated] (HIVE-26495) MSCK repair perf issue HMSChecker ThreadPool is blocked at fs.listStatus

2022-08-24 Thread Naresh P R (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26495?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Naresh P R updated HIVE-26495: -- Issue Type: Bug (was: New Feature) > MSCK repair perf issue HMSChecker ThreadPool is blocked at

[jira] [Assigned] (HIVE-26495) MSCK repair perf issue HMSChecker ThreadPool is blocked at fs.listStatus

2022-08-24 Thread Naresh P R (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26495?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Naresh P R reassigned HIVE-26495: - > MSCK repair perf issue HMSChecker ThreadPool is blocked at fs.listStatus >

[jira] [Comment Edited] (HIVE-26096) Select on single column MultiDelimitSerDe table throws AIOBE

2022-04-10 Thread Naresh P R (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26096?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17520096#comment-17520096 ] Naresh P R edited comment on HIVE-26096 at 4/10/22 6:42 AM: Thanks for the

[jira] [Commented] (HIVE-26096) Select on single column MultiDelimitSerDe table throws AIOBE

2022-04-10 Thread Naresh P R (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26096?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17520096#comment-17520096 ] Naresh P R commented on HIVE-26096: --- Thanks for the review & commit [~rameshkumar] ** > Select on

[jira] [Resolved] (HIVE-26096) Select on single column MultiDelimitSerDe table throws AIOBE

2022-04-10 Thread Naresh P R (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26096?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Naresh P R resolved HIVE-26096. --- Fix Version/s: 4.0.0-alpha-2 Resolution: Fixed > Select on single column MultiDelimitSerDe

[jira] [Assigned] (HIVE-26096) Select on single column MultiDelimitSerDe table throws AIOBE

2022-03-30 Thread Naresh P R (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26096?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Naresh P R reassigned HIVE-26096: - > Select on single column MultiDelimitSerDe table throws AIOBE >

[jira] [Updated] (HIVE-26047) Vectorized LIKE UDF should use Re2J regex to address JDK-8203458

2022-03-17 Thread Naresh P R (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26047?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Naresh P R updated HIVE-26047: -- Description: Below pattern is taking a long time to validate regex in java8 with same trace as shown

[jira] [Assigned] (HIVE-26047) Vectorized LIKE UDF should use Re2J regex to address JDK-8203458

2022-03-17 Thread Naresh P R (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26047?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Naresh P R reassigned HIVE-26047: - > Vectorized LIKE UDF should use Re2J regex to address JDK-8203458 >

[jira] [Updated] (HIVE-26006) TopNKey and PTF with more than one column is failing with IOBE

2022-03-04 Thread Naresh P R (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26006?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Naresh P R updated HIVE-26006: -- Description: {code:java} java.lang.IndexOutOfBoundsException: toIndex = 2 at

[jira] [Updated] (HIVE-26000) DirectSQL to prune partitions fails with postgres backend for Skewed-Partition tables

2022-03-02 Thread Naresh P R (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26000?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Naresh P R updated HIVE-26000: -- Summary: DirectSQL to prune partitions fails with postgres backend for Skewed-Partition tables (was:

[jira] [Updated] (HIVE-26000) DirectSQL to pruning partitions fails with postgres backend for Skewed-Partition tables

2022-03-02 Thread Naresh P R (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26000?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Naresh P R updated HIVE-26000: -- Summary: DirectSQL to pruning partitions fails with postgres backend for Skewed-Partition tables

[jira] [Assigned] (HIVE-26000) Partition table with Skew columns, DirectSQL to pruning partitions fails with Postgres backend

2022-03-02 Thread Naresh P R (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26000?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Naresh P R reassigned HIVE-26000: - > Partition table with Skew columns, DirectSQL to pruning partitions fails with > Postgres backend

[jira] [Updated] (HIVE-25919) CCE when validating AND PPD in HBaseStorageHandler

2022-02-01 Thread Naresh P R (Jira)
[ https://issues.apache.org/jira/browse/HIVE-25919?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Naresh P R updated HIVE-25919: -- Description: After HIVE-13815,

[jira] [Updated] (HIVE-25919) CCE when validating AND PPD in HBaseStorageHandler

2022-02-01 Thread Naresh P R (Jira)
[ https://issues.apache.org/jira/browse/HIVE-25919?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Naresh P R updated HIVE-25919: -- Attachment: test.q > CCE when validating AND PPD in HBaseStorageHandler >

[jira] [Updated] (HIVE-25419) HMS Client/Server filter fails with StorageBasedAuthorizationProvider

2021-08-04 Thread Naresh P R (Jira)
[ https://issues.apache.org/jira/browse/HIVE-25419?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Naresh P R updated HIVE-25419: -- Description:

[jira] [Updated] (HIVE-25419) HMS Client/Server filter fails with StorageBasedAuthorizationProvider

2021-08-04 Thread Naresh P R (Jira)
[ https://issues.apache.org/jira/browse/HIVE-25419?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Naresh P R updated HIVE-25419: -- Summary: HMS Client/Server filter fails with StorageBasedAuthorizationProvider (was: HMS Client

[jira] [Resolved] (HIVE-25338) AIOBE in conv UDF if input is empty

2021-07-23 Thread Naresh P R (Jira)
[ https://issues.apache.org/jira/browse/HIVE-25338?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Naresh P R resolved HIVE-25338. --- Fix Version/s: 4.0.0 Resolution: Fixed > AIOBE in conv UDF if input is empty >

[jira] [Commented] (HIVE-25338) AIOBE in conv UDF if input is empty

2021-07-23 Thread Naresh P R (Jira)
[ https://issues.apache.org/jira/browse/HIVE-25338?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17385974#comment-17385974 ] Naresh P R commented on HIVE-25338: --- Thanks for the review & merge [~maheshk114] > AIOBE in conv UDF

[jira] [Commented] (HIVE-25338) AIOBE in conv UDF if input is empty

2021-07-21 Thread Naresh P R (Jira)
[ https://issues.apache.org/jira/browse/HIVE-25338?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17385252#comment-17385252 ] Naresh P R commented on HIVE-25338: --- Thanks for the analysis [~zabetak] I updated PR to return null

[jira] [Commented] (HIVE-25338) AIOBE in conv UDF if input is empty

2021-07-16 Thread Naresh P R (Jira)
[ https://issues.apache.org/jira/browse/HIVE-25338?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17382178#comment-17382178 ] Naresh P R commented on HIVE-25338: --- [~zabetak] We return 0 for invalid input. I can return the same

[jira] [Updated] (HIVE-25338) AIOBE in conv UDF if input is empty

2021-07-16 Thread Naresh P R (Jira)
[ https://issues.apache.org/jira/browse/HIVE-25338?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Naresh P R updated HIVE-25338: -- Issue Type: Bug (was: New Feature) > AIOBE in conv UDF if input is empty >

[jira] [Assigned] (HIVE-25338) AIOBE in conv UDF if input is empty

2021-07-16 Thread Naresh P R (Jira)
[ https://issues.apache.org/jira/browse/HIVE-25338?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Naresh P R reassigned HIVE-25338: - > AIOBE in conv UDF if input is empty > --- > >

[jira] [Resolved] (HIVE-25198) CTAS external table with camelcase and HMS translation ON is returning 0 records

2021-06-04 Thread Naresh P R (Jira)
[ https://issues.apache.org/jira/browse/HIVE-25198?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Naresh P R resolved HIVE-25198. --- Resolution: Duplicate > CTAS external table with camelcase and HMS translation ON is returning 0 >

[jira] [Commented] (HIVE-25198) CTAS external table with camelcase and HMS translation ON is returning 0 records

2021-06-04 Thread Naresh P R (Jira)
[ https://issues.apache.org/jira/browse/HIVE-25198?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17357461#comment-17357461 ] Naresh P R commented on HIVE-25198: --- Thanks [~Rajkumar Singh], I will close it as dup. > CTAS external

[jira] [Updated] (HIVE-25198) CTAS external table with camelcase and HMS translation ON is returning 0 records

2021-06-03 Thread Naresh P R (Jira)
[ https://issues.apache.org/jira/browse/HIVE-25198?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Naresh P R updated HIVE-25198: -- Description: create external table TarGet as select * from source; Above query creates tableLocation

[jira] [Updated] (HIVE-25198) CTAS external table with camelcase and HMS translation ON is returning 0 records

2021-06-03 Thread Naresh P R (Jira)
[ https://issues.apache.org/jira/browse/HIVE-25198?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Naresh P R updated HIVE-25198: -- Summary: CTAS external table with camelcase and HMS translation ON is returning 0 records (was: CTAS

[jira] [Assigned] (HIVE-25198) CTAS external table with camelcase & HMS translation ON is returning 0 records

2021-06-03 Thread Naresh P R (Jira)
[ https://issues.apache.org/jira/browse/HIVE-25198?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Naresh P R reassigned HIVE-25198: - > CTAS external table with camelcase & HMS translation ON is returning 0 records >

[jira] [Updated] (HIVE-25118) CTAS accepts column's with dot(.) if CBO fails

2021-05-14 Thread Naresh P R (Jira)
[ https://issues.apache.org/jira/browse/HIVE-25118?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Naresh P R updated HIVE-25118: -- Description: create table t1(id int); create table t2(id int); create table t3 as select t1.id,

[jira] [Updated] (HIVE-25118) CTAS accepts column's with dot(.) if CBO fails

2021-05-14 Thread Naresh P R (Jira)
[ https://issues.apache.org/jira/browse/HIVE-25118?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Naresh P R updated HIVE-25118: -- Description: create table t1(id int); create table t2(id int); create table t3 as select t1.id,

[jira] [Updated] (HIVE-25084) Incorrect aggregate results on bucketed table

2021-04-30 Thread Naresh P R (Jira)
[ https://issues.apache.org/jira/browse/HIVE-25084?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Naresh P R updated HIVE-25084: -- Attachment: test4.q > Incorrect aggregate results on bucketed table >

[jira] [Updated] (HIVE-23779) BasicStatsTask Info is not getting printed in beeline console

2021-03-15 Thread Naresh P R (Jira)
[ https://issues.apache.org/jira/browse/HIVE-23779?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Naresh P R updated HIVE-23779: -- Fix Version/s: 4.0.0 Resolution: Fixed Status: Resolved (was: Patch Available) >

[jira] [Commented] (HIVE-23779) BasicStatsTask Info is not getting printed in beeline console

2021-03-15 Thread Naresh P R (Jira)
[ https://issues.apache.org/jira/browse/HIVE-23779?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17302014#comment-17302014 ] Naresh P R commented on HIVE-23779: --- Thanks for the review & merge [~mgergely] > BasicStatsTask Info

[jira] [Updated] (HIVE-24882) Compaction task reattempt fails with FileAlreadyExistsException for DeleteEventWriter

2021-03-12 Thread Naresh P R (Jira)
[ https://issues.apache.org/jira/browse/HIVE-24882?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Naresh P R updated HIVE-24882: -- Status: Patch Available (was: In Progress) > Compaction task reattempt fails with

[jira] [Work started] (HIVE-24882) Compaction task reattempt fails with FileAlreadyExistsException for DeleteEventWriter

2021-03-12 Thread Naresh P R (Jira)
[ https://issues.apache.org/jira/browse/HIVE-24882?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Work on HIVE-24882 started by Naresh P R. - > Compaction task reattempt fails with FileAlreadyExistsException for >

[jira] [Updated] (HIVE-24882) Compaction task reattempt fails with FileAlreadyExistsException for DeleteEventWriter

2021-03-12 Thread Naresh P R (Jira)
[ https://issues.apache.org/jira/browse/HIVE-24882?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Naresh P R updated HIVE-24882: -- Description: If first attempt of compaction task is pre-empted by yarn or execution failed because of

[jira] [Assigned] (HIVE-24882) Compaction task reattempt fails with FileAlreadyExistsException for DeleteEventWriter

2021-03-12 Thread Naresh P R (Jira)
[ https://issues.apache.org/jira/browse/HIVE-24882?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Naresh P R reassigned HIVE-24882: - > Compaction task reattempt fails with FileAlreadyExistsException for > DeleteEventWriter >

[jira] [Updated] (HIVE-24877) Support X'xxxx' syntax for hexadecimal values like spark & mysql

2021-03-11 Thread Naresh P R (Jira)
[ https://issues.apache.org/jira/browse/HIVE-24877?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Naresh P R updated HIVE-24877: -- Description: Hive is currently not supporting following syntax select x'abc'; {code:java}

[jira] [Updated] (HIVE-24877) Support X'xxxx' syntax for hexadecimal values like spark & mysql

2021-03-11 Thread Naresh P R (Jira)
[ https://issues.apache.org/jira/browse/HIVE-24877?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Naresh P R updated HIVE-24877: -- Description: Hive is currently not supporting following syntax select x'abc'; {code:java}

[jira] [Commented] (HIVE-24757) Add UDF To Obtain HS2 Host

2021-02-09 Thread Naresh P R (Jira)
[ https://issues.apache.org/jira/browse/HIVE-24757?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17282068#comment-17282068 ] Naresh P R commented on HIVE-24757: --- I agree UDF would be better, however can u check "set 

[jira] [Updated] (HIVE-24716) jQuery file symlink is replaced by physical file which requires changes on both the places

2021-02-01 Thread Naresh P R (Jira)
[ https://issues.apache.org/jira/browse/HIVE-24716?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Naresh P R updated HIVE-24716: -- Description: HIVE-22066 replaced symlink

[jira] [Commented] (HIVE-24628) Decimal values are displayed as scientific notation in beeline

2021-01-14 Thread Naresh P R (Jira)
[ https://issues.apache.org/jira/browse/HIVE-24628?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17265046#comment-17265046 ] Naresh P R commented on HIVE-24628: --- Thanks for the review and merge [~mgergely] > Decimal values are

[jira] [Resolved] (HIVE-24628) Decimal values are displayed as scientific notation in beeline

2021-01-14 Thread Naresh P R (Jira)
[ https://issues.apache.org/jira/browse/HIVE-24628?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Naresh P R resolved HIVE-24628. --- Fix Version/s: 4.0.0 Resolution: Fixed > Decimal values are displayed as scientific notation

[jira] [Updated] (HIVE-24634) Create table if not exists should validate whether table exists before doAuth()

2021-01-13 Thread Naresh P R (Jira)
[ https://issues.apache.org/jira/browse/HIVE-24634?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Naresh P R updated HIVE-24634: -- Description: In Hive + Ranger cluster, Create table if not exist hive-ranger would validate

[jira] [Updated] (HIVE-24634) Create table if not exists should validate whether table exists before doAuth()

2021-01-13 Thread Naresh P R (Jira)
[ https://issues.apache.org/jira/browse/HIVE-24634?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Naresh P R updated HIVE-24634: -- Description: In Hive + Ranger cluster, Create table if not exist hive-ranger would validate

[jira] [Updated] (HIVE-24523) Vectorized read path for LazySimpleSerde does not honor the SERDEPROPERTIES for timestamp

2021-01-13 Thread Naresh P R (Jira)
[ https://issues.apache.org/jira/browse/HIVE-24523?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Naresh P R updated HIVE-24523: -- Fix Version/s: 4.0.0 > Vectorized read path for LazySimpleSerde does not honor the SERDEPROPERTIES >

[jira] [Updated] (HIVE-24628) Decimal values are displayed as scientific notation in beeline

2021-01-13 Thread Naresh P R (Jira)
[ https://issues.apache.org/jira/browse/HIVE-24628?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Naresh P R updated HIVE-24628: -- Component/s: Beeline > Decimal values are displayed as scientific notation in beeline >

[jira] [Updated] (HIVE-24628) Decimal values are displayed as scientific notation in beeline

2021-01-12 Thread Naresh P R (Jira)
[ https://issues.apache.org/jira/browse/HIVE-24628?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Naresh P R updated HIVE-24628: -- Labels: pull-request-available (was: ) > Decimal values are displayed as scientific notation in

[jira] [Updated] (HIVE-24628) Decimal values are displayed as scientific notation in beeline

2021-01-12 Thread Naresh P R (Jira)
[ https://issues.apache.org/jira/browse/HIVE-24628?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Naresh P R updated HIVE-24628: -- Summary: Decimal values are displayed as scientific notation in beeline (was: Decimal values are

[jira] [Assigned] (HIVE-24628) Decimal values are displayed as Scientific notation in beeline

2021-01-12 Thread Naresh P R (Jira)
[ https://issues.apache.org/jira/browse/HIVE-24628?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Naresh P R reassigned HIVE-24628: - > Decimal values are displayed as Scientific notation in beeline >

[jira] [Assigned] (HIVE-24523) Vectorized read path for LazySimpleSerde does not honor the SERDEPROPERTIES for timestamp

2021-01-04 Thread Naresh P R (Jira)
[ https://issues.apache.org/jira/browse/HIVE-24523?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Naresh P R reassigned HIVE-24523: - Assignee: Naresh P R > Vectorized read path for LazySimpleSerde does not honor the

[jira] [Commented] (HIVE-24523) Vectorized read path for LazySimpleSerde does not honor the SERDEPROPERTIES for timestamp

2020-12-26 Thread Naresh P R (Jira)
[ https://issues.apache.org/jira/browse/HIVE-24523?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17255161#comment-17255161 ] Naresh P R commented on HIVE-24523: --- [~Rajkumar Singh] If you are not working, can i work on this ? >

[jira] [Resolved] (HIVE-24305) avro decimal schema is not properly populating scale/precision if value is enclosed in quote

2020-12-24 Thread Naresh P R (Jira)
[ https://issues.apache.org/jira/browse/HIVE-24305?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Naresh P R resolved HIVE-24305. --- Fix Version/s: 4.0.0 Resolution: Fixed > avro decimal schema is not properly populating

[jira] [Commented] (HIVE-24305) avro decimal schema is not properly populating scale/precision if value is enclosed in quote

2020-12-24 Thread Naresh P R (Jira)
[ https://issues.apache.org/jira/browse/HIVE-24305?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17254737#comment-17254737 ] Naresh P R commented on HIVE-24305: --- Thanks for the review & commit [~lpinter].    > avro decimal

[jira] [Updated] (HIVE-24433) AutoCompaction is not getting triggered for CamelCase Partition Values

2020-11-26 Thread Naresh P R (Jira)
[ https://issues.apache.org/jira/browse/HIVE-24433?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Naresh P R updated HIVE-24433: -- Description: PartionKeyValue is getting converted into lowerCase in below 2 places.

[jira] [Updated] (HIVE-24433) AutoCompaction is not getting triggered for CamelCase Partition Values

2020-11-25 Thread Naresh P R (Jira)
[ https://issues.apache.org/jira/browse/HIVE-24433?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Naresh P R updated HIVE-24433: -- Description: PartionKeyValue is getting converted into lowerCase in below 2 places.

[jira] [Updated] (HIVE-24433) AutoCompaction is not getting triggered for CamelCase Partition Values

2020-11-25 Thread Naresh P R (Jira)
[ https://issues.apache.org/jira/browse/HIVE-24433?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Naresh P R updated HIVE-24433: -- Description: PartionKeyValue is getting converted into lowerCase in below 2 places.

[jira] [Updated] (HIVE-24433) AutoCompaction is not getting triggered for CamelCase Partition Values

2020-11-25 Thread Naresh P R (Jira)
[ https://issues.apache.org/jira/browse/HIVE-24433?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Naresh P R updated HIVE-24433: -- Description: PartionKeyValue is getting converted into lowerCase in below 2 places.

[jira] [Updated] (HIVE-24433) AutoCompaction is not getting triggered for CamelCase Partition Values

2020-11-25 Thread Naresh P R (Jira)
[ https://issues.apache.org/jira/browse/HIVE-24433?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Naresh P R updated HIVE-24433: -- Description: PartionKeyValue is getting converted into lowerCase in below 2 places.

[jira] [Assigned] (HIVE-24433) AutoCompaction is not getting triggered for CamelCase Partition Values

2020-11-25 Thread Naresh P R (Jira)
[ https://issues.apache.org/jira/browse/HIVE-24433?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Naresh P R reassigned HIVE-24433: - > AutoCompaction is not getting triggered for CamelCase Partition Values >

[jira] [Updated] (HIVE-24381) compressed text input returns 0 rows if skip header/footer is mentioned.

2020-11-12 Thread Naresh P R (Jira)
[ https://issues.apache.org/jira/browse/HIVE-24381?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Naresh P R updated HIVE-24381: -- Attachment: test.q > compressed text input returns 0 rows if skip header/footer is mentioned. >

[jira] [Assigned] (HIVE-24381) compressed text input returns 0 rows if skip header/footer is mentioned.

2020-11-12 Thread Naresh P R (Jira)
[ https://issues.apache.org/jira/browse/HIVE-24381?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Naresh P R reassigned HIVE-24381: - > compressed text input returns 0 rows if skip header/footer is mentioned. >

[jira] [Comment Edited] (HIVE-24294) TezSessionPool sessions can throw AssertionError

2020-10-29 Thread Naresh P R (Jira)
[ https://issues.apache.org/jira/browse/HIVE-24294?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17223178#comment-17223178 ] Naresh P R edited comment on HIVE-24294 at 10/29/20, 7:48 PM: -- Thanks for

  1   2   3   4   >