In sqlline, try !set outputformat csv
before you run explain. Then it won't truncate the plan. On Thu, Jun 2, 2016 at 2:27 PM, Peter Michalák (PGR) <[email protected]> wrote: > Hello Everyone, > > I’m experimenting with calcite as I’d like to use it for query planning in my > project. > > When I run following (in sqlline): > > explain plan for SELECT activity.user_id,x,y,z,glucose FROM pebble > AS activity JOIN cgm AS glucose ON activity.user_id = glucose.user_id > WHERE vibe = 0; > > I get: > > EnumerableCalc(expr#0..7=[{inputs}], proj#0..3=[{exprs}], GLUCOSE=[$t6]) > EnumerableJoin(condition=[= | > > The end of the plan is a bit which worries me, as it doesn’t seem complete, > like the printout ends prematurely. > > Does anyone know how to get full plan printout or point me in right > direction, please? > > A snippet of plans I'm exploring: > https://drive.google.com/open?id=0B6yUxQGvfszKMnhOVDN1eVlVUG8 > > Thank you! > > > Best Regards, > -Peter > > > -- > Peter Michalák > CDT Cloud Computing for Big Data > Digital Institute, Newcastle University > The Core, Science Central > Newcastle upon Tyne, NE4 5TF > www.bigdata-cdt.ac.uk<http://www.bigdata-cdt.ac.uk/> > email: [email protected]<mailto:[email protected]> > linkedin.com/in/petermichalak<http://linkedin.com/in/petermichalak> > @petomichalak
