Examples of toExplainPlanString()

Examples of org.voltdb.plannodes.AbstractPlanNode.toExplainPlanString()

80
81
82
83
84
85
86
87
88
89
90
            assert( pnList.size() == 2 );
            assert( pnList.get(1) instanceof SendPlanNode );
            if ( pnList.get(0).reattachFragment( ( SendPlanNode )pnList.get(1) ) ) {
                AbstractPlanNode pn = pnList.get(0);
                System.out.println( pn.toExplainPlanString() );
                assertTrue( pn.toExplainPlanString().contains("SEND PARTITION RESULTS TO COORDINATOR"));
            }
        } catch (Exception e) {
            e.printStackTrace();
        }
View Full Code Here

Examples of org.voltdb.plannodes.AbstractPlanNode.toExplainPlanString()

81
82
83
84
85
86
87
88
89
90
91
            assert( pnList.size() == 2 );
            assert( pnList.get(1) instanceof SendPlanNode );
            if ( pnList.get(0).reattachFragment( ( SendPlanNode )pnList.get(1) ) ) {
                AbstractPlanNode pn = pnList.get(0);
                System.out.println( pn.toExplainPlanString() );
                assertTrue( pn.toExplainPlanString().contains("SEND PARTITION RESULTS TO COORDINATOR"));
            }
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
View Full Code Here

Examples of org.voltdb.plannodes.AbstractPlanNode.toExplainPlanString()

101
102
103
104
105
106
107
108
109
110
111
        assert( pnList.get(1) instanceof SendPlanNode );
        pnList.get(0).reattachFragment( (SendPlanNode) pnList.get(1) );
        pn = pnList.get(0);
        System.out.println( pn.toJSONString() );
        System.out.println( pn.toExplainPlanString() );
        plannerTester.writePlanToFile( pn, path, "prettyJson.txt", "");

        ArrayList<String> getsql = new ArrayList<String>();
        PlanNodeTree pnt = plannerTester.loadPlanFromFile(path+"prettyJson.txt", getsql);
        System.out.println( pnt.toJSONString() );
View Full Code Here

Examples of org.voltdb.plannodes.AbstractPlanNode.toExplainPlanString()

127
128
129
130
131
132
133
134
135
136
137
        pn = compile("select * from l, t where l.b=t.b limit ?;");

        String path = m_homeDir+"/";
        plannerTester.setUpForTest(m_currentDir+"/tests/frontend/org/voltdb/planner/testplans-plannerTester-ddl.sql",
                "testplans-plannerTester-ddl");
        System.out.println( pn.toExplainPlanString() );
        System.out.println( pn.toJSONString() );
        plannerTester.writePlanToFile( pn, path, "prettyJson.txt", "");

        ArrayList<String> getsql = new ArrayList<String>();
        PlanNodeTree pnt = plannerTester.loadPlanFromFile(path+"prettyJson.txt", getsql);
View Full Code Here

Examples of org.voltdb.plannodes.AbstractPlanNode.toExplainPlanString()

154
155
156
157
158
159
160
161
162
163
164
        AbstractPlanNode pn1 = null;
        pn1 = compile("select * from l, t where t.b=l.b limit ?;");

        ArrayList<AbstractPlanNode> pnlist = pn1.getPlanNodeList();

        System.out.println( pn1.toExplainPlanString() );
        System.out.println( pnlist.size() );
        for( int i = 0; i<pnlist.size(); i++ ){
            System.out.println( pnlist.get(i).toJSONString() );
        }
        assertTrue( pnlist.size() == 6 );
View Full Code Here

Examples of org.voltdb.plannodes.AbstractPlanNode.toExplainPlanString()

483
484
485
486
487
488
489
490
491
492
493
            if( diff( pn1, pn2, false ) ) {
                m_numPass++;
                if( m_reportExplainedPlan ) {
                    m_reportWriter.write( "SQL statement:\n"+m_stmts.get(i)+"\n");
                    m_reportWriter.write("\nExplained plan:\n"+pn2.toExplainPlanString()+"\n");
                }
            } else {
                m_numFail++;
                m_reportWriter.write( "Statement "+i+" of "+config+": \n" );
                //TODO add more logic to determine which plan is better
View Full Code Here

Examples of org.voltdb.plannodes.AbstractPlanNode.toExplainPlanString()

514
515
516
517
518
519
520
521
522
523
524
                if( m_reportSQLStatement ) {
                    m_reportWriter.write( "SQL statement:\n"+baseStmt+"\n==>\n"+m_stmts.get(i)+"\n");
                }

                if( m_reportDiffExplainedPlan ) {
                    m_reportWriter.write("\nExplained plan:\n"+pn1.toExplainPlanString()+"\n==>\n"+pn2.toExplainPlanString()+"\n");
                }

                m_reportWriter.write("Path to the config file :"+config+"\n" +
                                     "Path to the baseline file :"+m_baselinePath+config+".plan"+i+"\n" +
                                     "Path to the current plan file :"+m_workPath+config+".plan"+i +
View Full Code Here

Examples of org.voltdb.plannodes.AbstractPlanNode.toExplainPlanString()

300
301
302
303
304
305
306
307
308
309
310
    private void checkJoinOrder(String sql, int... exceptions) {
        AbstractPlanNode pn, n;
        pn = compile(sql);
        n = pn.getChild(0).getChild(0);
        System.out.println(pn.toExplainPlanString());
        // starts from T7

        HashSet<Integer> mySets = new HashSet<>();
        for (int i : exceptions) {
            mySets.add(Integer.valueOf(i));
View Full Code Here

Examples of org.voltdb.plannodes.AbstractPlanNode.toExplainPlanString()

366
367
368
369
370
371
372
373
374
375
376
        // Sub-queries is an interesting question to test
        AbstractPlanNode pn;
        sql = "select * FROM T1, T2, (select T4.D from T3 right outer join T4 on T4.D = T3.C) TM1 LEFT OUTER JOIN T5 on T5.E = TM1.D, T6, T7";
        pn = compile(sql);
        validJoinOrder(pn.toExplainPlanString(), "T1", "T2",  "T4", "T3", "T5", "T6", "T7");
        /*
        NEST LOOP INNER JOIN
         NEST LOOP INNER JOIN
          NEST LOOP LEFT JOIN
           filter by (T5.E = TM1.D)
View Full Code Here

Examples of org.voltdb.plannodes.AbstractPlanNode.toExplainPlanString()

386
387
388
389
390
391
392
393
394
395
396
           SEQUENTIAL SCAN of "T5"
          SEQUENTIAL SCAN of "T6"
         SEQUENTIAL SCAN of "T7"
       */
        pn = compileSPWithJoinOrder(sql, "T1,T2,TM1,T5,T6,T7");
        validJoinOrder(pn.toExplainPlanString(), "T1", "T2",  "T4", "T3", "T5", "T6", "T7");
        //
        // Join order not the input table order
        //

        // Do we have a case the join order as the input table order that is invalid ?!
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.