org.apache.drill.exec.physical.impl.join

Class TestNestedLoopJoin

java.lang.Object

DrillTest

org.apache.drill.exec.ExecTest

org.apache.drill.test.BaseTestQuery

org.apache.drill.PlanTestBase

org.apache.drill.exec.physical.impl.join.JoinTestBase

org.apache.drill.exec.physical.impl.join.TestNestedLoopJoin

public class TestNestedLoopJoin
extends JoinTestBase

Nested Class Summary

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

BaseTestQuery.ClassicTestServices, BaseTestQuery.SilentListener, BaseTestQuery.TestResultSet

Field Summary

Fields inherited from class org.apache.drill.exec.physical.impl.join.JoinTestBase

DISABLE_HJ, DISABLE_JOIN_OPTIMIZATION, DISABLE_MJ, DISABLE_NLJ_SCALAR, ENABLE_HJ, ENABLE_MJ, ENABLE_NLJ_SCALAR, HJ_PATTERN, INNER_JOIN_TYPE, LEFT_JOIN_TYPE, MJ_PATTERN, NLJ_PATTERN, RESET_HJ, RESET_JOIN_OPTIMIZATION, RIGHT_JOIN_TYPE

Fields inherited from class org.apache.drill.PlanTestBase

EXPECTED_NOT_FOUND, JSON_FORMAT, OPTIQ_FORMAT, UNEXPECTED_FOUND

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

Constructor Summary

Constructors

Constructor and Description
TestNestedLoopJoin()

Method Summary

Modifier and Type	Method and Description
static void	setupTestFiles()
void	testNestedInnerJoinWithEmptyTable()
void	testNestedLeftJoinWithEmptyTable()
void	testNestedRightJoinWithEmptyTable()
void	testNlJoinAggrs_1_planning()
void	testNLJoinCorrectnessRightMultipleBatches() Validates correctness of NestedLoopJoin when right side has multiple batches.
void	testNlJoinEqualityNonScalar_1_planning()
void	testNlJoinEqualityNonScalar_2_planning()
void	testNlJoinEqualityScalar_1_planning()
void	testNlJoinEqualityScalar_2_planning()
void	testNlJoinExists_1_exec()
void	testNlJoinExists_1_planning()
void	testNlJoinInequality_1()
void	testNlJoinInequality_2()
void	testNlJoinInequality_3()
void	testNlJoinInnerBetween()
void	testNlJoinLeftBetween()
void	testNlJoinNotIn_1_exec()
void	testNlJoinNotIn_1_planning()
void	testNlJoinNotIn_2_exec()
void	testNlJoinWithLargeRightInputFailure()
void	testNlJoinWithLargeRightInputSuccess()
void	testNlJoinWithStringsInCondition()
void	testNLJWithEmptyBatch()

Methods inherited from class org.apache.drill.exec.physical.impl.join.JoinTestBase

enableJoin, resetJoinOptions, testJoinWithEmptyFile

Methods inherited from class org.apache.drill.PlanTestBase

checkForMetadataFile, createMetadataDir, getPhysicalJsonPlan, getPlanInString, testPhysicalPlan, testPhysicalPlanExecutionBasedOnQuery, testPlanMatchingPatterns, testPlanMatchingPatterns, testPlanMatchingPatterns, testPlanMatchingPatterns, testPlanOneExcludedPattern, testPlanOneExpectedPattern, testPlanOneExpectedPatternOneExcluded, testPlanSubstrPatterns, testPlanWithAttributesMatchingPatterns, testRelLogicalJoinOrder, testRelLogicalPlanLevDigest, testRelLogicalPlanLevExplain, testRelPhysicalJoinOrder, testRelPhysicalPlanLevDigest, testRelPhysicalPlanLevExplain

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 java.lang.Object

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

Constructor Detail

TestNestedLoopJoin

public TestNestedLoopJoin()

Method Detail

setupTestFiles

public static void setupTestFiles()

testNlJoinExists_1_planning

public void testNlJoinExists_1_planning()
                                 throws Exception

Throws:

Exception

testNlJoinNotIn_1_planning

public void testNlJoinNotIn_1_planning()
                                throws Exception

Throws:

Exception

testNlJoinInequality_1

public void testNlJoinInequality_1()
                            throws Exception

Throws:

Exception

testNlJoinInequality_2

public void testNlJoinInequality_2()
                            throws Exception

Throws:

Exception

testNlJoinInequality_3

public void testNlJoinInequality_3()
                            throws Exception

Throws:

Exception

testNlJoinAggrs_1_planning

public void testNlJoinAggrs_1_planning()
                                throws Exception

Throws:

Exception

testNlJoinEqualityScalar_1_planning

public void testNlJoinEqualityScalar_1_planning()
                                         throws Exception

Throws:

Exception

testNlJoinEqualityScalar_2_planning

public void testNlJoinEqualityScalar_2_planning()
                                         throws Exception

Throws:

Exception

testNlJoinEqualityNonScalar_1_planning

public void testNlJoinEqualityNonScalar_1_planning()
                                            throws Exception

Throws:

Exception

testNlJoinEqualityNonScalar_2_planning

public void testNlJoinEqualityNonScalar_2_planning()
                                            throws Exception

Throws:

Exception

testNlJoinExists_1_exec

public void testNlJoinExists_1_exec()
                             throws Exception

Throws:

Exception

testNlJoinNotIn_1_exec

public void testNlJoinNotIn_1_exec()
                            throws Exception

Throws:

Exception

testNlJoinNotIn_2_exec

public void testNlJoinNotIn_2_exec()
                            throws Exception

Throws:

Exception

testNLJWithEmptyBatch

public void testNLJWithEmptyBatch()
                           throws Exception

Throws:

Exception

testNlJoinInnerBetween

public void testNlJoinInnerBetween()
                            throws Exception

Throws:

Exception

testNlJoinLeftBetween

public void testNlJoinLeftBetween()
                           throws Exception

Throws:

Exception

testNlJoinWithLargeRightInputFailure

public void testNlJoinWithLargeRightInputFailure()
                                          throws Exception

Throws:

Exception

testNlJoinWithLargeRightInputSuccess

public void testNlJoinWithLargeRightInputSuccess()
                                          throws Exception

Throws:

Exception

testNestedLeftJoinWithEmptyTable

public void testNestedLeftJoinWithEmptyTable()
                                      throws Exception

Throws:

Exception

testNestedInnerJoinWithEmptyTable

public void testNestedInnerJoinWithEmptyTable()
                                       throws Exception

Throws:

Exception

testNestedRightJoinWithEmptyTable

public void testNestedRightJoinWithEmptyTable()
                                       throws Exception

Throws:

Exception

testNLJoinCorrectnessRightMultipleBatches

public void testNLJoinCorrectnessRightMultipleBatches()
                                               throws Exception

Validates correctness of NestedLoopJoin when right side has multiple batches. See DRILL-6128 for details

Throws:

Exception

testNlJoinWithStringsInCondition

public void testNlJoinWithStringsInCondition()
                                      throws Exception

Throws:

Exception