modeldb::linear_regression_db invalid operation

[callummcc7]

I am trying to run a model remotely with the 'linear_regression_db' function from the modeldb package. but am getting the following error:

This is being done via a connection to Amazon Redshift (which is based on postgresql 8.4) and maintained at the most up to date version. I have tried changing the JDBC driver to the latest version as well and still relieve the same error. I notice that it refers to the SQL count function - "(Amazon Invalid operation: function count() does not exist;)" , but am not sure what to make of this.

Thanks.

[mygeorgyboy]

Could you please turn this into a self-contained reprex (short for reproducible example)? It will help us help you if we can be sure we're all working with/looking at the same stuff.

If you found a solution, could you share it with us ?

Thanks

[juliasilge]

Check out this helpful article for tips on how to create a reprex for databases.