[Spark-4484] Treat maxResultSize as unlimited when set to 0; improve error message 

The check for maxResultSize > 0 is missing, results in failures. Also, error message needs to be improved so the developers know that there is a new parameter to be configured