The author of the Jira [1] wants an easy way to configure the sub query threshold potentially using some property.
He has pinged us quite a few times so it would be good to provide a direction on how to do it or give a definitive answer that we are not going to do it. I gave my opinion in the Jira but it would be great if somebody else can also have a look. Best, Stamatis [1] https://issues.apache.org/jira/browse/CALCITE-2696
