You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@kylin.apache.org by xx...@apache.org on 2020/06/15 02:51:23 UTC
[kylin] 07/15: KYLIN-4419 Refine IT sqls with adding order by
This is an automated email from the ASF dual-hosted git repository.
xxyu pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/kylin.git
commit 67f347ba68093fb79b791b80ab959dd1921c8054
Author: Zhong, Yanghong <nj...@apache.org>
AuthorDate: Mon May 11 17:46:07 2020 +0800
KYLIN-4419 Refine IT sqls with adding order by
---
kylin-it/src/test/resources/query/sql_timestamp/query01.sql | 1 +
kylin-it/src/test/resources/query/sql_timestamp/query02.sql | 1 +
kylin-it/src/test/resources/query/sql_timestamp/query03.sql | 1 +
kylin-it/src/test/resources/query/sql_timestamp/query05.sql | 1 +
kylin-it/src/test/resources/query/sql_timestamp/query11.sql | 1 +
kylin-it/src/test/resources/query/sql_timestamp/query12.sql | 1 +
kylin-it/src/test/resources/query/sql_timestamp/query13.sql | 1 +
kylin-it/src/test/resources/query/sql_timestamp/query14.sql | 1 +
kylin-it/src/test/resources/query/sql_timestamp/query21.sql | 1 +
kylin-it/src/test/resources/query/sql_timestamp/query21_a.sql | 1 +
kylin-it/src/test/resources/query/sql_timestamp/query22.sql | 1 +
kylin-it/src/test/resources/query/sql_timestamp/query22_a.sql | 1 +
kylin-it/src/test/resources/query/sql_timestamp/query22_b.sql | 1 +
kylin-it/src/test/resources/query/sql_timestamp/query22_c.sql | 1 +
kylin-it/src/test/resources/query/sql_timestamp/query22_d.sql | 1 +
kylin-it/src/test/resources/query/sql_timestamp/query22_e.sql | 1 +
kylin-it/src/test/resources/query/sql_timestamp/query23.sql | 1 +
kylin-it/src/test/resources/query/sql_timestamp/query23_a.sql | 1 +
kylin-it/src/test/resources/query/sql_timestamp/query25.sql | 1 +
kylin-it/src/test/resources/query/sql_timestamp/query25_a.sql | 1 +
20 files changed, 20 insertions(+)
diff --git a/kylin-it/src/test/resources/query/sql_timestamp/query01.sql b/kylin-it/src/test/resources/query/sql_timestamp/query01.sql
index 08e13a2..86a99dc 100644
--- a/kylin-it/src/test/resources/query/sql_timestamp/query01.sql
+++ b/kylin-it/src/test/resources/query/sql_timestamp/query01.sql
@@ -26,3 +26,4 @@ inner JOIN edw.test_cal_dt as test_cal_dt
inner JOIN edw.test_sites as test_sites
ON test_kylin_fact.lstg_site_id = test_sites.site_id
GROUP BY test_kylin_fact.cal_dt
+ ORDER BY test_kylin_fact.cal_dt
\ No newline at end of file
diff --git a/kylin-it/src/test/resources/query/sql_timestamp/query02.sql b/kylin-it/src/test/resources/query/sql_timestamp/query02.sql
index f372212..1b61f34 100644
--- a/kylin-it/src/test/resources/query/sql_timestamp/query02.sql
+++ b/kylin-it/src/test/resources/query/sql_timestamp/query02.sql
@@ -26,3 +26,4 @@ inner JOIN edw.test_cal_dt as test_cal_dt
inner JOIN edw.test_sites as test_sites
ON test_kylin_fact.lstg_site_id = test_sites.site_id
GROUP BY test_kylin_fact.cal_dt
+ ORDER BY test_kylin_fact.cal_dt
\ No newline at end of file
diff --git a/kylin-it/src/test/resources/query/sql_timestamp/query03.sql b/kylin-it/src/test/resources/query/sql_timestamp/query03.sql
index 0dc76bd..5db0fe5 100644
--- a/kylin-it/src/test/resources/query/sql_timestamp/query03.sql
+++ b/kylin-it/src/test/resources/query/sql_timestamp/query03.sql
@@ -26,3 +26,4 @@ inner JOIN edw.test_cal_dt as test_cal_dt
inner JOIN edw.test_sites as test_sites
ON test_kylin_fact.lstg_site_id = test_sites.site_id
GROUP BY test_kylin_fact.cal_dt
+ ORDER BY test_kylin_fact.cal_dt
\ No newline at end of file
diff --git a/kylin-it/src/test/resources/query/sql_timestamp/query05.sql b/kylin-it/src/test/resources/query/sql_timestamp/query05.sql
index 171f473..470e8f1 100644
--- a/kylin-it/src/test/resources/query/sql_timestamp/query05.sql
+++ b/kylin-it/src/test/resources/query/sql_timestamp/query05.sql
@@ -26,3 +26,4 @@ inner JOIN edw.test_cal_dt as test_cal_dt
inner JOIN edw.test_sites as test_sites
ON test_kylin_fact.lstg_site_id = test_sites.site_id
GROUP BY test_kylin_fact.cal_dt
+ ORDER BY test_kylin_fact.cal_dt
\ No newline at end of file
diff --git a/kylin-it/src/test/resources/query/sql_timestamp/query11.sql b/kylin-it/src/test/resources/query/sql_timestamp/query11.sql
index edb3d54..f24dfae 100644
--- a/kylin-it/src/test/resources/query/sql_timestamp/query11.sql
+++ b/kylin-it/src/test/resources/query/sql_timestamp/query11.sql
@@ -19,3 +19,4 @@ SELECT sum(price) as sum_price
FROM TEST_KYLIN_FACT
WHERE CAL_DT > cast(TIMESTAMPADD(Day, -15000, CURRENT_DATE) as DATE)
GROUP BY CAL_DT
+ORDER BY CAL_DT
\ No newline at end of file
diff --git a/kylin-it/src/test/resources/query/sql_timestamp/query12.sql b/kylin-it/src/test/resources/query/sql_timestamp/query12.sql
index 73b432f..dad4920 100644
--- a/kylin-it/src/test/resources/query/sql_timestamp/query12.sql
+++ b/kylin-it/src/test/resources/query/sql_timestamp/query12.sql
@@ -19,3 +19,4 @@ SELECT sum(price) as sum_price
FROM TEST_KYLIN_FACT
WHERE CAL_DT > cast(TIMESTAMPADD(Day, -2000, CURRENT_DATE) as DATE)
GROUP BY CAL_DT
+ORDER BY CAL_DT
\ No newline at end of file
diff --git a/kylin-it/src/test/resources/query/sql_timestamp/query13.sql b/kylin-it/src/test/resources/query/sql_timestamp/query13.sql
index fed0b73..98cb4d7 100644
--- a/kylin-it/src/test/resources/query/sql_timestamp/query13.sql
+++ b/kylin-it/src/test/resources/query/sql_timestamp/query13.sql
@@ -19,3 +19,4 @@ SELECT sum(price) as sum_price
FROM TEST_KYLIN_FACT
WHERE CAL_DT > cast(TIMESTAMPADD(Day, -0, CURRENT_TIMESTAMP) as DATE)
GROUP BY CAL_DT
+ORDER BY CAL_DT
\ No newline at end of file
diff --git a/kylin-it/src/test/resources/query/sql_timestamp/query14.sql b/kylin-it/src/test/resources/query/sql_timestamp/query14.sql
index 40378b9..89426b5 100644
--- a/kylin-it/src/test/resources/query/sql_timestamp/query14.sql
+++ b/kylin-it/src/test/resources/query/sql_timestamp/query14.sql
@@ -19,3 +19,4 @@ SELECT sum(price) as sum_price
FROM TEST_KYLIN_FACT
WHERE CAL_DT > cast(TIMESTAMPADD(Day, -15000, CURRENT_TIMESTAMP ) as DATE)
GROUP BY CAL_DT
+ORDER BY CAL_DT
\ No newline at end of file
diff --git a/kylin-it/src/test/resources/query/sql_timestamp/query21.sql b/kylin-it/src/test/resources/query/sql_timestamp/query21.sql
index d1b8945..e0e883c 100644
--- a/kylin-it/src/test/resources/query/sql_timestamp/query21.sql
+++ b/kylin-it/src/test/resources/query/sql_timestamp/query21.sql
@@ -26,3 +26,4 @@ inner JOIN edw.test_cal_dt as test_cal_dt
inner JOIN edw.test_sites as test_sites
ON test_kylin_fact.lstg_site_id = test_sites.site_id
GROUP BY test_kylin_fact.cal_dt
+ ORDER BY test_kylin_fact.cal_dt
\ No newline at end of file
diff --git a/kylin-it/src/test/resources/query/sql_timestamp/query21_a.sql b/kylin-it/src/test/resources/query/sql_timestamp/query21_a.sql
index 1d4d617..56324f6 100644
--- a/kylin-it/src/test/resources/query/sql_timestamp/query21_a.sql
+++ b/kylin-it/src/test/resources/query/sql_timestamp/query21_a.sql
@@ -26,3 +26,4 @@ inner JOIN edw.test_cal_dt as test_cal_dt
inner JOIN edw.test_sites as test_sites
ON test_kylin_fact.lstg_site_id = test_sites.site_id
GROUP BY test_kylin_fact.cal_dt
+ ORDER BY test_kylin_fact.cal_dt
\ No newline at end of file
diff --git a/kylin-it/src/test/resources/query/sql_timestamp/query22.sql b/kylin-it/src/test/resources/query/sql_timestamp/query22.sql
index 34524c2..eadcabc 100644
--- a/kylin-it/src/test/resources/query/sql_timestamp/query22.sql
+++ b/kylin-it/src/test/resources/query/sql_timestamp/query22.sql
@@ -26,3 +26,4 @@ inner JOIN edw.test_cal_dt as test_cal_dt
inner JOIN edw.test_sites as test_sites
ON test_kylin_fact.lstg_site_id = test_sites.site_id
GROUP BY test_kylin_fact.cal_dt
+ ORDER BY test_kylin_fact.cal_dt
\ No newline at end of file
diff --git a/kylin-it/src/test/resources/query/sql_timestamp/query22_a.sql b/kylin-it/src/test/resources/query/sql_timestamp/query22_a.sql
index d68a354..ff7c7a6 100644
--- a/kylin-it/src/test/resources/query/sql_timestamp/query22_a.sql
+++ b/kylin-it/src/test/resources/query/sql_timestamp/query22_a.sql
@@ -26,3 +26,4 @@ inner JOIN edw.test_cal_dt as test_cal_dt
inner JOIN edw.test_sites as test_sites
ON test_kylin_fact.lstg_site_id = test_sites.site_id
GROUP BY test_kylin_fact.cal_dt
+ ORDER BY test_kylin_fact.cal_dt
\ No newline at end of file
diff --git a/kylin-it/src/test/resources/query/sql_timestamp/query22_b.sql b/kylin-it/src/test/resources/query/sql_timestamp/query22_b.sql
index 4d4fa98..0c996a2 100644
--- a/kylin-it/src/test/resources/query/sql_timestamp/query22_b.sql
+++ b/kylin-it/src/test/resources/query/sql_timestamp/query22_b.sql
@@ -26,3 +26,4 @@ inner JOIN edw.test_cal_dt as test_cal_dt
inner JOIN edw.test_sites as test_sites
ON test_kylin_fact.lstg_site_id = test_sites.site_id
GROUP BY test_kylin_fact.cal_dt
+ ORDER BY test_kylin_fact.cal_dt
\ No newline at end of file
diff --git a/kylin-it/src/test/resources/query/sql_timestamp/query22_c.sql b/kylin-it/src/test/resources/query/sql_timestamp/query22_c.sql
index d8e8096..b491c4b 100644
--- a/kylin-it/src/test/resources/query/sql_timestamp/query22_c.sql
+++ b/kylin-it/src/test/resources/query/sql_timestamp/query22_c.sql
@@ -26,3 +26,4 @@ inner JOIN edw.test_cal_dt as test_cal_dt
inner JOIN edw.test_sites as test_sites
ON test_kylin_fact.lstg_site_id = test_sites.site_id
GROUP BY test_kylin_fact.cal_dt
+ ORDER BY test_kylin_fact.cal_dt
\ No newline at end of file
diff --git a/kylin-it/src/test/resources/query/sql_timestamp/query22_d.sql b/kylin-it/src/test/resources/query/sql_timestamp/query22_d.sql
index 5bf36dd..e213299 100644
--- a/kylin-it/src/test/resources/query/sql_timestamp/query22_d.sql
+++ b/kylin-it/src/test/resources/query/sql_timestamp/query22_d.sql
@@ -26,3 +26,4 @@ inner JOIN edw.test_cal_dt as test_cal_dt
inner JOIN edw.test_sites as test_sites
ON test_kylin_fact.lstg_site_id = test_sites.site_id
GROUP BY test_kylin_fact.cal_dt
+ ORDER BY test_kylin_fact.cal_dt
\ No newline at end of file
diff --git a/kylin-it/src/test/resources/query/sql_timestamp/query22_e.sql b/kylin-it/src/test/resources/query/sql_timestamp/query22_e.sql
index bb36d83..fc73a60 100644
--- a/kylin-it/src/test/resources/query/sql_timestamp/query22_e.sql
+++ b/kylin-it/src/test/resources/query/sql_timestamp/query22_e.sql
@@ -26,3 +26,4 @@ inner JOIN edw.test_cal_dt as test_cal_dt
inner JOIN edw.test_sites as test_sites
ON test_kylin_fact.lstg_site_id = test_sites.site_id
GROUP BY test_kylin_fact.cal_dt
+ ORDER BY test_kylin_fact.cal_dt
\ No newline at end of file
diff --git a/kylin-it/src/test/resources/query/sql_timestamp/query23.sql b/kylin-it/src/test/resources/query/sql_timestamp/query23.sql
index 9050894..1c4b16a 100644
--- a/kylin-it/src/test/resources/query/sql_timestamp/query23.sql
+++ b/kylin-it/src/test/resources/query/sql_timestamp/query23.sql
@@ -26,3 +26,4 @@ inner JOIN edw.test_cal_dt as test_cal_dt
inner JOIN edw.test_sites as test_sites
ON test_kylin_fact.lstg_site_id = test_sites.site_id
GROUP BY test_kylin_fact.cal_dt
+ ORDER BY test_kylin_fact.cal_dt
\ No newline at end of file
diff --git a/kylin-it/src/test/resources/query/sql_timestamp/query23_a.sql b/kylin-it/src/test/resources/query/sql_timestamp/query23_a.sql
index f3f7141..34cf1f3 100644
--- a/kylin-it/src/test/resources/query/sql_timestamp/query23_a.sql
+++ b/kylin-it/src/test/resources/query/sql_timestamp/query23_a.sql
@@ -26,3 +26,4 @@ inner JOIN edw.test_cal_dt as test_cal_dt
inner JOIN edw.test_sites as test_sites
ON test_kylin_fact.lstg_site_id = test_sites.site_id
GROUP BY test_kylin_fact.cal_dt
+ ORDER BY test_kylin_fact.cal_dt
\ No newline at end of file
diff --git a/kylin-it/src/test/resources/query/sql_timestamp/query25.sql b/kylin-it/src/test/resources/query/sql_timestamp/query25.sql
index 2fb8b23..8b239ea 100644
--- a/kylin-it/src/test/resources/query/sql_timestamp/query25.sql
+++ b/kylin-it/src/test/resources/query/sql_timestamp/query25.sql
@@ -26,3 +26,4 @@ inner JOIN edw.test_cal_dt as test_cal_dt
inner JOIN edw.test_sites as test_sites
ON test_kylin_fact.lstg_site_id = test_sites.site_id
GROUP BY test_kylin_fact.cal_dt
+ ORDER BY test_kylin_fact.cal_dt
\ No newline at end of file
diff --git a/kylin-it/src/test/resources/query/sql_timestamp/query25_a.sql b/kylin-it/src/test/resources/query/sql_timestamp/query25_a.sql
index 2034f19..d379c58 100644
--- a/kylin-it/src/test/resources/query/sql_timestamp/query25_a.sql
+++ b/kylin-it/src/test/resources/query/sql_timestamp/query25_a.sql
@@ -26,3 +26,4 @@ inner JOIN edw.test_cal_dt as test_cal_dt
inner JOIN edw.test_sites as test_sites
ON test_kylin_fact.lstg_site_id = test_sites.site_id
GROUP BY test_kylin_fact.cal_dt
+ ORDER BY test_kylin_fact.cal_dt
\ No newline at end of file