Package org.voltdb.compiler

Examples of org.voltdb.compiler.VoltProjectBuilder.addTablePartitionInfo()

524
525
526
527
528
529
530
531
532
533
534
        MultiConfigSuiteBuilder builder = new MultiConfigSuiteBuilder(TestIndexesSuite.class);

        VoltProjectBuilder project = new VoltProjectBuilder("indexes");
        project.addSchema(Insert.class.getResource("indexes-ddl.sql"));
        project.addTablePartitionInfo("P1", "ID");
        project.addTablePartitionInfo("P2", "ID");
        project.addTablePartitionInfo("P3", "ID");
        project.addProcedures(PROCEDURES);
       
        for (String tableName : ALL_TABLES) {
            String procName = "Eng397LimitIndex" + tableName;
View Full Code Here
525
526
527
528
529
530
531
532
533
534
535
        VoltProjectBuilder project = new VoltProjectBuilder("indexes");
        project.addSchema(Insert.class.getResource("indexes-ddl.sql"));
        project.addTablePartitionInfo("P1", "ID");
        project.addTablePartitionInfo("P2", "ID");
        project.addTablePartitionInfo("P3", "ID");
        project.addProcedures(PROCEDURES);
       
        for (String tableName : ALL_TABLES) {
            String procName = "Eng397LimitIndex" + tableName;
            String sql = String.format("SELECT * FROM %s WHERE %s.ID > 2 LIMIT ?", tableName, tableName);
View Full Code Here
443
444
445
446
447
448
449
450
451
452
453
        VoltServerConfig config = new LocalSingleProcessServer("failures-onesite.jar", 1, BackendTarget.NATIVE_EE_JNI);

        // build up a project builder for the workload
        VoltProjectBuilder project = new VoltProjectBuilder("failures");
        project.addSchema(DivideByZero.class.getResource("failures-ddl.sql"));
        project.addTablePartitionInfo("NEW_ORDER", "NO_W_ID");
        project.addTablePartitionInfo("FIVEK_STRING", "P");
        project.addTablePartitionInfo("FIVEK_STRING_WITH_INDEX", "ID");
        project.addTablePartitionInfo("WIDE", "P");
        project.addProcedures(PROCEDURES);
        project.addStmtProcedure("InsertNewOrder", "INSERT INTO NEW_ORDER VALUES (?, ?, ?);", "NEW_ORDER.NO_W_ID: 2");
View Full Code Here
444
445
446
447
448
449
450
451
452
453
454
        // build up a project builder for the workload
        VoltProjectBuilder project = new VoltProjectBuilder("failures");
        project.addSchema(DivideByZero.class.getResource("failures-ddl.sql"));
        project.addTablePartitionInfo("NEW_ORDER", "NO_W_ID");
        project.addTablePartitionInfo("FIVEK_STRING", "P");
        project.addTablePartitionInfo("FIVEK_STRING_WITH_INDEX", "ID");
        project.addTablePartitionInfo("WIDE", "P");
        project.addProcedures(PROCEDURES);
        project.addStmtProcedure("InsertNewOrder", "INSERT INTO NEW_ORDER VALUES (?, ?, ?);", "NEW_ORDER.NO_W_ID: 2");
        // build the jarfile
View Full Code Here
445
446
447
448
449
450
451
452
453
454
455
        // build up a project builder for the workload
        VoltProjectBuilder project = new VoltProjectBuilder("failures");
        project.addSchema(DivideByZero.class.getResource("failures-ddl.sql"));
        project.addTablePartitionInfo("NEW_ORDER", "NO_W_ID");
        project.addTablePartitionInfo("FIVEK_STRING", "P");
        project.addTablePartitionInfo("FIVEK_STRING_WITH_INDEX", "ID");
        project.addTablePartitionInfo("WIDE", "P");
        project.addProcedures(PROCEDURES);
        project.addStmtProcedure("InsertNewOrder", "INSERT INTO NEW_ORDER VALUES (?, ?, ?);", "NEW_ORDER.NO_W_ID: 2");
        // build the jarfile
        if (!config.compile(project))
View Full Code Here
446
447
448
449
450
451
452
453
454
455
456
        VoltProjectBuilder project = new VoltProjectBuilder("failures");
        project.addSchema(DivideByZero.class.getResource("failures-ddl.sql"));
        project.addTablePartitionInfo("NEW_ORDER", "NO_W_ID");
        project.addTablePartitionInfo("FIVEK_STRING", "P");
        project.addTablePartitionInfo("FIVEK_STRING_WITH_INDEX", "ID");
        project.addTablePartitionInfo("WIDE", "P");
        project.addProcedures(PROCEDURES);
        project.addStmtProcedure("InsertNewOrder", "INSERT INTO NEW_ORDER VALUES (?, ?, ?);", "NEW_ORDER.NO_W_ID: 2");
        // build the jarfile
        if (!config.compile(project))
            fail();
View Full Code Here
968
969
970
971
972
973
974
975
976
977
978
        builder.setGlobalConfParameter("site.status_thread_info", false);
        builder.setGlobalConfParameter("site.txn_profiling", false);

        VoltProjectBuilder project = new VoltProjectBuilder("fixed");
        project.addSchema(Insert.class.getResource("fixed-sql-ddl.sql"));
        project.addTablePartitionInfo("P1", "ID");
        project.addTablePartitionInfo("P2", "ID");
        project.addTablePartitionInfo("ASSET", "ASSET_ID");
        project.addTablePartitionInfo("OBJECT_DETAIL", "OBJECT_DETAIL_ID");
        project.addProcedures(PROCEDURES);
        project.addStmtProcedure("Eng397Limit1", "Select P1.NUM from P1 order by P1.NUM limit ?;");
View Full Code Here
969
970
971
972
973
974
975
976
977
978
979
        builder.setGlobalConfParameter("site.txn_profiling", false);

        VoltProjectBuilder project = new VoltProjectBuilder("fixed");
        project.addSchema(Insert.class.getResource("fixed-sql-ddl.sql"));
        project.addTablePartitionInfo("P1", "ID");
        project.addTablePartitionInfo("P2", "ID");
        project.addTablePartitionInfo("ASSET", "ASSET_ID");
        project.addTablePartitionInfo("OBJECT_DETAIL", "OBJECT_DETAIL_ID");
        project.addProcedures(PROCEDURES);
        project.addStmtProcedure("Eng397Limit1", "Select P1.NUM from P1 order by P1.NUM limit ?;");
       
View Full Code Here
970
971
972
973
974
975
976
977
978
979
980
        VoltProjectBuilder project = new VoltProjectBuilder("fixed");
        project.addSchema(Insert.class.getResource("fixed-sql-ddl.sql"));
        project.addTablePartitionInfo("P1", "ID");
        project.addTablePartitionInfo("P2", "ID");
        project.addTablePartitionInfo("ASSET", "ASSET_ID");
        project.addTablePartitionInfo("OBJECT_DETAIL", "OBJECT_DETAIL_ID");
        project.addProcedures(PROCEDURES);
        project.addStmtProcedure("Eng397Limit1", "Select P1.NUM from P1 order by P1.NUM limit ?;");
       
        // TODO: Hardcoded procedures for ad-hoc queries
View Full Code Here
971
972
973
974
975
976
977
978
979
980
981
        VoltProjectBuilder project = new VoltProjectBuilder("fixed");
        project.addSchema(Insert.class.getResource("fixed-sql-ddl.sql"));
        project.addTablePartitionInfo("P1", "ID");
        project.addTablePartitionInfo("P2", "ID");
        project.addTablePartitionInfo("ASSET", "ASSET_ID");
        project.addTablePartitionInfo("OBJECT_DETAIL", "OBJECT_DETAIL_ID");
        project.addProcedures(PROCEDURES);
        project.addStmtProcedure("Eng397Limit1", "Select P1.NUM from P1 order by P1.NUM limit ?;");
       
        // TODO: Hardcoded procedures for ad-hoc queries
        project.addStmtProcedure("Ticket309P1", "select count(*), P1.NUM from P1 group by P1.NUM");
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.