influxdata / influxdata/influxdb-java

Support Month in Duration Literal

Open
#1,006 1 comment 1 reaction 0 assignees View on GitHub

Nobody has claimed this yet.

Dominant language
Java
Stars
1.2k
Forks
469
PR merge metrics
No merged PRs in 30d

Description

Issue Summary:

In InfluxQL, there's a lack of a built-in duration specifier for months, which makes it challenging to accurately group data into monthly intervals. Currently, users have to resort to approximations using days, which can lead to inaccuracies, especially when dealing with varying month lengths and leap years.

Proposal:

I propose adding a month duration literal to InfluxQL to provide users with a more intuitive and precise way to specify monthly intervals in queries. This enhancement would streamline data analysis and reporting workflows, making it easier for users to work with temporal data at the monthly level.

Suggested Syntax:

A suggested syntax for the month duration literal could be 1mo, following the conventions used in other date-time libraries and query languages.

Contributor guide

No contributing guide indexed for this repository

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

The issue identifies no files, tests, or entry points. Start by locating the InfluxQL duration-literal parsing and specification areas, then determine how a 1mo literal should represent calendar months rather than day approximations. Done means the proposed syntax is supported with coverage for varying month lengths and leap years.

Written by the indexing model from the issue text.

Assessment

Tech stack
java
Domain
api, backend
Issue type
Feature
Difficulty
5/5
Estimated time
Over a week
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
30/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.