com.mapd.tests.CalciteViewsConcurrencyTest Class Reference

Collaboration diagram for com.mapd.tests.CalciteViewsConcurrencyTest:

Public Member Functions
void	testViewsResolutionConcurrency () throws Exception

Static Public Member Functions
static void	main (String[] args) throws Exception

Static Package Attributes
static final Logger	logger = LoggerFactory.getLogger(CalciteViewsConcurrencyTest.class)

Detailed Description

Definition at line 26 of file CalciteViewsConcurrencyTest.java.

Member Function Documentation

static void com.mapd.tests.CalciteViewsConcurrencyTest.main ( String[]  args ) throws Exception

inlinestatic

Definition at line 29 of file CalciteViewsConcurrencyTest.java.

                                                          {
    CalciteViewsConcurrencyTest test = new CalciteViewsConcurrencyTest();
    test.testViewsResolutionConcurrency();
  }

void com.mapd.tests.CalciteViewsConcurrencyTest.testViewsResolutionConcurrency ( ) throws Exception

inline

Definition at line 34 of file CalciteViewsConcurrencyTest.java.

References run.

                                                                {
    logger.info("testViewsResolutionConcurrency()");

    HeavyDBTestClient su = HeavyDBTestClient.getClient(
            "localhost", 6274, "heavyai", "admin", "HyperInteractive");

    su.runSql("CREATE DATABASE db1;");
    su.runSql("CREATE DATABASE db2;");

    HeavyDBTestClient db1 = HeavyDBTestClient.getClient(
            "localhost", 6274, "db1", "admin", "HyperInteractive");
    db1.runSql("create table table1 (id integer, description varchar(30));");
    db1.runSql("create table table2 (id integer, description varchar(30));");
    db1.runSql("insert into table1 values (1, 'hello');");
    db1.runSql("insert into table2 values (1, 'db1');");
    db1.runSql(
            "create view v_goodview as select t1.id, t1.description, t2.description as tbl2Desc from db1.table1 t1, db1.table2 t2;");

    HeavyDBTestClient db2 = HeavyDBTestClient.getClient(
            "localhost", 6274, "db2", "admin", "HyperInteractive");
    db2.runSql("create table table1 (id integer, description varchar(30));");
    db2.runSql("create table table2 (id integer, description varchar(30));");
    db2.runSql("insert into table1 values (1, 'hello');");
    db2.runSql("insert into table2 values (1, 'db2');");
    db2.runSql(
            "create view v_goodview as select t1.id, t1.description, t2.description as tbl2Desc from db2.table1 t1, db2.table2 t2;");

    int num_threads = 10;
    Exception exceptions[] = new Exception[num_threads];
    List<Thread> threads = new ArrayList<>();
    for (int i = 0; i < num_threads; i++) {
      final int threadId = i;
      HeavyDBTestClient con1 = HeavyDBTestClient.getClient(
              "localhost", 6274, "db1", "admin", "HyperInteractive");
      HeavyDBTestClient con2 = HeavyDBTestClient.getClient(
              "localhost", 6274, "db2", "admin", "HyperInteractive");
      Thread t = new Thread(new Runnable() {
        @Override
        public void run() {
          try {
            for (int i = 0; i < 25; i++) {
              con1.runSql("SELECT * FROM v_goodview;");
              con2.runSql("SELECT * FROM v_goodview;");
            }
          } catch (Exception e) {
            e.printStackTrace();
            exceptions[threadId] = e;
          }
        }
      });

      t.start();
      threads.add(t);
    }

    for (Thread t : threads) {
      t.join();
    }

    su.runSql("DROP DATABASE db1;");
    su.runSql("DROP DATABASE db2;");

    for (Exception e : exceptions) {
      if (null != e) {
        throw e;
      }
    }
  }

Member Data Documentation

final Logger com.mapd.tests.CalciteViewsConcurrencyTest.logger = LoggerFactory.getLogger(CalciteViewsConcurrencyTest.class)

staticpackage

Definition at line 27 of file CalciteViewsConcurrencyTest.java.

---

The documentation for this class was generated from the following file:

• /home/jenkins-slave/workspace/core-os-doxygen/java/utility/src/main/java/com/mapd/tests/CalciteViewsConcurrencyTest.java