You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@kylin.apache.org by "nichunen (JIRA)" <ji...@apache.org> on 2019/07/17 06:19:00 UTC

[jira] [Updated] (KYLIN-4001) Allow user-specified time format using real-time

     [ https://issues.apache.org/jira/browse/KYLIN-4001?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

nichunen updated KYLIN-4001:
----------------------------
    Fix Version/s:     (was: v3.0.0-beta)
                   v3.0.0-alpha2

> Allow user-specified time format using real-time
> ------------------------------------------------
>
>                 Key: KYLIN-4001
>                 URL: https://issues.apache.org/jira/browse/KYLIN-4001
>             Project: Kylin
>          Issue Type: Improvement
>          Components: Real-time Streaming
>            Reporter: ning guo
>            Priority: Minor
>             Fix For: v3.0.0-alpha2
>
>
> * I found that real-time only supports millisecond timestamp, does not support second timestamp and  Date type like '2019-01-01 11:11:11'.
>  * I add a LongTimeParser and a DateTimeParser and page configuration 
>  * You can configure tsParser, tsPattern on the page that creates the streaming table.
>  * for date :
> {code:java}
> { "timestamp":"2019-04-29 11:11:11","gmv":1.1 }
> You can specify
> tsParser=org.apache.kylin.stream.source.kafka.DateTimeParser
> tsPattern=yyyy-MM-dd HH:mm:ss{code}
>  
>  * for second :
> {code:java}
> { "timestamp":"1556618887","gmv":1.1 }
> You can specify
> tsParser=org.apache.kylin.stream.source.kafka.LongTimeParser
> tsPattern=S{code}
>  
>  * for millisecond :
> {code:java}
> { "timestamp":"1556618887000","gmv":1.1 }
> You can specify
> tsParser=org.apache.kylin.stream.source.kafka.LongTimeParser
> tsPattern=MS
> {code}
>  
>   



--
This message was sent by Atlassian JIRA
(v7.6.14#76016)