[
https://issues.apache.org/jira/browse/KYLIN-4001?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
ning guo updated KYLIN-4001:
----------------------------
Description:
* 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}
was:
* I found that real-time only supports millisecond timestamp, does not support
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}
> 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
>
> * 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)
