Details
-
Sub-task
-
Status: Resolved
-
Major
-
Resolution: Won't Fix
-
None
-
None
-
None
-
None
Description
For many queries (merge joins, union all, some distincts, etc) Phoenix needs to ship data to the client. It will happily try to do that even when that requires shipping terrabytes of data to the poor client to do its final merge sweep.
Phoenix should have an option to detect these cases (from the stats and the query plan), and simply - and optionally - fail the query immediately with "Query too complicated", or "Query too slow", or something.