[ https://issues.apache.org/jira/browse/CALCITE-3381?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16942357#comment-16942357 ]
Kirill Kozlov commented on CALCITE-3381: ---------------------------------------- [~amaliujia], feel free to work on this, thanks for volunteering! > When generating SQL for BigQuery (via unparsing), convert Calcite SQL types > to BigQuery types > --------------------------------------------------------------------------------------------- > > Key: CALCITE-3381 > URL: https://issues.apache.org/jira/browse/CALCITE-3381 > Project: Calcite > Issue Type: New Feature > Components: core > Affects Versions: 1.21.0 > Reporter: Kirill Kozlov > Priority: Minor > > When using `SqlImplementor.SimpleContext#toSql` with BigQuerySqlDialect on > Rel nodes containing `CAST` need to convert Calcite SqlTypeName to BigQuery > supported types > ([https://cloud.google.com/bigquery/docs/reference/standard-sql/data-types]). > I believe this can be accomplished by Overriding > BigQuerySqlDialect#getCastSpec method. > Example: VARCHAR should become a STRING, BOOLEAN - BOOL, and so on. -- This message was sent by Atlassian Jira (v8.3.4#803005)