org.apache.drill

Class TestJoinNullable

java.lang.Object

org.apache.drill.test.BaseTest

org.apache.drill.test.DrillTest

org.apache.drill.exec.ExecTest

org.apache.drill.test.BaseTestQuery

org.apache.drill.TestJoinNullable

public class TestJoinNullable
extends BaseTestQuery

Nested Class Summary

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

BaseTestQuery.ClassicTestServices, BaseTestQuery.SilentListener, BaseTestQuery.TestResultSet

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

DrillTest.MemWatcher

Field Summary

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

allocator, bits, client, config, serviceSet

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
TestJoinNullable()

Method Summary

Modifier and Type	Method and Description
void	nullEqualJoinHelper(String query)
void	nullMixedComparatorEqualJoinHelper(String query)
void	testFullJoinUsingUntypedNullColumn()
void	testHashFOJOnNullableColumns() FullOuterJoin on nullable cols, HashJoin
void	testHashInnerJoinOnNullableColumns() InnerJoin on nullable cols, HashJoin
void	testHashLOJOnNullableColumns() LeftOuterJoin on nullable cols, HashJoin
void	testHashROJOnNullableColumns() RightOuterJoin on nullable cols, HashJoin
void	testMergeInnerJoinOnNullableColumns() InnerJoin on nullable cols, MergeJoin
void	testMergeLOJNullable() LeftOuterJoin on nullable cols, MergeJoin
void	testMergeLOJNullableBothInputsOrderedAscNullsFirstVsAscNullsFirst() Left outer join, merge, nullable col.
void	testMergeLOJNullableBothInputsOrderedAscNullsFirstVsAscNullsLast() Left outer join, merge, nullable col.
void	testMergeLOJNullableBothInputsOrderedAscNullsLastVsAscNullsFirst() Left outer join, merge, nullable col.
void	testMergeLOJNullableBothInputsOrderedAscNullsLastVsAscNullsLast() Left outer join, merge, nullable col.
void	testMergeLOJNullableBothInputsOrderedDescNullsFirstVsAscNullsFirst() Left outer join, merge, nullable col.
void	testMergeLOJNullableBothInputsOrderedDescNullsFirstVsAscNullsLast() Left outer join, merge, nullable col.
void	testMergeLOJNullableBothInputsOrderedDescNullsLastVsAscNullsFirst() Left outer join, merge, nullable col.
void	testMergeLOJNullableBothInputsOrderedDescNullsLastVsAscNullsLast() Left outer join, merge, nullable col.
void	testMergeLOJNullableNoOrderedInputs() Left outer join, merge, nullable col.
void	testMergeLOJNullableOneOrderedInputAscNullsFirst() Left outer join, merge, nullable col.
void	testMergeLOJNullableOneOrderedInputAscNullsLast() Left outer join, merge, nullable col.
void	testMergeLOJNullableOneOrderedInputDescNullsFirst() Left outer join, merge, nullable col.
void	testMergeLOJNullableOneOrderedInputDescNullsLast() Left outer join, merge, nullable col.
void	testMergeROJOnNullableColumns() RightOuterJoin on nullable cols, MergeJoin
void	testMixedEqualAndEqualOrHashJoin()
void	testMixedEqualAndEqualOrMergeJoin()
void	testMixedEqualAndIsNotDistinctFilterHashJoin()
void	testMixedEqualAndIsNotDistinctFilterMergeJoin()
void	testMixedEqualAndIsNotDistinctHashJoin()
void	testMixedEqualAndIsNotDistinctMergeJoin()
void	testNullEqualAdditionFilter()
void	testNullEqualHashJoin()
void	testNullEqualInWhereConditionHashJoin()
void	testNullEqualInWhereConditionMergeJoin()
void	testNullEqualMergeJoin()

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

