This is an automated email from the ASF dual-hosted git repository.
yiguolei pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/doris.git
The following commit(s) were added to refs/heads/master by this push:
new 75b6b267ea [opt](ssb) Add query hint for the SSB queries (#14089)
75b6b267ea is described below
commit 75b6b267ea1e4ade71cf98ea3c7fa5214f253a82
Author: HappenLee <[email protected]>
AuthorDate: Wed Nov 9 08:37:31 2022 +0800
[opt](ssb) Add query hint for the SSB queries (#14089)
---
dist/LICENSE-dist.txt | 1 +
tools/ssb-tools/ssb-queries/q4.1.sql | 4 ++--
tools/ssb-tools/ssb-queries/q4.2.sql | 4 ++--
tools/ssb-tools/ssb-queries/q4.3.sql | 4 ++--
4 files changed, 7 insertions(+), 6 deletions(-)
diff --git a/dist/LICENSE-dist.txt b/dist/LICENSE-dist.txt
index feb4183336..69f561132f 100644
--- a/dist/LICENSE-dist.txt
+++ b/dist/LICENSE-dist.txt
@@ -1574,3 +1574,4 @@ Other dependencies:
* breakpad@38ee0be -- license/LICENSE-breakpod.txt
* xsimd: xmid@e9234cd6 -- license/LICENSE-xsimd.txt
* xxhash: 0.8.1 -- license/LICENSE-xxhash.txt
+ * concurrentqueue: 1.0.3 -- license/LICENSE-concurrentqueue.txt
diff --git a/tools/ssb-tools/ssb-queries/q4.1.sql
b/tools/ssb-tools/ssb-queries/q4.1.sql
index f0cfcdd403..0cf4f05a64 100644
--- a/tools/ssb-tools/ssb-queries/q4.1.sql
+++ b/tools/ssb-tools/ssb-queries/q4.1.sql
@@ -14,7 +14,7 @@
-- KIND, either express or implied. See the License for the
-- specific language governing permissions and limitations
-- under the License.
-SELECT
+SELECT /*+SET_VAR(parallel_fragment_exec_instance_num=4,
enable_vectorized_engine=true, batch_size=4096,
enable_cost_based_join_reorder=true, enable_projection=true) */
d_year,
c_nation,
SUM(lo_revenue - lo_supplycost) AS PROFIT
@@ -31,4 +31,4 @@ WHERE
OR p_mfgr = 'MFGR#2'
)
GROUP BY d_year, c_nation
-ORDER BY d_year, c_nation;
\ No newline at end of file
+ORDER BY d_year, c_nation;
diff --git a/tools/ssb-tools/ssb-queries/q4.2.sql
b/tools/ssb-tools/ssb-queries/q4.2.sql
index fbbaef00e8..97a832c60b 100644
--- a/tools/ssb-tools/ssb-queries/q4.2.sql
+++ b/tools/ssb-tools/ssb-queries/q4.2.sql
@@ -14,7 +14,7 @@
-- KIND, either express or implied. See the License for the
-- specific language governing permissions and limitations
-- under the License.
-SELECT
+SELECT /*+SET_VAR(parallel_fragment_exec_instance_num=2,
enable_vectorized_engine=true, batch_size=4096,
enable_cost_based_join_reorder=true, enable_projection=true) */
d_year,
s_nation,
p_category,
@@ -36,4 +36,4 @@ WHERE
OR p_mfgr = 'MFGR#2'
)
GROUP BY d_year, s_nation, p_category
-ORDER BY d_year, s_nation, p_category;
\ No newline at end of file
+ORDER BY d_year, s_nation, p_category;
diff --git a/tools/ssb-tools/ssb-queries/q4.3.sql
b/tools/ssb-tools/ssb-queries/q4.3.sql
index 64582cc6ac..e5b7dc3699 100644
--- a/tools/ssb-tools/ssb-queries/q4.3.sql
+++ b/tools/ssb-tools/ssb-queries/q4.3.sql
@@ -14,7 +14,7 @@
-- KIND, either express or implied. See the License for the
-- specific language governing permissions and limitations
-- under the License.
-SELECT
+SELECT /*+SET_VAR(parallel_fragment_exec_instance_num=2,
enable_vectorized_engine=true, batch_size=4096,
enable_cost_based_join_reorder=true, enable_projection=true) */
d_year,
s_city,
p_brand,
@@ -32,4 +32,4 @@ WHERE
)
AND p_category = 'MFGR#14'
GROUP BY d_year, s_city, p_brand
-ORDER BY d_year, s_city, p_brand;
\ No newline at end of file
+ORDER BY d_year, s_city, p_brand;
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
