xujiangfeng001 commented on code in PR #2875:
URL:
https://github.com/apache/incubator-streampark/pull/2875#discussion_r1289398870
##########
streampark-console/streampark-console-service/src/main/resources/mapper/core/ApplicationMapper.xml:
##########
@@ -141,6 +141,16 @@
limit 1
</select>
+ <select id="countAffectedJobsByClusterId" resultType="java.lang.Integer"
parameterType="java.lang.Long">
+ select
+ count(1)
+ from t_flink_app
+ where flink_cluster_id = #{clusterId}
+ and state in (5, 7, 9)
+ and (end_time IS NULL or TIMESTAMPDIFF(SECOND, end_time, NOW())
<= 1)
Review Comment:
> Does TIMESTAMPDIFF support in h2 and pgsql ?
Hi @wolfboys ，Thank you very much for the review. I have made changes to the
code. Could you please review it when you have time.
##########
streampark-console/streampark-console-service/src/main/resources/mapper/core/ApplicationMapper.xml:
##########
@@ -141,6 +141,16 @@
limit 1
</select>
+ <select id="countAffectedJobsByClusterId" resultType="java.lang.Integer"
parameterType="java.lang.Long">
+ select
+ count(1)
+ from t_flink_app
+ where flink_cluster_id = #{clusterId}
+ and state in (5, 7, 9)
+ and (end_time IS NULL or TIMESTAMPDIFF(SECOND, end_time, NOW())
<= 1)
Review Comment:
> Does TIMESTAMPDIFF support in h2 and pgsql ?
Hi @wolfboys ，Thank you very much for the review. I have made changes to the
code. Could you please review it when you have time.
--
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]
