[GitHub] [druid] har5havardhan opened a new issue #9512: Unable to use current_timestamp in druid native query

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

har5havardhan opened a new issue #9512: Unable to use current_timestamp in druid native query
URL: https://github.com/apache/druid/issues/9512
 
 
   Hi,
   
   I am trying to write a simple druid query like below
   <img width="1164" alt="image" src="https://user-images.githubusercontent.com/40817846/76649514-d4e4aa00-6586-11ea-8fcf-fa204eb797d5.png">
   
   but when I try to convert into native query it turns out like below
   <img width="953" alt="image" src="https://user-images.githubusercontent.com/40817846/76649547-eb8b0100-6586-11ea-883c-49defee25280.png">
   
   The problem here is that my filter  **_current_timestamp - interval '1' day_** is converted to **_2020-03-12T18:29:11.001Z_** in native query .
   
   But I have to use current_timestamp - interval '1' day in my native query. since metabase can support only native queries and i have to create a dashboard which always shows info of D-1 data.
   
   when I try to use current_timestamp in the interval clause in native query it fails and also there is no info about this in documentation. How do i solve it? 

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