This is an automated email from the ASF dual-hosted git repository.
xxyu pushed a commit to branch kylin5
in repository https://gitbox.apache.org/repos/asf/kylin.git
commit 6309697701c6ec984a8120d020e9d6c2f947da46
Author: Jiale He <965374...@qq.com>
AuthorDate: Fri Mar 3 19:07:30 2023 +0800
KYLIN-5523 [FOLLOW UP] fix generate flat table sql
---
.../src/main/java/org/apache/kylin/query/util/PushDownUtil.java | 3 ++-
.../test/java/org/apache/kylin/query/util/PushDownUtilTest.java | 8 ++++----
2 files changed, 6 insertions(+), 5 deletions(-)
diff --git
a/src/query-common/src/main/java/org/apache/kylin/query/util/PushDownUtil.java
b/src/query-common/src/main/java/org/apache/kylin/query/util/PushDownUtil.java
index 2f0558d246..4f7f467e17 100644
---
a/src/query-common/src/main/java/org/apache/kylin/query/util/PushDownUtil.java
+++
b/src/query-common/src/main/java/org/apache/kylin/query/util/PushDownUtil.java
@@ -244,7 +244,8 @@ public class PushDownUtil {
sqlBuilder.append(allColStr);
}
- sqlBuilder.append("FROM
").append(model.getRootFactTable().getTableDesc().getDoubleQuoteIdentity());
+ sqlBuilder.append("FROM
").append(model.getRootFactTable().getTableDesc().getDoubleQuoteIdentity())
+ .append(" as
").append(StringHelper.doubleQuote(model.getRootFactTable().getAlias()));
appendJoinStatement(model, sqlBuilder, singleLine);
sqlBuilder.append("WHERE ").append(sep);
diff --git
a/src/query/src/test/java/org/apache/kylin/query/util/PushDownUtilTest.java
b/src/query/src/test/java/org/apache/kylin/query/util/PushDownUtilTest.java
index 804fd81ab7..379af78e8e 100644
--- a/src/query/src/test/java/org/apache/kylin/query/util/PushDownUtilTest.java
+++ b/src/query/src/test/java/org/apache/kylin/query/util/PushDownUtilTest.java
@@ -162,7 +162,7 @@ public class PushDownUtilTest extends
NLocalFileMetadataTestCase {
+ ", \"TEST_BANK_LOCATION\".\"COUNTRY\" as
\"TEST_BANK_LOCATION_COUNTRY\"\n"
+ ", \"TEST_BANK_LOCATION\".\"OWNER\" as
\"TEST_BANK_LOCATION_OWNER\"\n"
+ ", \"TEST_BANK_LOCATION\".\"LOCATION\" as
\"TEST_BANK_LOCATION_LOCATION\"\n"
- + "FROM \"DEFAULT\".\"TEST_BANK_INCOME\"\n"
+ + "FROM \"DEFAULT\".\"TEST_BANK_INCOME\" as
\"TEST_BANK_INCOME\"\n"
+ "INNER JOIN \"DEFAULT\".\"TEST_BANK_LOCATION\" as
\"TEST_BANK_LOCATION\"\n"
+ "ON \"TEST_BANK_INCOME\".\"COUNTRY\" =
\"TEST_BANK_LOCATION\".\"COUNTRY\"\n" //
+ "WHERE\n" //
@@ -198,7 +198,7 @@ public class PushDownUtilTest extends
NLocalFileMetadataTestCase {
+ ", \"TEST_BANK_LOCATION\".\"COUNTRY\" as
\"TEST_BANK_LOCATION_COUNTRY\"\n"
+ ", \"TEST_BANK_LOCATION\".\"OWNER\" as
\"TEST_BANK_LOCATION_OWNER\"\n"
+ ", \"TEST_BANK_LOCATION\".\"LOCATION\" as
\"TEST_BANK_LOCATION_LOCATION\"\n"
- + "FROM \"DEFAULT\".\"TEST_BANK_INCOME\"\n"
+ + "FROM \"DEFAULT\".\"TEST_BANK_INCOME\" as
\"TEST_BANK_INCOME\"\n"
+ "INNER JOIN \"DEFAULT\".\"TEST_BANK_LOCATION\" as
\"TEST_BANK_LOCATION\"\n"
+ "ON SUBSTRING(\"TEST_BANK_INCOME\".\"COUNTRY\", 0, 4) =
\"TEST_BANK_LOCATION\".\"COUNTRY\"\n"
+ "WHERE\n" //
@@ -232,7 +232,7 @@ public class PushDownUtilTest extends
NLocalFileMetadataTestCase {
+ ", \"TEST_BANK_LOCATION\".\"COUNTRY\" as
\"TEST_BANK_LOCATION_COUNTRY\"\n"
+ ", \"TEST_BANK_LOCATION\".\"OWNER\" as
\"TEST_BANK_LOCATION_OWNER\"\n"
+ ", \"TEST_BANK_LOCATION\".\"LOCATION\" as
\"TEST_BANK_LOCATION_LOCATION\"\n"
- + "FROM \"DEFAULT\".\"TEST_BANK_INCOME\"\n"
+ + "FROM \"DEFAULT\".\"TEST_BANK_INCOME\" as
\"TEST_BANK_INCOME\"\n"
+ "INNER JOIN \"DEFAULT\".\"TEST_BANK_LOCATION\" as
\"TEST_BANK_LOCATION\"\n"
+ "ON \"TEST_BANK_INCOME\".\"COUNTRY\" =
\"TEST_BANK_LOCATION\".\"COUNTRY\"\n" //
+ "WHERE\n" //
@@ -265,7 +265,7 @@ public class PushDownUtilTest extends
NLocalFileMetadataTestCase {
+ ", \"TEST_BANK_LOCATION\".\"COUNTRY\" as
\"TEST_BANK_LOCATION_COUNTRY\"\n"
+ ", \"TEST_BANK_LOCATION\".\"OWNER\" as
\"TEST_BANK_LOCATION_OWNER\"\n"
+ ", \"TEST_BANK_LOCATION\".\"LOCATION\" as
\"TEST_BANK_LOCATION_LOCATION\"\n"
- + "FROM \"DEFAULT\".\"TEST_BANK_INCOME\"\n"
+ + "FROM \"DEFAULT\".\"TEST_BANK_INCOME\" as
\"TEST_BANK_INCOME\"\n"
+ "INNER JOIN \"DEFAULT\".\"TEST_BANK_LOCATION\" as
\"TEST_BANK_LOCATION\"\n"
+ "ON \"TEST_BANK_INCOME\".\"COUNTRY\" =
\"TEST_BANK_LOCATION\".\"COUNTRY\"\n" //
+ "WHERE\n" //
