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