Ilya Kasnacheev created IGNITE-11177: ----------------------------------------
Summary: 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 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)