Hi all, I'm trying to use CONVERT or CAST functions from Calcite docs to query some table with Table API. https://calcite.apache.org/docs/reference.html
csv_table.select("col1,CONCAT('field1:',col2,',field2:',CAST(col3 AS string))"); col3 is actually described as int the CSV schema and CONCAT doesn't like it. An exception is thrown "Undefined function: CAST" The docs mention that SQL implementation is based on Calcite and is there a list of available functions please? May I skip some useful dependency? Thanks in advance François