How about
Connection c;
Statement s = c.createStatement();
ResultSet r = s.executeQuery("explain plan for select ...");
r.next();
System.out.println(r.getString(1));
On Fri, Jun 3, 2016 at 9:11 AM, Peter Michalák (PGR)
<[email protected]> wrote:
> 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
>>
