org.apache.drill.jdbc.test

Class JdbcDataTest

java.lang.Object

org.apache.drill.test.BaseTest

org.apache.drill.test.DrillTest

org.apache.drill.exec.ExecTest

org.apache.drill.jdbc.JdbcTestBase

org.apache.drill.jdbc.test.JdbcDataTest

public class JdbcDataTest
extends JdbcTestBase

Unit tests for Drill's JDBC driver.

Nested Class Summary

Nested classes/interfaces inherited from class org.apache.drill.jdbc.JdbcTestBase

JdbcTestBase.ModelAndSchema, JdbcTestBase.TestDataConnection

Nested classes/interfaces inherited from class org.apache.drill.test.DrillTest

DrillTest.MemWatcher

Field Summary

Fields inherited from class org.apache.drill.jdbc.JdbcTestBase

watcher

Fields inherited from class org.apache.drill.exec.ExecTest

c, dirTestWatcher, optionManager

Fields inherited from class org.apache.drill.test.DrillTest

logOutcome, objectMapper, REPEAT_RULE, thrownException, TIMEOUT

Constructor Summary

Constructors

Constructor and Description
JdbcDataTest()

Method Summary

Modifier and Type	Method and Description
static void	main(String[] args) Command-line utility to execute a logical plan.
static void	setupFixtures()
void	testConnect() Load driver and make a connection.
void	testFilterConstant()
void	testFilterConstantFalse() Query with filter.
void	testFoodMart() Tests that one of the FoodMart tables is present.
void	testFullJoin()
void	testJoin()
void	testJoinOnSubquery() Join on subquery; also tests that if a field of the same name exists in both inputs, both fields make it through the join.
void	testLeftJoin()
void	testLimit()
void	testLimitOrderBy()
void	testLoadDriver() Load driver.
void	testLoadDriverServiceLoader() Load the driver using ServiceLoader
void	testOrderBy()
void	testOrderByDesc()
void	testOrderByDescNullsFirst()
void	testOrderByDescNullsLast()
void	testOrderByWithOffset()
void	testOrderByWithOffsetAndFetch()
void	testPrepare() Load driver, make a connection, prepare a statement.
void	testProject() Query that projects an element from the map.
void	testProjectConstant() Query with project list.
void	testProjectFilterSubquery() Query with subquery, filter, and projection of one real and one nonexistent field from a map field.
void	testProjectFilterSubqueryPlan()
void	testProjectNestedFieldSugared() Query that projects one field.
void	testProjectOnSubquery() Same logic as testProject(), but using a subquery.
void	testProjectPlan() Checks the logical plan.
void	testRightJoin() Right join is tricky because Drill's "join" operator only supports "left", so we have to flip inputs.
void	testSelectDept() Simple query against EMP table in HR database.
void	testSelectEmployees() Simple query against EMP table in HR database.
void	testSelectEmpView() Simple query against EMP table in HR database.
void	testSelectJson() Simple query against JSON.
void	testUnion()
void	testUnionAll()
void	testValues()

Methods inherited from class org.apache.drill.jdbc.JdbcTestBase

changeSchema, changeSchemaIfSupplied, connect, connect, connect, getDefaultProperties, reset, setUpTestCase, tearDownTestCase, testJdbcTestConnectionResettingCompatibility, toString, toString, withFull, withModel, withNoDefaultSchema

Methods inherited from class org.apache.drill.exec.ExecTest

clear, getLocalFileSystem, mockDrillbitContext, mockUsDateFormatSymbols, mockUtcDateTimeZone, parseExpr, setupOptionManager

Methods inherited from class org.apache.drill.test.DrillTest

escapeJsonString, finishDrillTest, initDrillTest

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

JdbcDataTest

public JdbcDataTest()

Method Detail

setupFixtures

public static void setupFixtures()
                          throws IOException

Throws:

IOException

main

public static void main(String[] args)
                 throws Exception

Command-line utility to execute a logical plan.

The forwarding method ensures that the IDE calls this method with the right classpath.

Throws:

