[jira] [Assigned] (DRILL-7652) Add time_bucket() Function for Time Series Analysis

["Igor Guzenko (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/DRILL-7652?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Igor Guzenko reassigned DRILL-7652:
-----------------------------------

    Assignee: Charles Givre

> Add time_bucket() Function for Time Series Analysis
> ---------------------------------------------------
>
>                 Key: DRILL-7652
>                 URL: https://issues.apache.org/jira/browse/DRILL-7652
>             Project: Apache Drill
>          Issue Type: Improvement
>    Affects Versions: 1.17.0
>            Reporter: Charles Givre
>            Assignee: Charles Givre
>            Priority: Major
>              Labels: ready-to-commit
>             Fix For: 1.18.0
>
>
> These functions are useful for doing time series analysis by grouping the data into arbitrary intervals. See: https://blog.timescale.com/blog/simplified-time-series-analytics
> -using-the-time_bucket-function/ for more examples. 
> There are two versions of the function:
> * `time_bucket(<timestamp>, <interval>)`
> * `time_bucket_ns(<timestamp>,<interval>)`
> Both functions accept a `BIGINT` timestamp and an interval in milliseconds as arguments. The `time_bucket_ns()` function accepts timestamps in nanoseconds and `time_bucket
> ()` accepts timestamps in milliseconds. Both return timestamps in the original format.
> ### Example:
> The query below calculates the average for the `cpu` metric for every five minute interval.
> ```sql
> SELECT time_bucket(time_stamp, 30000) AS five_min, avg(cpu)
>  FROM metrics
>  GROUP BY five_min
>  ORDER BY five_min DESC LIMIT 12;
> ```



--
This message was sent by Atlassian Jira
(v8.3.4#803005)