Hi,
Is there any documentation for type conversions.
The Dremio UI is using CONVERT_TO_FLOAT(sales, 1, 1, 0) when data type is changed. But cannot find the details of the parameters required in the documentation.
https://docs.dremio.com/sql-reference/sql-functions/type-conversion.html
Hello @unni
When we use some the type conversion in the Dremio UI, in particular with conversion from text to numeric values, these functions are used. We generally do not document them because they are non-standard functions and we prefer that you use those with the stable function signature.
That being said, we realize that customers have used these in their VDS, so we will not be changing them any time in the near future.
Thanks,
@Rakesh_Malugu
@Rakesh_Malugu Thank you
Hi @Rakesh_Malugu,
Might I know what standard function to use to convert a string column to integer data type with handling that null values or some value is not an integer? thanks.
Donald
@donaldtse118 What version of Dremio are you using? Are you getting an error? Can you please share the profile?
Reason I am asking is if you are hitting a file schema and table schema data types are different