Regarding (2). I think you're asking for contradictory things. "WITHOUT IMPLEMENTATION" gives you the plan as it comes out of the sql-to-rel converter. "WITH IMPLEMENTATION" gives you the best plan chosen by the optimizer. Since Logical rels don't have a cost the best plan is never going to be in terms of Logical rels.
On Tue, Jul 14, 2015 at 3:04 PM, Julian Hyde <[email protected]> wrote: > Run '!set outputformat csv'. The csv output format doesn't try to fit > strings into a particular width. > > Sqlline's default format, 'table', should probably recognize > multi-line strings and truncate to make sure that no line is longer > than the current width, but allow the whole multi-line string to be > longer. > > On Tue, Jul 14, 2015 at 10:31 AM, Ashutosh Chauhan <[email protected]> > wrote: >> 1. I am trying to run explain on few queries (in sqlline) and it seems it >> truncates the explain output. Found this : >> https://issues.apache.org/jira/browse/CALCITE-150 Is there any workaround >> for this? >> >> 2. If I do {{ explain plan without implementation }} it shows me plan in >> terms of Logical Rels, which is what I want, but it seems that plan is not >> optimized, ie no rules are fired on it. Can someone confirm that? I want to >> see optimized plan in terms of Logical Rels >> >> Thanks, >> Ashutosh
