Forum Discussion

irismaessen's avatar
irismaessen
Data Pipeline
03-09-2023
Solved

Using SingleStore for a Live Model - any issues?

Has anyone used SingleStore as a basis for a Live Model?  

We are experimenting with it but are running into some issues with date or date/time fields and I was wondering if anyone else encountered similar issues. 


Data Connectors
Data Warehouses
  • irismaessen's avatar
    irismaessen
    03-13-2023

    The issue we were running into turned out to be related to a compatibility mode settings for Singlestore -- newer versions of Singlestore have stricter date/time conversion syntax/behaviour. Setting the compatibility mode in Singlestore to 6.0 made things work.

1 Reply

Replies have been turned off for this discussion
  • irismaessen's avatar
    irismaessen
    Data Pipeline
    03-13-2023

    The issue we were running into turned out to be related to a compatibility mode settings for Singlestore -- newer versions of Singlestore have stricter date/time conversion syntax/behaviour. Setting the compatibility mode in Singlestore to 6.0 made things work.