Thank you, I will try that.
On Sun, Jan 29, 2023, 9:01 PM Benchao Li wrote:
> Hi Vignesh,
>
> AFAIK, there is no such way in Calcite to declare it with DDL. However, you
> can provide it via the statistic for your table, you can take a look at the
> tests[1] in Calcite how we did it.
>
> [1]
>
Will Noble created CALCITE-5509:
---
Summary: Allow automatic type coercion for strings in BigQuery
functions
Key: CALCITE-5509
URL: https://issues.apache.org/jira/browse/CALCITE-5509
Project: Calcite
Julian Hyde created CALCITE-5508:
Summary: Add constructor functions for DATE, TIME, TIMESTAMP,
DATETIME
Key: CALCITE-5508
URL: https://issues.apache.org/jira/browse/CALCITE-5508
Project: Calcite