@Test public final void testCreateTable2() throws Exception { executeString("CREATE DATABASE D1;").close(); executeString("CREATE DATABASE D2;").close(); executeString("CREATE TABLE D1.table1 (age int);").close(); executeString("CREATE TABLE D1.table2 (age int);").close(); executeString("CREATE TABLE d2.table3 (age int);").close(); executeString("CREATE TABLE d2.table4 (age int);").close(); assertTableExists("d1.table1"); assertTableExists("d1.table2"); assertTableNotExists("d2.table1"); assertTableNotExists("d2.table2"); assertTableExists("d2.table3"); assertTableExists("d2.table4"); assertTableNotExists("d1.table3"); assertTableNotExists("d1.table4"); executeString("DROP TABLE D1.table1"); executeString("DROP TABLE D1.table2"); executeString("DROP TABLE D2.table3"); executeString("DROP TABLE D2.table4"); assertDatabaseExists("d1"); assertDatabaseExists("d2"); executeString("DROP DATABASE D1").close(); executeString("DROP DATABASE D2").close(); assertDatabaseNotExists("d1"); assertDatabaseNotExists("d2"); }
@Test public final void testDropTableIfExists() throws Exception { executeString("CREATE DATABASE D7;").close(); assertTableNotExists("d7.table1"); executeString("CREATE TABLE d7.table1 (age int);").close(); assertTableExists("d7.table1"); executeString("DROP TABLE d7.table1;").close(); assertTableNotExists("d7.table1"); executeString("DROP TABLE IF EXISTS d7.table1"); assertTableNotExists("d7.table1"); executeString("DROP DATABASE D7;").close(); }
@Test public final void testNestedRecord2() throws Exception { executeString("CREATE DATABASE D9;").close(); assertTableNotExists("d9.nested_table2"); executeQuery(); assertTableExists("d9.nested_table2"); executeString("DROP TABLE D9.nested_table2"); executeString("DROP DATABASE D9").close(); }
@Test public final void testSelfDescTable1() throws Exception { executeString("create database d9;").close(); assertTableNotExists("d9.schemaless"); executeQuery(); assertTableExists("d9.schemaless"); TableDesc desc = getClient().getTableDesc("d9.schemaless"); assertTrue(desc.hasEmptySchema()); executeString("drop table d9.schemaless").close(); executeString("drop database d9").close(); }
@Test public final void testCreateTableIfNotExists() throws Exception { executeString("CREATE DATABASE D3;").close(); assertTableNotExists("d3.table1"); executeString("CREATE TABLE D3.table1 (age int);").close(); assertTableExists("d3.table1"); executeString("CREATE TABLE IF NOT EXISTS D3.table1 (age int);").close(); assertTableExists("d3.table1"); executeString("DROP TABLE D3.table1"); }