[INLONG-11984][Manager] Fix the problem of Hive table creation statement error (#11985)

fuweng11 · web-flow · commit 0f52caeaf67f · 2025-09-05T10:25:42.000+08:00
diff --git a/inlong-manager/manager-service/src/main/java/org/apache/inlong/manager/service/resource/sink/hive/SqlBuilder.java b/inlong-manager/manager-service/src/main/java/org/apache/inlong/manager/service/resource/sink/hive/SqlBuilder.java
@@ -50,7 +50,7 @@ public static String buildCreateDbSql(String dbName) {
     public static String buildCreateTableSql(HiveTableInfo table) {
         StringBuilder sql = new StringBuilder();
         // Support _ beginning with underscore
-        String dbTableName = "`" + table.getDbName() + "." + table.getTableName() + "`";
+        String dbTableName = "`" + table.getDbName() + "`.`" + table.getTableName() + "`";
         sql.append("CREATE TABLE ").append(dbTableName);
 
         // Construct columns and partition columns
@@ -68,7 +68,7 @@ public static String buildCreateTableSql(HiveTableInfo table) {
      */
     public static String buildDescTableSql(String dbName, String tableName) {
         StringBuilder sql = new StringBuilder();
-        String fullTableName = "`" + dbName + "." + tableName + "`";
+        String fullTableName = "`" + dbName + "`.`" + tableName + "`";
         sql.append("DESC ").append(fullTableName);
 
         LOGGER.info("desc table sql={}", sql);
@@ -81,7 +81,7 @@ public static String buildDescTableSql(String dbName, String tableName) {
     public static String buildAddColumnSql(String dbName, String tableName, List<HiveColumnInfo> columnList) {
         StringBuilder sql = new StringBuilder();
         // Support _ beginning with underscore
-        String dbTableName = "`" + dbName + "." + tableName + "`";
+        String dbTableName = "`" + dbName + "`.`" + tableName + "`";
         sql.append("ALTER TABLE ").append(dbTableName);
 
         // add columns
