github-actions[bot] commented on PR #32308:
URL: https://github.com/apache/doris/pull/32308#issuecomment-1999334287
#### `sh-checker report`
To get the full details, please check in the
[job]("https://github.com/apache/doris/actions/runs/8294530759";) output.
<details>
<summary>shellcheck errors</summary>
```
'shellcheck ' found no issues.
```
</details>
<details>
<summary>shfmt errors</summary>
```
'shfmt ' returned error 1 finding the following formatting issues:
----------
--- tools/ssb-tools/bin/load-ssb-data.sh.orig
+++ tools/ssb-tools/bin/load-ssb-data.sh
--- tools/ssb-tools/bin/run-ssb-flat-queries.sh.orig
+++ tools/ssb-tools/bin/run-ssb-flat-queries.sh
@@ -116,37 +116,37 @@
for i in '1.1' '1.2' '1.3' '2.1' '2.2' '2.3' '3.1' '3.2' '3.3' '3.4' '4.1'
'4.2' '4.3'; do
cold=0
- hot1=0
- hot2=0
- echo -ne "q${i}\t" | tee -a result.csv
- start=$(date +%s%3N)
- mysql -h"${FE_HOST}" -u "${USER}" -P"${FE_QUERY_PORT}" -D"${DB}"
--comments <"${QUERIES_DIR}"/q"${i}".sql >"${RESULT_DIR}"/result"${i}".out
2>"${RESULT_DIR}"/result"${i}".log
- end=$(date +%s%3N)
- cold=$((end - start))
- echo -ne "${cold}\t" | tee -a result.csv
+ hot1=0
+ hot2=0
+ echo -ne "q${i}\t" | tee -a result.csv
+ start=$(date +%s%3N)
+ mysql -h"${FE_HOST}" -u "${USER}" -P"${FE_QUERY_PORT}" -D"${DB}"
--comments <"${QUERIES_DIR}"/q"${i}".sql >"${RESULT_DIR}"/result"${i}".out
2>"${RESULT_DIR}"/result"${i}".log
+ end=$(date +%s%3N)
+ cold=$((end - start))
+ echo -ne "${cold}\t" | tee -a result.csv
- start=$(date +%s%3N)
- mysql -h"${FE_HOST}" -u "${USER}" -P"${FE_QUERY_PORT}" -D"${DB}"
--comments <"${QUERIES_DIR}"/q"${i}".sql >"${RESULT_DIR}"/result"${i}".out
2>"${RESULT_DIR}"/result"${i}".log
- end=$(date +%s%3N)
- hot1=$((end - start))
- echo -ne "${hot1}\t" | tee -a result.csv
+ start=$(date +%s%3N)
+ mysql -h"${FE_HOST}" -u "${USER}" -P"${FE_QUERY_PORT}" -D"${DB}"
--comments <"${QUERIES_DIR}"/q"${i}".sql >"${RESULT_DIR}"/result"${i}".out
2>"${RESULT_DIR}"/result"${i}".log
+ end=$(date +%s%3N)
+ hot1=$((end - start))
+ echo -ne "${hot1}\t" | tee -a result.csv
- start=$(date +%s%3N)
- mysql -h"${FE_HOST}" -u "${USER}" -P"${FE_QUERY_PORT}" -D"${DB}"
--comments <"${QUERIES_DIR}"/q"${i}".sql >"${RESULT_DIR}"/result"${i}".out
2>"${RESULT_DIR}"/result"${i}".log
- end=$(date +%s%3N)
- hot2=$((end - start))
- echo -ne "${hot2}\t" | tee -a result.csv
+ start=$(date +%s%3N)
+ mysql -h"${FE_HOST}" -u "${USER}" -P"${FE_QUERY_PORT}" -D"${DB}"
--comments <"${QUERIES_DIR}"/q"${i}".sql >"${RESULT_DIR}"/result"${i}".out
2>"${RESULT_DIR}"/result"${i}".log
+ end=$(date +%s%3N)
+ hot2=$((end - start))
+ echo -ne "${hot2}\t" | tee -a result.csv
- cold_run_sum=$((cold_run_sum + cold))
- if [[ ${hot1} -lt ${hot2} ]]; then
- best_hot_run_sum=$((best_hot_run_sum + hot1))
- echo -ne "${hot1}" | tee -a result.csv
- echo "" | tee -a result.csv
- else
- best_hot_run_sum=$((best_hot_run_sum + hot2))
- echo -ne "${hot2}" | tee -a result.csv
- echo "" | tee -a result.csv
- fi
+ cold_run_sum=$((cold_run_sum + cold))
+ if [[ ${hot1} -lt ${hot2} ]]; then
+ best_hot_run_sum=$((best_hot_run_sum + hot1))
+ echo -ne "${hot1}" | tee -a result.csv
+ echo "" | tee -a result.csv
+ else
+ best_hot_run_sum=$((best_hot_run_sum + hot2))
+ echo -ne "${hot2}" | tee -a result.csv
+ echo "" | tee -a result.csv
+ fi
done
echo "Total cold run time: ${cold_run_sum} ms"
--- tools/ssb-tools/bin/run-ssb-queries.sh.orig
+++ tools/ssb-tools/bin/run-ssb-queries.sh
@@ -116,37 +116,37 @@
for i in '1.1' '1.2' '1.3' '2.1' '2.2' '2.3' '3.1' '3.2' '3.3' '3.4' '4.1'
'4.2' '4.3'; do
cold=0
- hot1=0
- hot2=0
- echo -ne "q${i}\t" | tee -a result.csv
- start=$(date +%s%3N)
- mysql -h"${FE_HOST}" -u "${USER}" -P"${FE_QUERY_PORT}" -D"${DB}"
--comments <"${QUERIES_DIR}"/q"${i}".sql >"${RESULT_DIR}"/result"${i}".out
2>"${RESULT_DIR}"/result"${i}".log
- end=$(date +%s%3N)
- cold=$((end - start))
- echo -ne "${cold}\t" | tee -a result.csv
+ hot1=0
+ hot2=0
+ echo -ne "q${i}\t" | tee -a result.csv
+ start=$(date +%s%3N)
+ mysql -h"${FE_HOST}" -u "${USER}" -P"${FE_QUERY_PORT}" -D"${DB}"
--comments <"${QUERIES_DIR}"/q"${i}".sql >"${RESULT_DIR}"/result"${i}".out
2>"${RESULT_DIR}"/result"${i}".log
+ end=$(date +%s%3N)
+ cold=$((end - start))
+ echo -ne "${cold}\t" | tee -a result.csv
- start=$(date +%s%3N)
- mysql -h"${FE_HOST}" -u "${USER}" -P"${FE_QUERY_PORT}" -D"${DB}"
--comments <"${QUERIES_DIR}"/q"${i}".sql >"${RESULT_DIR}"/result"${i}".out
2>"${RESULT_DIR}"/result"${i}".log
- end=$(date +%s%3N)
- hot1=$((end - start))
- echo -ne "${hot1}\t" | tee -a result.csv
+ start=$(date +%s%3N)
+ mysql -h"${FE_HOST}" -u "${USER}" -P"${FE_QUERY_PORT}" -D"${DB}"
--comments <"${QUERIES_DIR}"/q"${i}".sql >"${RESULT_DIR}"/result"${i}".out
2>"${RESULT_DIR}"/result"${i}".log
+ end=$(date +%s%3N)
+ hot1=$((end - start))
+ echo -ne "${hot1}\t" | tee -a result.csv
- start=$(date +%s%3N)
- mysql -h"${FE_HOST}" -u "${USER}" -P"${FE_QUERY_PORT}" -D"${DB}"
--comments <"${QUERIES_DIR}"/q"${i}".sql >"${RESULT_DIR}"/result"${i}".out
2>"${RESULT_DIR}"/result"${i}".log
- end=$(date +%s%3N)
- hot2=$((end - start))
- echo -ne "${hot2}\t" | tee -a result.csv
+ start=$(date +%s%3N)
+ mysql -h"${FE_HOST}" -u "${USER}" -P"${FE_QUERY_PORT}" -D"${DB}"
--comments <"${QUERIES_DIR}"/q"${i}".sql >"${RESULT_DIR}"/result"${i}".out
2>"${RESULT_DIR}"/result"${i}".log
+ end=$(date +%s%3N)
+ hot2=$((end - start))
+ echo -ne "${hot2}\t" | tee -a result.csv
- cold_run_sum=$((cold_run_sum + cold))
- if [[ ${hot1} -lt ${hot2} ]]; then
- best_hot_run_sum=$((best_hot_run_sum + hot1))
- echo -ne "${hot1}" | tee -a result.csv
- echo "" | tee -a result.csv
- else
- best_hot_run_sum=$((best_hot_run_sum + hot2))
- echo -ne "${hot2}" | tee -a result.csv
- echo "" | tee -a result.csv
- fi
+ cold_run_sum=$((cold_run_sum + cold))
+ if [[ ${hot1} -lt ${hot2} ]]; then
+ best_hot_run_sum=$((best_hot_run_sum + hot1))
+ echo -ne "${hot1}" | tee -a result.csv
+ echo "" | tee -a result.csv
+ else
+ best_hot_run_sum=$((best_hot_run_sum + hot2))
+ echo -ne "${hot2}" | tee -a result.csv
+ echo "" | tee -a result.csv
+ fi
done
echo "Total cold run time: ${cold_run_sum} ms"
----------
You can reformat the above files to meet shfmt's requirements by typing:
shfmt -w filename
```
</details>
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
