zenoyang commented on pull request #8193:
URL: https://github.com/apache/incubator-doris/pull/8193#issuecomment-1048718553
### Q2.1 flat table query:
```sql
SELECT
sum(LO_REVENUE),
(LO_ORDERDATE DIV 10000) AS year,
P_BRAND
FROM lineorder_flat
WHERE P_CATEGORY = 'MFGR#12' AND S_REGION = 'AMERICA'
GROUP BY
year,
P_BRAND
ORDER BY
year,
P_BRAND;
```
result:
```
before PR test:
- Total: 1s287ms
- BlockLoadTime: 6s779ms
- BlockLoadTime: 6s677ms
- BlockLoadTime: 6s699ms
- BlockLoadTime: 6s787ms
- BlockLoadTime: 6s801ms
- BlockLoadTime: 6s759ms
- BlockLoadTime: 6s729ms
- BlockLoadTime: 6s772ms
avg: 6750.375ms
after PR test:
- Total: 1s353ms
- BlockLoadTime: 6s897ms
- BlockLoadTime: 6s838ms
- BlockLoadTime: 6s850ms
- BlockLoadTime: 6s881ms
- BlockLoadTime: 6s965ms
- BlockLoadTime: 6s878ms
- BlockLoadTime: 6s941ms
- BlockLoadTime: 6s848ms
avg: 6887.25ms
```
### Q2.2 flat table query:
```sql
SELECT
sum(LO_REVENUE),
(LO_ORDERDATE DIV 10000) AS year,
P_BRAND
FROM lineorder_flat
WHERE P_BRAND >= 'MFGR#2221' AND P_BRAND <= 'MFGR#2228' AND S_REGION = 'ASIA'
GROUP BY
year,
P_BRAND
ORDER BY
year,
P_BRAND;
```
result:
```
before PR test:
- Total: 1s408ms
- BlockLoadTime: 7s622ms
- BlockLoadTime: 7s674ms
- BlockLoadTime: 7s714ms
- BlockLoadTime: 7s552ms
- BlockLoadTime: 7s596ms
- BlockLoadTime: 7s752ms
- BlockLoadTime: 7s870ms
- BlockLoadTime: 7s782ms
avg: 7695.25ms
after PR test:
- Total: 1s449ms
- BlockLoadTime: 7s738ms
- BlockLoadTime: 7s774ms
- BlockLoadTime: 7s654ms
- BlockLoadTime: 7s783ms
- BlockLoadTime: 7s751ms
- BlockLoadTime: 7s768ms
- BlockLoadTime: 7s764ms
- BlockLoadTime: 7s825ms
avg: 7757.125ms
```
### Q2.3 flat table query:
```sql
SELECT
sum(LO_REVENUE),
(LO_ORDERDATE DIV 10000) AS year,
P_BRAND
FROM lineorder_flat
WHERE P_BRAND = 'MFGR#2239' AND S_REGION = 'EUROPE'
GROUP BY
year,
P_BRAND
ORDER BY
year,
P_BRAND;
```
result:
```
before PR test:
- Total: 1s217ms
- BlockLoadTime: 6s47ms
- BlockLoadTime: 6s138ms
- BlockLoadTime: 6s360ms
- BlockLoadTime: 6s399ms
- BlockLoadTime: 5s877ms
- BlockLoadTime: 6s70ms
- BlockLoadTime: 6s293ms
- BlockLoadTime: 6s233ms
avg: 6308.75ms
after PR test:
- Total: 1s211ms
- BlockLoadTime: 6s362ms
- BlockLoadTime: 6s276ms
- BlockLoadTime: 6s277ms
- BlockLoadTime: 6s347ms
- BlockLoadTime: 6s363ms
- BlockLoadTime: 6s328ms
- BlockLoadTime: 6s299ms
- BlockLoadTime: 6s622ms
avg: 6359.25ms
```
--
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]
