[jira] [Created] (IGNITE-11177) IGNITE.NODE_METRICS view fails with "Cannot parse "TIME" constant" > 24h

["Ilya Kasnacheev (JIRA)" <ji...@apache.org>]

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)