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.
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.
@Rakesh_Malugu Thank you