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