[
https://issues.apache.org/jira/browse/HIVE-29039?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17985712#comment-17985712
]
Raghav Aggarwal commented on HIVE-29039:
----------------------------------------
Thanks for looking into this [~dkuzmenko] . HIVE-28985 was created to improve
the testing of DirectSQL.
> 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)
