You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@kylin.apache.org by "XiaoXiang Yu (JIRA)" <ji...@apache.org> on 2019/06/12 03:16:00 UTC
[jira] [Resolved] (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 ]
XiaoXiang Yu resolved KYLIN-4001.
---------------------------------
Resolution: Fixed
> 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
>
>
> * 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.3#76005)