alterSession, cloneDefaultTestConfigProperties, closeClient, errorMsgTestHelper, getAllocator, getDrillbitContext, getFile, getPhysicalFileFromResource, getResultString, getUserPort, logResult, newTest, parseErrorHelper, printResult, resetAllSessionOptions, resetDrillbitCount, resetSessionOption, runSQL, setColumnWidth, setColumnWidths, setSessionOption, setSessionOption, setSessionOption, setSessionOption, setupDefaultTestCluster, test, test, testBuilder, testLogicalWithResults, testNoResult, testNoResult, testPhysical, testPhysicalFromFile, testPhysicalWithResults, testPreparedStatement, testRunAndPrint, testRunAndReturn, testSql, testSqlWithResults, testWithListener, updateClient, updateClient, updateClient, updateTestCluster, updateTestCluster

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

TestJoinNullable

public TestJoinNullable()

Method Detail

testHashInnerJoinOnNullableColumns

public void testHashInnerJoinOnNullableColumns()
                                        throws Exception

InnerJoin on nullable cols, HashJoin

Throws:

Exception

testHashLOJOnNullableColumns

public void testHashLOJOnNullableColumns()
                                  throws Exception

LeftOuterJoin on nullable cols, HashJoin

Throws:

Exception

testHashROJOnNullableColumns

public void testHashROJOnNullableColumns()
                                  throws Exception

RightOuterJoin on nullable cols, HashJoin

Throws:

Exception

testHashFOJOnNullableColumns

public void testHashFOJOnNullableColumns()
                                  throws Exception

FullOuterJoin on nullable cols, HashJoin

Throws:

Exception

testMergeInnerJoinOnNullableColumns

public void testMergeInnerJoinOnNullableColumns()
                                         throws Exception

InnerJoin on nullable cols, MergeJoin

Throws:

Exception

testMergeLOJNullable

public void testMergeLOJNullable()
                          throws Exception

LeftOuterJoin on nullable cols, MergeJoin

Throws:

Exception

testMergeROJOnNullableColumns

public void testMergeROJOnNullableColumns()
                                   throws Exception

RightOuterJoin on nullable cols, MergeJoin

Throws:

Exception

testMergeLOJNullableNoOrderedInputs

public void testMergeLOJNullableNoOrderedInputs()
                                         throws Exception

Left outer join, merge, nullable col. - unordered inputs.

Throws:

Exception

testMergeLOJNullableOneOrderedInputAscNullsFirst

public void testMergeLOJNullableOneOrderedInputAscNullsFirst()
                                                      throws Exception

Left outer join, merge, nullable col. - ordered right, ASC NULLS FIRST (nulls low).

Throws:

Exception

testMergeLOJNullableOneOrderedInputAscNullsLast

public void testMergeLOJNullableOneOrderedInputAscNullsLast()
                                                     throws Exception

Left outer join, merge, nullable col. - ordered right, ASC NULLS LAST (nulls high).

Throws:

Exception

testMergeLOJNullableOneOrderedInputDescNullsFirst

public void testMergeLOJNullableOneOrderedInputDescNullsFirst()
                                                       throws Exception

Left outer join, merge, nullable col. - ordered right, DESC NULLS FIRST (nulls high).

Throws:

Exception

testMergeLOJNullableOneOrderedInputDescNullsLast

public void testMergeLOJNullableOneOrderedInputDescNullsLast()
                                                      throws Exception

Left outer join, merge, nullable col. - ordered right, DESC NULLS LAST (nulls low).

Throws:

Exception

testMergeLOJNullableBothInputsOrderedAscNullsFirstVsAscNullsFirst

public void testMergeLOJNullableBothInputsOrderedAscNullsFirstVsAscNullsFirst()
                                                                       throws Exception

Left outer join, merge, nullable col. - ordered inputs, both ASC NULLS FIRST (nulls low).

Throws:

Exception

testMergeLOJNullableBothInputsOrderedAscNullsLastVsAscNullsFirst

public void testMergeLOJNullableBothInputsOrderedAscNullsLastVsAscNullsFirst()
                                                                      throws Exception

Left outer join, merge, nullable col. - ordered inputs, different null order.

Throws:

Exception

testMergeLOJNullableBothInputsOrderedAscNullsFirstVsAscNullsLast

public void testMergeLOJNullableBothInputsOrderedAscNullsFirstVsAscNullsLast()
                                                                      throws Exception

