Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[VL] Results are mismatch with vanilla Spark when using unix_timestamp(yyyy-MM-dd HH:mm:ss,SSS) #6227

Open
NEUpanning opened this issue Jun 26, 2024 · 0 comments
Labels
bug Something isn't working triage

Comments

@NEUpanning
Copy link
Contributor

NEUpanning commented Jun 26, 2024

Backend

VL (Velox)

Bug description

Results are mismatch with vanilla Spark setting "spark.sql.legacy.timeParserPolicy" to "LEGACY" when using unix_timestamp(yyyy-MM-dd HH:mm:ss,SSS).

create table sql:

CREATE TABLE tbl(a STRING) ;
insert into tbl values("2022-01-04 14:52:40.017")

gluten result:

select unix_timestamp(a) from tbl;
> NULL

spark3.5 result:

set spark.sql.legacy.timeParserPolicy=LEGACY;
select unix_timestamp(a) from tbl;
> 1641279160

Spark version

Spark-3.5.x

Spark configurations

No response

System information

No response

Relevant logs

No response

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working triage
Projects
None yet
Development

No branches or pull requests

1 participant