Skip to content

Inconsistent time unit support across PPL commands #4397

@ahkcs

Description

@ahkcs

Problem Statement
Time unit conventions are inconsistent across PPL commands, causing confusion and making queries non-portable between commands.

Current State
Case sensitivity inconsistencies:

  • bin command: M = minutes
  • stats command: M = months

Command-specific time units:

  • bin command supports: US (microseconds), CS (centiseconds), DS (deciseconds)
  • stats command: does not support these subsecond units

Long-Term Goals

  • Establish consistent time unit conventions across all PPL commands
  • Enable portable queries that work consistently across different commands
  • Provide comprehensive time unit support where appropriate
  • Maintain backward compatibility while addressing inconsistencies

Proposal
Standardize time unit support across PPL commands:

  1. Consistent case sensitivity:

    • m = minute
    • M = month
  2. Unified time unit support:

    • Add missing subsecond units (us, cs, ds) to commands where appropriate
    • Ensure consistent abbreviations and full names across commands

Metadata

Metadata

Assignees

No one assigned

    Labels

    PPLPiped processing languagecalcitecalcite migration releatedenhancementNew feature or request

    Type

    No type

    Projects

    Status

    Not Started

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions