You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Denys Kuzmenko (Jira)" <ji...@apache.org> on 2025/06/23 20:18:00 UTC

[jira] [Comment Edited] (HIVE-29039) DirectSQL for alterPartitions is failing

    [ https://issues.apache.org/jira/browse/HIVE-29039?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17985711#comment-17985711 ] 

Denys Kuzmenko edited comment on HIVE-29039 at 6/23/25 8:17 PM:
----------------------------------------------------------------

The root cause is the same as in HIVE-29030


was (Author: dkuzmenko):
probable it's similar to HIVE-29030

> DirectSQL for alterPartitions is failing
> ----------------------------------------
>
>                 Key: HIVE-29039
>                 URL: https://issues.apache.org/jira/browse/HIVE-29039
>             Project: Hive
>          Issue Type: Bug
>          Components: Standalone Metastore
>            Reporter: Raghav Aggarwal
>            Assignee: Raghav Aggarwal
>            Priority: Major
>              Labels: hive-4.1.0-must
>         Attachments: IntelliJ-Debugging.png, create_tbl.sql
>
>
> HMS Logs:
> {code:java}
> 2025-06-23 20:56:43,727 WARN metastore.ObjectStore: Falling back to ORM path due to direct SQL failure (this is not an error): Identity type is not datastore. at org.apache.hadoop.hive.metastore.DirectSqlUpdatePart.getDataStoreId(DirectSqlUpdatePart.java:1093) at org.apache.hadoop.hive.metastore.DirectSqlUpdatePart.updateCDInBatch(DirectSqlUpdatePart.java:1259) at org.apache.hadoop.hive.metastore.DirectSqlUpdatePart.updateStorageDescriptorInBatch(DirectSqlUpdatePart.java:881) at org.apache.hadoop.hive.metastore.DirectSqlUpdatePart.alterPartitions(DirectSqlUpdatePart.java:631) at org.apache.hadoop.hive.metastore.MetaStoreDirectSql.alterPartitions(MetaStoreDirectSql.java:579) at org.apache.hadoop.hive.metastore.ObjectStore$22.getSqlResult(ObjectStore.java:5321)
> 2025-06-23 20:56:45,138 WARN metastore.ObjectStore: Falling back to ORM path due to direct SQL failure (this is not an error): Identity type is not datastore. at org.apache.hadoop.hive.metastore.DirectSqlUpdatePart.getDataStoreId(DirectSqlUpdatePart.java:1093) at org.apache.hadoop.hive.metastore.DirectSqlUpdatePart.updateCDInBatch(DirectSqlUpdatePart.java:1259) at org.apache.hadoop.hive.metastore.DirectSqlUpdatePart.updateStorageDescriptorInBatch(DirectSqlUpdatePart.java:881) at org.apache.hadoop.hive.metastore.DirectSqlUpdatePart.alterPartitions(DirectSqlUpdatePart.java:631) at org.apache.hadoop.hive.metastore.MetaStoreDirectSql.alterPartitions(MetaStoreDirectSql.java:579) at org.apache.hadoop.hive.metastore.ObjectStore$22.getSqlResult(ObjectStore.java:5321) {code}
>  
> To repro, follow create_tbl.sql



--
This message was sent by Atlassian Jira
(v8.20.10#820010)