calcite-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Julian Hyde <>
Subject Re: explain
Date Tue, 14 Jul 2015 22:06:26 GMT
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 <> 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 <> wrote:
>> 1. I am trying to run explain on few queries (in sqlline) and it seems it
>> truncates the explain output. Found this :
>> 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

View raw message