Left outer join, merge, nullable col. - ordered inputs, other different null order.

Throws:

Exception

testMergeLOJNullableBothInputsOrderedAscNullsLastVsAscNullsLast

public void testMergeLOJNullableBothInputsOrderedAscNullsLastVsAscNullsLast()
                                                                     throws Exception

Left outer join, merge, nullable col. - ordered inputs, both ASC NULLS LAST (nulls high)

Throws:

Exception

testMergeLOJNullableBothInputsOrderedDescNullsFirstVsAscNullsFirst

public void testMergeLOJNullableBothInputsOrderedDescNullsFirstVsAscNullsFirst()
                                                                        throws Exception

Left outer join, merge, nullable col. - ordered inputs, DESC vs. ASC, NULLS FIRST (nulls high vs. nulls low).

Throws:

Exception

testMergeLOJNullableBothInputsOrderedDescNullsLastVsAscNullsFirst

public void testMergeLOJNullableBothInputsOrderedDescNullsLastVsAscNullsFirst()
                                                                       throws Exception

Left outer join, merge, nullable col. - ordered inputs, DESC vs. ASC, NULLS LAST vs. FIRST (both nulls low).

Throws:

Exception

testMergeLOJNullableBothInputsOrderedDescNullsFirstVsAscNullsLast

public void testMergeLOJNullableBothInputsOrderedDescNullsFirstVsAscNullsLast()
                                                                       throws Exception

Left outer join, merge, nullable col. - ordered inputs, DESC vs. ASC, NULLS FIRST vs. LAST (both nulls high).

Throws:

Exception

testMergeLOJNullableBothInputsOrderedDescNullsLastVsAscNullsLast

public void testMergeLOJNullableBothInputsOrderedDescNullsLastVsAscNullsLast()
                                                                      throws Exception

Left outer join, merge, nullable col. - ordered inputs, DESC vs. ASC, NULLS LAST (nulls low vs. nulls high).

Throws:

Exception

testNullEqualInWhereConditionHashJoin

public void testNullEqualInWhereConditionHashJoin()
                                           throws Exception

Throws:

Exception

testNullEqualInWhereConditionMergeJoin

public void testNullEqualInWhereConditionMergeJoin()
                                            throws Exception

Throws:

Exception

testNullEqualHashJoin

public void testNullEqualHashJoin()
                           throws Exception

Throws:

Exception

testNullEqualMergeJoin

public void testNullEqualMergeJoin()
                            throws Exception

Throws:

Exception

nullEqualJoinHelper

public void nullEqualJoinHelper(String query)
                         throws Exception

Throws:

Exception

testNullEqualAdditionFilter

public void testNullEqualAdditionFilter()
                                 throws Exception

Throws:

Exception

testMixedEqualAndIsNotDistinctHashJoin

public void testMixedEqualAndIsNotDistinctHashJoin()
                                            throws Exception

Throws:

Exception

testMixedEqualAndIsNotDistinctMergeJoin

public void testMixedEqualAndIsNotDistinctMergeJoin()
                                             throws Exception

Throws:

Exception

testMixedEqualAndIsNotDistinctFilterHashJoin

public void testMixedEqualAndIsNotDistinctFilterHashJoin()
                                                  throws Exception

Throws:

Exception

testMixedEqualAndIsNotDistinctFilterMergeJoin

public void testMixedEqualAndIsNotDistinctFilterMergeJoin()
                                                   throws Exception

Throws:

Exception

testMixedEqualAndEqualOrHashJoin

public void testMixedEqualAndEqualOrHashJoin()
                                      throws Exception

Throws:

Exception

testMixedEqualAndEqualOrMergeJoin

public void testMixedEqualAndEqualOrMergeJoin()
                                       throws Exception

Throws:

Exception

testFullJoinUsingUntypedNullColumn

public void testFullJoinUsingUntypedNullColumn()
                                        throws Exception

Throws:

Exception

nullMixedComparatorEqualJoinHelper

public void nullMixedComparatorEqualJoinHelper(String query)
                                        throws Exception

Throws:

Exception