Thanks Julian, worked like a charm! Now, I just need to figure out how to get the same representation of a query plan in Java. : )
On 02/06/2016, 22:40, "Julian Hyde" <[email protected]> wrote: >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 >
