## Proposed changes
Issue Number: close#40834
<!--Describe your changes.-->
```
➜ doris_ bash /home/cat/doris_/doris/tools/clickbench-tools/run-clickbench-queries.sh
query1,ERROR 1105 (HY000) at line 1: errCode = 2, detailMessage = There is no scanNode Backend available.[10004: not alive]
,ERROR 1105 (HY000) at line 1: errCode = 2, detailMessage = There is no scanNode Backend available.[10004: not alive]
,ERROR 1105 (HY000) at line 1: errCode = 2, detailMessage = There is no scanNode Backend available.[10004: not alive]
```
```
➜ doris_ bash /home/cat/doris_/doris/tools/ssb-tools/bin/run-ssb-flat-queries.sh
============================================
q1.1 317 112 107 107
q1.2 91 52 52 52
q1.3 198 101 136 101
q2.1 3197 1751 1642 1642
q2.2 Error: Failed to execute query q2.2 (cold run). Output:
ERROR 1105 (HY000) at line 17: RpcException, msg: send fragments failed. io.grpc.StatusRuntimeException: UNAVAILABLE: io exception, host: 192.168.41.145
q2.3 Error: Failed to execute query q2.3 (cold run). Output:
ERROR 1105 (HY000) at line 17: RpcException, msg: send fragments failed. io.grpc.StatusRuntimeException: UNAVAILABLE: io exception, host: 192.168.41.145
```
```
➜ doris_ bash /home/cat/doris_/doris/tools/ssb-tools/bin/run-ssb-queries.sh
============================================
q1.1 881 210 231 210
q1.2 1075 153 176 153
q1.3 131 124 143 124
q2.1 5429 1551 1638 1551
q2.2 1785 1618 1615 1615
q2.3 1234 1189 1418 1189
q3.1 Error: Failed to execute query q3.1 (cold run). Output:
ERROR 1105 (HY000) at line 17: RpcException, msg: send fragments failed. io.grpc.StatusRuntimeException: UNAVAILABLE: io exception, host: 192.168.41.145
q3.2 Error: Failed to execute query q3.2 (cold run). Output:
ERROR 1105 (HY000) at line 17: RpcException, msg: send fragments failed. io.grpc.StatusRuntimeException: UNAVAILABLE: io exception, host: 192.168.41.145
```
```
➜ doris_ bash /home/cat/doris_/doris/tools/clickbench-tools/load-clickbench-data.sh
FE_HOST: 127.0.0.1
FE_HTTP_PORT: 8030
USER: root
PASSWORD:
DB: clickbench
start...
Curl failed with the following output:
Error: Failed to execute curl to fetch BE's configuration.
```
```
➜ doris_ bash /home/cat/doris_/doris/tools/clickbench-tools/run-clickbench-queries.sh
mysql Ver 8.0.39-0ubuntu0.22.04.1 for Linux on x86_64 ((Ubuntu))
This is perl 5, version 34, subversion 0 (v5.34.0) built for x86_64-linux-gnu-thread-multi
(with 60 registered patches, see perl -V for more detail)
Copyright 1987-2021, Larry Wall
Perl may be copied only under the terms of either the Artistic License or the
GNU General Public License, which may be found in the Perl 5 source kit.
Complete documentation for Perl, including FAQ lists, should be found on
this system using "man perl" or "perldoc perl". If you have access to the
Internet, point your browser at http://www.perl.org/, the Perl Home Page.
FE_HOST: 127.0.0.1
FE_QUERY_PORT: 9030
USER: root
PASSWORD:
DB: clickbench
ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1:9030' (111)
```
## Proposed changes
Issue Number: close #xxx
1. move analyzing of the clickbench from running query to loading, just
like other benchmarks
2. remove useless variables for Doris' master
3. change `datev2` to `date`, `decimalv3` to `decimal` as it's Doris'
master's defaults.
zclllyybb
feifeifeimoon
cat-with-cat
Dongyang Li
zhangguoqiang
HappenLee
Gabriel
Pxl
ZhangJian He
ZhangYu0123
