[
https://issues.apache.org/jira/browse/DRILL-7652?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17063431#comment-17063431
]
ASF GitHub Bot commented on DRILL-7652:
---------------------------------------
arina-ielchiieva commented on issue #2033: DRILL-7652: Add time_bucket()
function for time series analysis
URL: https://github.com/apache/drill/pull/2033#issuecomment-601743413
@cgivre it's a common rule / courtesy to keep PRs open at least for one day
so others can take a look if they want to, exceptions apply to something really
minor or emergency bug fix.
----------------------------------------------------------------
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:
[email protected]
> 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)
