I’ve tried to execute similar query on my cluster and very bad things happened. Memory is eaten on whole cluster with 8 nodes, and cluster become unusable. Some of nodes needed to be restarted because all memory, swap space and resources was exhausted and even ssh was unable to connect to the nodes.