On a previous thread, I asked about this, as it is not just for debugging but user-facing. It seems there is no reliable way to build a tool on top of Calcite that gives high assurance of avoiding CannotPlanException reaching a user.
Are other planners better for this? Beam SQL would probably consider any options if they improve usability. Perhaps one way to explain a CannotPlanException might be to present a set of additional rules that would be required to reach a plan, and try to make them somehow "reasonable" or "minimal". For example if you wanted convention BAZ but didn't have a converter from FooSomeRel to BazSomeRel it would be great to be able to say that. It could also be useful to highlight rules where the structure matched but side conditions did not. Kenn On Mon, Jan 28, 2019 at 8:16 AM Vladimir Sitnikov < sitnikov.vladi...@gmail.com> wrote: > > toGraphViz > > A bit of problem with GraphViz is it is more or less static. > However sometimes it might be great to move/expand/collapse nodes. For > instance, for "Project" it makes sense to show expressions. > > So I'm a bit puzzled between "JS-based chart" vs GraphViz vs a plugin > for IntelliJ (e.g. jgraphx-based) > > > Anton Haidai did a nice visualizer [1] for sets, subsets, and rels using > > Thanks for pointing it. > My initial though was to visualize Sets / SubSets as nested charts. > > >perhaps the path to a > > generated graph created in a temp directory could be part of the > > exception > > Or a base64-encoded blob with a link to "visualize it" ) > > Vladimir >