You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by ji...@apache.org on 2022/07/28 00:34:50 UTC
[doris-website] branch master updated: Modify the Star-Schema-Benchmark test sql syntax error (#17)
This is an automated email from the ASF dual-hosted git repository.
jiafengzheng pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/doris-website.git
The following commit(s) were added to refs/heads/master by this push:
new f98282566d9 Modify the Star-Schema-Benchmark test sql syntax error (#17)
f98282566d9 is described below
commit f98282566d9201f74c02855e6781724def551a38
Author: caoliang-web <71...@users.noreply.github.com>
AuthorDate: Thu Jul 28 08:34:45 2022 +0800
Modify the Star-Schema-Benchmark test sql syntax error (#17)
---
docs/benchmark/ssb.md | 2 +-
i18n/zh-CN/docusaurus-plugin-content-docs/current/benchmark/ssb.md | 2 +-
2 files changed, 2 insertions(+), 2 deletions(-)
diff --git a/docs/benchmark/ssb.md b/docs/benchmark/ssb.md
index 66b3b1493d1..e73ba27e9e7 100644
--- a/docs/benchmark/ssb.md
+++ b/docs/benchmark/ssb.md
@@ -367,7 +367,7 @@ ORDER BY YEAR ASC, revenue DESC;
--Q4.1
SELECT (LO_ORDERDATE DIV 10000) AS YEAR, C_NATION, SUM(LO_REVENUE - LO_SUPPLYCOST) AS profit
FROM lineorder_flat
-WHERE C_REGION = 'AMERICA' ND S_REGION = 'AMERICA' AND P_MFGR IN ('MFGR#1', 'MFGR#2')
+WHERE C_REGION = 'AMERICA' AND S_REGION = 'AMERICA' AND P_MFGR IN ('MFGR#1', 'MFGR#2')
GROUP BY YEAR, C_NATION
ORDER BY YEAR ASC, C_NATION ASC;
diff --git a/i18n/zh-CN/docusaurus-plugin-content-docs/current/benchmark/ssb.md b/i18n/zh-CN/docusaurus-plugin-content-docs/current/benchmark/ssb.md
index 27619928c83..5cbc2055667 100644
--- a/i18n/zh-CN/docusaurus-plugin-content-docs/current/benchmark/ssb.md
+++ b/i18n/zh-CN/docusaurus-plugin-content-docs/current/benchmark/ssb.md
@@ -368,7 +368,7 @@ ORDER BY YEAR ASC, revenue DESC;
--Q4.1
SELECT (LO_ORDERDATE DIV 10000) AS YEAR, C_NATION, SUM(LO_REVENUE - LO_SUPPLYCOST) AS profit
FROM lineorder_flat
-WHERE C_REGION = 'AMERICA' ND S_REGION = 'AMERICA' AND P_MFGR IN ('MFGR#1', 'MFGR#2')
+WHERE C_REGION = 'AMERICA' AND S_REGION = 'AMERICA' AND P_MFGR IN ('MFGR#1', 'MFGR#2')
GROUP BY YEAR, C_NATION
ORDER BY YEAR ASC, C_NATION ASC;
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org