I'm using In-db plugin and Alteryx seems to cast the field used in Avg to REAL. My database doesn't support real. Is there a way to change this behavior? It doesn't do it for things like SUM.
AVG(CAST(field as REAL))
I have created some mappings of the datatypes using the sample from here: C:\Users\<user>\AppData\Local\Alteryx\bin\RuntimeData\ODBC
But that doesn't seem to be for how Alteryx generates the SQL to the database. Any help is appreciated.
