ignite-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Pavel Kuznetsov (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (IGNITE-11177) IGNITE.NODE_METRICS view fails with "Cannot parse "TIME" constant" > 24h
Date Wed, 06 Feb 2019 15:32:00 GMT

    [ https://issues.apache.org/jira/browse/IGNITE-11177?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16761858#comment-16761858
] 

Pavel Kuznetsov commented on IGNITE-11177:
------------------------------------------

[~vozerov] Changes seem to be trivial. Should we also create human readable versions of that
columns? 
{noformat}
UPTIME_MS      1267392877
UPTIME             '352d:3h:12s:877ms'         
{noformat}

Trivial part is done.


> 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)

Mime
View raw message