Exception

testLoadDriver

public void testLoadDriver()
                    throws ClassNotFoundException

Load driver.

Throws:

ClassNotFoundException

testLoadDriverServiceLoader

public void testLoadDriverServiceLoader()

Load the driver using ServiceLoader

testConnect

public void testConnect()
                 throws Exception

Load driver and make a connection.

Throws:

Exception

testPrepare

public void testPrepare()
                 throws Exception

Load driver, make a connection, prepare a statement.

Throws:

Exception

testSelectJson

public void testSelectJson()
                    throws Exception

Simple query against JSON.

Throws:

Exception

testSelectEmployees

public void testSelectEmployees()
                         throws Exception

Simple query against EMP table in HR database.

Throws:

Exception

testSelectEmpView

public void testSelectEmpView()
                       throws Exception

Simple query against EMP table in HR database.

Throws:

Exception

testSelectDept

public void testSelectDept()
                    throws Exception

Simple query against EMP table in HR database.

Throws:

Exception

testProjectConstant

public void testProjectConstant()
                         throws Exception

Query with project list. No field references yet.

Throws:

Exception

testProject

public void testProject()
                 throws Exception

Query that projects an element from the map.

Throws:

Exception

testProjectOnSubquery

public void testProjectOnSubquery()
                           throws Exception

Same logic as testProject(), but using a subquery.

Throws:

Exception

testProjectPlan

public void testProjectPlan()
                     throws Exception

Checks the logical plan.

Throws:

Exception

testProjectFilterSubquery

public void testProjectFilterSubquery()
                               throws Exception

Query with subquery, filter, and projection of one real and one nonexistent field from a map field.

Throws:

Exception

testProjectFilterSubqueryPlan

public void testProjectFilterSubqueryPlan()
                                   throws Exception

Throws:

Exception

testProjectNestedFieldSugared

public void testProjectNestedFieldSugared()
                                   throws Exception

Query that projects one field. (Disabled; uses sugared syntax.)

Throws:

Exception

testFilterConstantFalse

public void testFilterConstantFalse()
                             throws Exception

Query with filter. No field references yet.

Throws:

Exception

testFilterConstant

public void testFilterConstant()
                        throws Exception

Throws:

Exception

testValues

public void testValues()
                throws Exception

Throws:

Exception

testJoin

public void testJoin()
              throws Exception

Throws:

Exception

testLeftJoin

public void testLeftJoin()
                  throws Exception

Throws:

Exception

testRightJoin

public void testRightJoin()
                   throws Exception

Right join is tricky because Drill's "join" operator only supports "left", so we have to flip inputs.

Throws:

Exception

testFullJoin

public void testFullJoin()
                  throws Exception

Throws:

Exception

testJoinOnSubquery

public void testJoinOnSubquery()
                        throws Exception

Join on subquery; also tests that if a field of the same name exists in both inputs, both fields make it through the join.

Throws:

Exception

testFoodMart

public void testFoodMart()
                  throws Exception

Tests that one of the FoodMart tables is present.

Throws:

Exception

testUnionAll

public void testUnionAll()
                  throws Exception

Throws:

Exception

testUnion

public void testUnion()
               throws Exception

Throws:

Exception

testOrderByDescNullsFirst

public void testOrderByDescNullsFirst()
                               throws Exception

Throws:

Exception

testOrderByDescNullsLast

public void testOrderByDescNullsLast()
                              throws Exception

Throws:

Exception

testOrderByDesc

public void testOrderByDesc()
                     throws Exception

Throws:

Exception

testOrderBy

public void testOrderBy()
                 throws Exception

Throws:

Exception

testLimit

public void testLimit()
               throws Exception

Throws:

Exception

testLimitOrderBy

public void testLimitOrderBy()
                      throws Exception

Throws:

Exception

testOrderByWithOffset

public void testOrderByWithOffset()
                           throws Exception

Throws:

Exception

testOrderByWithOffsetAndFetch

public void testOrderByWithOffsetAndFetch()
                                   throws Exception

Throws:

Exception