Skip to content

[feature][COM][common] add week variable support for date calculation #5414

Description

@v-kkhuang

Search before asking

  • I had searched in the issues and found no similar feature requirement.

Linkis Component

  • linkis-commons
  • linkis-computation-governance
  • linkis-dist
  • linkis-engineconn-plugin
  • linkis-extensions
  • linkis-orchestrator
  • linkis-public-enhancements
  • linkis-spring-cloud-services
  • linkis-web

Description

Currently, Linkis date variable functionality only supports day, month, and year granularity. Users need the ability to calculate and use week-based variables for more flexible time-based scheduling and reporting.

Steps to reproduce

  1. Try to use week variables in Linkis SQL queries
  2. Find that week-based calculations are not supported
  3. Need to manually calculate week values

Expected behavior

Support week variables in Linkis SQL queries, such as ${week}, ${week_start}, ${week_end}, etc.

Your environment

  • Linkis version used: 1.18.0
  • Environment name and version:
    • hadoop-3.3.4
    • spark-2.4.3
    • scala-2.11.12
    • jdk 1.8.0_xxx

Anything else

This feature enables week-based date calculations for scheduling and reporting use cases.

Are you willing to submit a PR?

  • Yes I am willing to submit a PR!

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions