Issue with Column Casting in Dremio-SingleStore Connector: SQL Syntax Error When Using Selected Column in WHERE Clause

21

Hi,

there shouldn’t be any other dependencies needed for this particular issue. The goal is to reflect the SingleStore API using the ARP file. Please note that our support for community connectors is limited, but you can always open a support case and ask for SingleStore to be supported natively.

All the best

22

Hi @Simon_Pannek

Thanks for your information.Even though the CAST function appears to work correctly in SingleStore, when we submit the query through Dremio, it seems that Dremio is internally rewriting the query by adding the CAST function before passing it to the driver. This happens even when the CAST functionality is removed from the SingleStore ARP file. So how dremio is internally handling this CAST functionality

23

The reason why dremio is casting here might not be the cast function itself, if the data type mapping at the top of the arp file does not reflect the data types supported by SingleStore correctly, Dremio might try to cast to different types to fix this.
So don’t just look at the cast function, verify that your data type mappings are correct as well.