FourFriends commented on code in PR #6574:
URL: https://github.com/apache/gravitino/pull/6574#discussion_r1999977896
##########
core/src/main/java/org/apache/gravitino/storage/relational/mapper/provider/base/SchemaMetaBaseSQLProvider.java:
##########
@@ -190,4 +190,21 @@ public String deleteSchemaMetasByLegacyTimeline(
+ TABLE_NAME
+ " WHERE deleted_at > 0 AND deleted_at < #{legacyTimeline} LIMIT
#{limit}";
}
+
+ public String selectSchemaIdByMetalakeNameAndCatalogNameAndSchemaName(
+ @Param("metalakeName") String metalakeName,
+ @Param("catalogName") String catalogName,
+ @Param("schemaName") String schemaName) {
+ return "SELECT metalake_meta.metalake_id as metalakeId,
catalog_meta.catalog_id as catalogId, "
+ + " schema_id as schemaId"
+ + " FROM metalake_meta"
+ + " JOIN catalog_meta ON metalake_meta.metalake_id =
catalog_meta.metalake_id"
Review Comment:
We have confirmed that this join has no impact on internal usage at Xiaomi.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscr...@gravitino.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
