[
https://issues.apache.org/jira/browse/CALCITE-6558?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17879077#comment-17879077
]
Mihai Budiu commented on CALCITE-6558:
--------------------------------------
I don't see the "first" function as being supported by Calcite:
https://calcite.apache.org/docs/reference.html
> zero literal is appended as a paramer for FIRST/LAST but Spark requires
> boolean
> -------------------------------------------------------------------------------
>
> Key: CALCITE-6558
> URL: https://issues.apache.org/jira/browse/CALCITE-6558
> Project: Calcite
> Issue Type: Bug
> Components: core
> Affects Versions: 1.32.0
> Reporter: peng wu
> Priority: Major
>
> give the sql parser s simple input:
> {code:java}
> first(`my_column`){code}
> After the SQL string is parsed as SqlNode, then an extra parameter is added
> to the first function, and the sql becomes:
> {code:java}
> first(`my_column`, 0) {code}
> Error would be thrown when the above sql is executed by spark:
> "The second argument in first should be a boolean literal"
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
