You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@druid.apache.org by GitBox <gi...@apache.org> on 2019/08/23 02:05:49 UTC

[GitHub] [incubator-druid] pdeva opened a new issue #8379: backfill results for unavailable time ranges from sql queries

pdeva opened a new issue #8379: backfill results for unavailable time ranges from sql queries
URL: https://github.com/apache/incubator-druid/issues/8379
 
 
   ### Description
   
   Add an option to SQL query context to backfill missing ranges of a metric with NaN or 0.
   
   
   ### Motivation
   
   Here is a set of graphs retrieved from the results of a single druid sql query.
   The 2 graph starts at 12:00 while the others start at 11:00.
   
   ![image](https://user-images.githubusercontent.com/3190176/63561545-33750880-c50f-11e9-8e98-e738d6bb8548.png)
   
   this is because the 'command rate' metric has no data before 12:00.
   
   ideally all these graphs should have the same time range and either show 0 or missing value for ranges where no data was available.
   
   Currently this requires doing a separate pass in the client to ensure the full range is available for the given client. Ideally this should just be an option passed to druid sql which fills missing timeranges with 0 or NaN.
   
   

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