Dell reported this issue to use and we were unable to resolve it. If the Greenplum database goes down and a user tries to cancel a query then the driver hangs. We've been told this CancelDetectInterval in extended properties would fix this. Personally, I think it is a bug which should be addressed. Thank you for reading!

https://knowledgebase.progress.com/articles/Article/SQLcancel-command-hangs-indefinitely-with-the-ODBC-Greenplum-driver?_ga=2.135113144.858164170.1566857687-607916170.1566857687