[GitHub] [druid] hotdust opened a new issue #9397: About action of TIME_PARSE function

[GitBox <gi...@apache.org>]

hotdust opened a new issue #9397: About action of TIME_PARSE function
URL: https://github.com/apache/druid/issues/9397
 
 
   # Version
   0.17.0
   
   # Actions
   1. __time contains millisecond，such as "2015-09-12T00:46:58.771Z"。
   2. Search data by "SELECT * FROM "wikiticker-kafka" WHERE "__time" = TIME_PARSE('2015-09-12T00:46:58.771Z')"
   
   # Problem
   The SQL returns nothing. 
   After SQL was converted to Native SQL, millisecond part was set with 000~001. 
   Native SQL Interval part as following:
   ```
     "intervals": {
       "type": "intervals",
       "intervals": [
         "2015-09-12T00:46:58.000Z/2015-09-12T00:46:58.001Z"
       ]
     },
   ```
   
   If specify pattern(like 'yyyy-MM-dd HH:mm:ss.SSSZ'), interval becomes '1970-01-01T00:00:00.000Z/1970-01-01T00:00:00.001Z'.
   ```
   SELECT * FROM "wikiticker-realtime" WHERE "__time" = TIME_PARSE('2015-09-12T00:46:58.771Z', 'yyyy-MM-dd HH:mm:ss.SSSZ')
   
     "intervals": {
       "type": "intervals",
       "intervals": [
         "1970-01-01T00:00:00.000Z/1970-01-01T00:00:00.001Z"
       ]
     },
   ```

----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@druid.apache.org
For additional commands, e-mail: commits-help@druid.apache.org