Skip to content

[VL] Result mimatch when to_timestamp with fraction of seconds #8858

@NEUpanning

Description

@NEUpanning

Backend

VL (Velox)

Bug description

spark result:

spark-sql (default)> set spark.sql.legacy.timeParserPolicy=legacy;
spark.sql.legacy.timeParserPolicy	legacy
spark-sql (default)> select to_timestamp('2025-02-25T03:07:22.2', "yyyy-MM-dd'T'HH:mm:ss.SSS");
2025-02-25 03:07:22.002

gluten result:

spark-sql (default)> set spark.sql.legacy.timeParserPolicy=legacy;
spark.sql.legacy.timeParserPolicy	legacy
spark-sql (default)> select to_timestamp('2025-02-25T03:07:22.2', "yyyy-MM-dd'T'HH:mm:ss.SSS");
2025-02-25 03:07:22.2

Spark version

None

Spark configurations

No response

System information

No response

Relevant logs

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't workingtriage

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions