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
