ESQL: support for buckets larger than 1 year

Description

Currently, when BUCKETing, the time interval expressed in years cannot be larger than 1. However, specifying the interval in weeks allows for an arbitrary number. This issue is to look into removing the year restriction (or any other seemingly arbitrary ones)

Pinging @elastic/es-analytical-engine (Team:Analytics)

Same applies to DATE_TRUNC (which BUCKET makes use of internally).

@bpintea

Hi @bpintea , I would like to address this issue🙂.

My first thought is to add a cardinal parameter in roundFloor to indicate the interval as a multiple of this datetime unit.

elasticsearch/server/src/main/java/org/elasticsearch/common/Rounding.java

Lines 170 to 177 in a59c182

    
                   /** 
        
                    * This rounds down the supplied milliseconds since the epoch down to the next unit. In order to retain performance this method 
        
                    * should be as fast as possible and not try to convert dates to java-time objects if possible 
        
                    * 
        
                    * @param utcMillis the milliseconds since the epoch 
        
                    * @return          the rounded down milliseconds since the epoch 
        
                    */ 
        
                   abstract long roundFloor(long utcMillis);

ESQL: Enhanced `DATE_TRUNC` with arbitrary intervals (elastic#120302)

ESQL: Enhanced `DATE_TRUNC` with arbitrary intervals (#120302) (#129643)

Navigation Menu

Repository navigation

ESQL: support for buckets larger than 1 year #120094

Description

Metadata

Assignees

Labels

Type

Projects

Milestone

Relationships

Development

	/**
	* This rounds down the supplied milliseconds since the epoch down to the next unit. In order to retain performance this method
	* should be as fast as possible and not try to convert dates to java-time objects if possible
	*
	* @param utcMillis the milliseconds since the epoch
	* @return the rounded down milliseconds since the epoch
	*/
	abstract long roundFloor(long utcMillis);

ESQL: support for buckets larger than 1 year #120094

Description

Description

Activity

elasticsearchmachine commented on Jan 14, 2025

bpintea commented on Jan 14, 2025

kanoshiou commented on Jan 16, 2025

Metadata

Metadata

Assignees

Labels

Type

Projects

Milestone

Relationships

Development

Issue actions