Closed goldmedal closed 4 days ago
Now we can distinguish TIMESTAMP and TIMESTAMP WITH TIME ZONE in the DataFusion layer. We also know the sqlglot will transpile SQL for Bigquery
TIMESTAMP
TIMESTAMP WITH TIME ZONE
DATETIME
We can apply DataFusion's type coercion rule for them. If needed, DataFusion will cast the timestamp side to the timestamp with the time zone.
LOGURU_LEVEL=DEBUG python tools/mdl_validation.py mdl.json function.csv
boolean
current_datetime
Thanks @grieve54706 for reviewing
Description
Now we can distinguish
TIMESTAMP
andTIMESTAMP WITH TIME ZONE
in the DataFusion layer. We also know the sqlglot will transpile SQL for BigqueryTIMESTAMP
->DATETIME
( without timezone)TIMESTAMP WITH TIME ZONE
->TIMESTAMP
( with timezone)We can apply DataFusion's type coercion rule for them. If needed, DataFusion will cast the timestamp side to the timestamp with the time zone.
Additional change
boolean
alias for bool typecurrent_datetime
for BigQuery