[ https://issues.apache.org/jira/browse/HIVE-29039 ]
Denys Kuzmenko deleted comment on HIVE-29039:
---------------------------------------
was (Author: dkuzmenko):
[~Aggarwal_Raghav], have you tried with
https://github.com/apache/hive/pull/5883?
> 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)
