You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "wangbo (via GitHub)" <gi...@apache.org> on 2024/02/22 11:48:57 UTC
[PR] [improment](executor)Add query type in active_queries() tvf [doris]
wangbo opened a new pull request, #31292:
URL: https://github.com/apache/doris/pull/31292
## Proposed changes
1 Add query type in active_queries() tvf.
2 Add audit log for broker load task.
```
mysql [(none)]>select * from active_queries();
+------------+--------+-----------------------------------+---------------------+-------------+-----------------+----------------+----------+------------+-------------------+------------------------+------------------+-----------------+----------+------------------+-----------+---------------------------------------------+
| BeHost | BePort | QueryId | StartTime | QueryTimeMs | WorkloadGroupId | QueryCpuTimeMs | ScanRows | ScanBytes | BePeakMemoryBytes | CurrentUsedMemoryBytes | ShuffleSendBytes | ShuffleSendRows | Database | FrontendInstance | QueryType | Sql |
+------------+--------+-----------------------------------+---------------------+-------------+-----------------+----------------+----------+------------+-------------------+------------------------+------------------+-----------------+----------+------------------+-----------+---------------------------------------------+
| 127.0.0.1 | 6090 | 4940fc2db882446a-afd344993ab21465 | 2024-02-22 18:57:32 | 6 | 10002 | 0 | 3 | 471040 | 942080 | 0 | 0 | 0 | | localhost | QUERY | select * from active_queries() |
| 127.0.0.1 | 6090 | 8a6a0142f04b4642-96eb374827274962 | 2024-02-22 18:57:29 | 7 | 10002 | 0 | 3 | 471040 | 942080 | 0 | 0 | 0 | | localhost | QUERY | select * from active_queries() |
| 127.0.0.1 | 6090 | 4e398e72237c4e1d-afb1c1bac71f8d5e | 2024-02-22 18:57:16 | 19334 | 10002 | 12132 | 7776891 | 9464651776 | 897805983 | 881363254 | 0 | 0 | | localhost | INSERT | insert into hits_10w_dst select * from hits |
| 127.0.0.1 | 6090 | c1df18e146cc4135-accfbfc6c2dc267c | 2024-02-22 18:57:33 | 6 | 10002 | 0 | 2 | 471040 | 942080 | 0 | 0 | 0 | | localhost | QUERY | select * from active_queries() |
+------------+--------+-----------------------------------+---------------------+-------------+-----------------+----------------+----------+------------+-------------------+------------------------+------------------+-----------------+----------+------------------+-----------+---------------------------------------------+
mysql [(none)]>select * from active_queries();
+------------+--------+----------------------------------+---------------------+-------------+-----------------+----------------+----------+-----------+-------------------+------------------------+------------------+-----------------+----------+------------------+-------------+---------------------------------------+
| BeHost | BePort | QueryId | StartTime | QueryTimeMs | WorkloadGroupId | QueryCpuTimeMs | ScanRows | ScanBytes | BePeakMemoryBytes | CurrentUsedMemoryBytes | ShuffleSendBytes | ShuffleSendRows | Database | FrontendInstance | QueryType | Sql |
+------------+--------+----------------------------------+---------------------+-------------+-----------------+----------------+----------+-----------+-------------------+------------------------+------------------+-----------------+----------+------------------+-------------+---------------------------------------+
| 127.0.0.1 | 6090 | 44500e307158734-95cbbb5824a37eac | 2024-02-22 18:58:08 | 2973 | 10002 | 1775 | 251968 | 246046720 | 19587808 | 0 | 0 | 0 | hits | localhost | STREAM_LOAD | stream load into table: hits_10w_dst |
+------------+--------+----------------------------------+---------------------+-------------+-----------------+----------------+----------+-----------+-------------------+------------------------+------------------+-----------------+----------+------------------+-------------+---------------------------------------+
1 row in set (0.01 sec)
mysql [(none)]>select * from active_queries();
+------------+--------+-----------------------------------+---------------------+-------------+-----------------+----------------+----------+-----------+-------------------+------------------------+------------------+-----------------+----------+------------------+-------------+--------------------------------+
| BeHost | BePort | QueryId | StartTime | QueryTimeMs | WorkloadGroupId | QueryCpuTimeMs | ScanRows | ScanBytes | BePeakMemoryBytes | CurrentUsedMemoryBytes | ShuffleSendBytes | ShuffleSendRows | Database | FrontendInstance | QueryType | Sql |
+------------+--------+-----------------------------------+---------------------+-------------+-----------------+----------------+----------+-----------+-------------------+------------------------+------------------+-----------------+----------+------------------+-------------+--------------------------------+
| 127.0.0.1 | 6090 | 9e65007a3b644494-a5bd93e30645177c | 2024-02-22 19:00:10 | 145 | 10002 | 1 | 25 | 106496 | 115264 | 0 | 0 | 0 | | localhost | BROKER_LOAD | |
| 127.0.0.1 | 6090 | 2746a0cc6d049a4-896020a3f6ee158a | 2024-02-22 19:00:09 | 5 | 10002 | 0 | 0 | 0 | 471040 | 0 | 0 | 0 | | localhost | QUERY | select * from active_queries() |
| 127.0.0.1 | 6090 | 8fba30b28cbc4b99-9b1c0e81874c5517 | 2024-02-22 19:00:11 | 7 | 10002 | 0 | 1 | 471040 | 942080 | 0 | 0 | 0 | | localhost | QUERY | select * from active_queries() |
| 127.0.0.1 | 6090 | 5c60dfb870e49a7-a92b8fdd5793850d | 2024-02-22 19:00:13 | 5 | 10002 | 0 | 1 | 471040 | 942080 | 0 | 0 | 0 | | localhost | QUERY | select * from active_queries() |
+------------+--------+-----------------------------------+---------------------+-------------+-----------------+----------------+----------+-----------+-------------------+------------------------+------------------+-----------------+----------+------------------+-------------+--------------------------------+
4 rows in set (0.00 sec)
```
--
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: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [improment](executor)Add query type in active_queries() tvf [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #31292:
URL: https://github.com/apache/doris/pull/31292#issuecomment-1959969309
clang-tidy review says "All clean, LGTM! :+1:"
--
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: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [improment](executor)Add query type in active_queries() tvf [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #31292:
URL: https://github.com/apache/doris/pull/31292#issuecomment-1959301554
clang-tidy review says "All clean, LGTM! :+1:"
--
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: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [improment](executor)Add query type in active_queries() tvf [doris]
Posted by "wangbo (via GitHub)" <gi...@apache.org>.
wangbo commented on PR #31292:
URL: https://github.com/apache/doris/pull/31292#issuecomment-1960665727
run buildall
--
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: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [improment](executor)Add query type in active_queries() tvf [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #31292:
URL: https://github.com/apache/doris/pull/31292#issuecomment-1959767610
clang-tidy review says "All clean, LGTM! :+1:"
--
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: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [improment](executor)Add query type in active_queries() tvf [doris]
Posted by "wangbo (via GitHub)" <gi...@apache.org>.
wangbo closed pull request #31292: [improment](executor)Add query type in active_queries() tvf
URL: https://github.com/apache/doris/pull/31292
--
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: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [improment](executor)Add query type in active_queries() tvf [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #31292:
URL: https://github.com/apache/doris/pull/31292#issuecomment-1959308111
clang-tidy review says "All clean, LGTM! :+1:"
--
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: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [improment](executor)Add query type in active_queries() tvf [doris]
Posted by "wangbo (via GitHub)" <gi...@apache.org>.
wangbo commented on PR #31292:
URL: https://github.com/apache/doris/pull/31292#issuecomment-1959294312
run buildall
--
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: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [improment](executor)Add query type in active_queries() tvf [doris]
Posted by "yiguolei (via GitHub)" <gi...@apache.org>.
yiguolei commented on PR #31292:
URL: https://github.com/apache/doris/pull/31292#issuecomment-1959747643
run buildall
--
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: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [improment](executor)Add query type in active_queries() tvf [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #31292:
URL: https://github.com/apache/doris/pull/31292#issuecomment-1959287689
Thank you for your contribution to Apache Doris.
Don't know what should be done next? See [How to process your PR](https://cwiki.apache.org/confluence/display/DORIS/How+to+process+your+PR)
--
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: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org