[ https://issues.apache.org/jira/browse/IGNITE-11177?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16761756#comment-16761756 ]
Vladimir Ozerov commented on IGNITE-11177: ------------------------------------------ We need to change data type all such columns to LONG, as this is not TIME, but rather duration. And duration cannot be expressed in terms of TIME data type. > IGNITE.NODE_METRICS view fails with "Cannot parse "TIME" constant" > 24h > ------------------------------------------------------------------------ > > Key: IGNITE-11177 > URL: https://issues.apache.org/jira/browse/IGNITE-11177 > Project: Ignite > Issue Type: Bug > Components: sql > Affects Versions: 2.7 > Reporter: Ilya Kasnacheev > Assignee: Pavel Kuznetsov > Priority: Major > Labels: metrics > Fix For: 2.8 > > > This is because we are using TIME type for several additive measurements: > {quote}SqlSystemViewNodeMetrics.class: > > valueTimeFromMillis(metrics.getTotalJobsExecutionTime()), > valueTimeFromMillis(metrics.getTotalBusyTime()), > > valueTimeFromMillis(metrics.getTotalIdleTime()),{quote} > which will be hundreds of hours on long-running cluster, but {{TIME}} type is > limited to 24 hours and will fail to be converted otherwise, as in: > {quote}0: jdbc:ignite:thin://localhost> SELECT CAST('40:52:26.548' AS TIME); > Error: Failed to parse query. Невозможно преобразование строки "40:52:26.548" > в тип "TIME" > Cannot parse "TIME" constant "40:52:26.548"; SQL statement: > SELECT CAST('40:52:26.548' AS TIME) [22007-197] (state=42000,code=1001){quote} -- This message was sent by Atlassian JIRA (v7.6.3#76005)