ning guo created KYLIN-4001:
-------------------------------

             Summary: 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


* 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}


 
 



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Reply via email to