com.mapr.drill.maprdb.tests.index

Class IndexPlanTest

java.lang.Object

org.apache.drill.test.BaseTest

org.apache.drill.test.DrillTest

org.apache.drill.exec.ExecTest

org.apache.drill.test.BaseTestQuery

com.mapr.drill.maprdb.tests.json.BaseJsonTest

com.mapr.drill.maprdb.tests.index.IndexPlanTest

Direct Known Subclasses:

IndexHintPlanTest, StatisticsTest

public class IndexPlanTest
extends BaseJsonTest

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 com.mapr.drill.maprdb.tests.json.BaseJsonTest

SCHEMA

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

Method Summary

Modifier and Type	Method and Description
static void	cleanupTableIndexes()
void	CompositeIndexCoveringPlan()
void	CompositeIndexNonCoveringFilterWithAllFieldsPlan()
void	CompositeIndexNonCoveringPlan()
void	CoveringPlanWithNonIndexedField()
void	CoveringPlanWithOnlyIndexedField()
void	CoveringWithSimpleFieldsOnly()
void	CTASTestTable()
void	Intersect2indexesPlan()
void	IntersectPlanWithOneSideNoRows()
void	NoIndexPlanForNonIndexField()
void	NonCoveringPlan_SortPrefix_1()
void	NonCoveringPlan_SortPrefix_2()
void	NonCoveringPlan()
void	NonCoveringWithExtraConditonOnPrimary()
void	NonCoveringWithSimpleFieldsOnly()
void	nonIndexedColumnFilterCoveringPlan()
void	orderByCastCoveringPlan()
void	orderByCastNonCoveringPlan()
void	orderByLimitCoveringPlan()
void	orderByLimitNonCoveringPlan()
void	orderByNonCoveringPlan()
void	pickAnyIndexWithFTSDisabledPlan()
void	RangeConditionIndexPlan()
static void	setupTableIndexes() A sample row of this 10K table: ------------------+-----------------------------+--------+ | 1012 | {"city":"pfrrs","state":"pc"} | {"email":"KfFzKUZwNk@gmail.com","phone":"6500005471"} | {"ssn":"100007423"} | {"fname":"KfFzK","lname":"UZwNk"} | {"age":53.0,"income":45.0} | 1012 | This test suite generate random content to fill all the rows, since the random function always start from the same seed for different runs, when the row count is not changed, the data in table will always be the same, thus the query result could be predicted and verified.
void	testCaseSensitive()
void	testCaseSensitiveIncludedField()
void	TestCastINTCoveringPlan()
void	TestCastNoIndexPlan()
void	TestCastNonCoveringPlan()
void	testCastTimestampPlan()
void	TestCastVarchar_ConvertToRangePlan()
void	TestCastVarCharCoveringPlan()
void	TestCoveringPlanJoin_1()
void	TestCoveringPlanJoin_2()
void	TestCoveringPlanSortNotRemoved()
void	TestCoveringPlanSortPrefix_1()
void	TestCoveringPlanSortPrefix_2()
void	TestCoveringPlanSortPrefix_3()
void	TestCoveringPlanSortPrefix_4()
void	TestCoveringPlanSortPrefix_5()
void	TestCoveringPlanSortPrefix_6()
void	TestCoveringPlanSortPrefix_7()
void	TestCoveringPlanSortRemoved()
void	TestCoveringPlanSortRemovedWithSimpleFields()
void	testHangForSimpleDistinct()
void	testHashIndexNoRemovingSort()
void	testIncludedFieldCovering()
void	TestIndexScanWithDescOrderByNullsFirst()
void	TestIndexScanWithDescOrderByNullsLast()
void	testLimit0Pushdown()
void	testLimitPushdownCoveringPlan()
void	testLimitPushdownNonCoveringPlan()
void	testLimitPushdownOrderByCoveringPlan()
void	testLimitPushdownOrderByNonCoveringPlan()
void	TestLongerCastVarCharNoIndex()
void	testMultiPhaseAgg()
void	testNoFilterAndLimitOrderByCast()
void	testNoFilterAndLimitOrderByCoveringPlan()
void	testNoFilterGroupBy()
void	testNoFilterGroupByCast()
void	testNoFilterGroupByCoveringPlan()
void	testNoFilterGroupByHashIndex()
void	testNoFilterGroupByNoIndexMatch()
void	testNoFilterGroupBySimpleField()
void	testNoFilterGroupBySimpleFieldParallel()
void	testNoFilterOrderByCast()
void	testNoFilterOrderByCoveringPlan()
void	testNoFilterOrderByDesc()
void	testNoFilterOrderByHashIndex()
void	testNoFilterOrderByNoIndexMatch()
void	testNoFilterOrderBySimpleField()
void	TestNonCoveringPlanSortRemoved()
void	TestNonCoveringPlanWithNoRemoveSortOption()
void	TestNonCoveringRangePartition_1()
void	testNotConditionNoIndexPlan()
void	testRemovalOfReduntantHashToMergeExchange()
void	testRowkeyJoinPushdown_1()
void	testRowkeyJoinPushdown_10()
void	testRowkeyJoinPushdown_11()
void	testRowkeyJoinPushdown_12()
void	testRowkeyJoinPushdown_13()
void	testRowkeyJoinPushdown_2()
void	testRowkeyJoinPushdown_3()
void	testRowkeyJoinPushdown_4()
void	testRowkeyJoinPushdown_5()
void	testRowkeyJoinPushdown_6()
void	testRowkeyJoinPushdown_7()
void	testRowkeyJoinPushdown_8()
void	testRowkeyJoinPushdown_9()
void	testTrailingFieldIndexCovering()
void	testWithFilterGroupBy()

Methods inherited from class com.mapr.drill.maprdb.tests.json.BaseJsonTest

format, format, getTablePath, runHBaseSQLlWithResults, runSQLAndVerifyCount, setupDefaultTestCluster, tearDownAfterClass

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, 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

IndexPlanTest

public IndexPlanTest()

Method Detail

setupTableIndexes

public static void setupTableIndexes()
                              throws Exception

A sample row of this 10K table: ------------------+-----------------------------+--------+ | 1012 | {"city":"pfrrs","state":"pc"} | {"email":"KfFzKUZwNk@gmail.com","phone":"6500005471"} | {"ssn":"100007423"} | {"fname":"KfFzK","lname":"UZwNk"} | {"age":53.0,"income":45.0} | 1012 | This test suite generate random content to fill all the rows, since the random function always start from the same seed for different runs, when the row count is not changed, the data in table will always be the same, thus the query result could be predicted and verified.

Throws:

Exception

cleanupTableIndexes

public static void cleanupTableIndexes()
                                throws Exception

Throws:

Exception

CTASTestTable

public void CTASTestTable()
                   throws Exception

Throws:

Exception

CoveringPlanWithNonIndexedField

public void CoveringPlanWithNonIndexedField()
                                     throws Exception

Throws:

Exception

CoveringPlanWithOnlyIndexedField

public void CoveringPlanWithOnlyIndexedField()
                                      throws Exception

Throws:

Exception

NoIndexPlanForNonIndexField

public void NoIndexPlanForNonIndexField()
                                 throws Exception

Throws:

Exception

NonCoveringPlan

public void NonCoveringPlan()
                     throws Exception

Throws:

Exception

RangeConditionIndexPlan

public void RangeConditionIndexPlan()
                             throws Exception

Throws:

Exception

CoveringWithSimpleFieldsOnly

public void CoveringWithSimpleFieldsOnly()
                                  throws Exception

Throws:

Exception

NonCoveringWithSimpleFieldsOnly

public void NonCoveringWithSimpleFieldsOnly()
                                     throws Exception

Throws:

Exception

NonCoveringWithExtraConditonOnPrimary

public void NonCoveringWithExtraConditonOnPrimary()
                                           throws Exception

Throws:

Exception

Intersect2indexesPlan

public void Intersect2indexesPlan()
                           throws Exception

Throws:

Exception

CompositeIndexNonCoveringPlan

public void CompositeIndexNonCoveringPlan()
                                   throws Exception

Throws:

Exception

CompositeIndexNonCoveringFilterWithAllFieldsPlan

public void CompositeIndexNonCoveringFilterWithAllFieldsPlan()
                                                      throws Exception

Throws:

Exception

CompositeIndexCoveringPlan

public void CompositeIndexCoveringPlan()
                                throws Exception

Throws:

Exception

TestNonCoveringRangePartition_1

public void TestNonCoveringRangePartition_1()
                                     throws Exception

Throws:

Exception

TestCastVarCharCoveringPlan

public void TestCastVarCharCoveringPlan()
                                 throws Exception

Throws:

Exception

TestCastINTCoveringPlan

public void TestCastINTCoveringPlan()
                             throws Exception

Throws:

Exception

TestCastNonCoveringPlan

public void TestCastNonCoveringPlan()
                             throws Exception

Throws:

Exception

TestCastVarchar_ConvertToRangePlan

public void TestCastVarchar_ConvertToRangePlan()
                                        throws Exception

Throws:

Exception

TestCastNoIndexPlan

public void TestCastNoIndexPlan()
                         throws Exception

Throws:

Exception

TestLongerCastVarCharNoIndex

public void TestLongerCastVarCharNoIndex()
                                  throws Exception

Throws:

Exception

TestCoveringPlanSortRemoved

public void TestCoveringPlanSortRemoved()
                                 throws Exception

Throws:

Exception

TestCoveringPlanSortNotRemoved

public void TestCoveringPlanSortNotRemoved()
                                    throws Exception

Throws:

Exception

TestCoveringPlanSortRemovedWithSimpleFields

public void TestCoveringPlanSortRemovedWithSimpleFields()
                                                 throws Exception

Throws:

Exception

TestNonCoveringPlanSortRemoved

public void TestNonCoveringPlanSortRemoved()
                                    throws Exception

Throws:

Exception

TestNonCoveringPlanWithNoRemoveSortOption

public void TestNonCoveringPlanWithNoRemoveSortOption()
                                               throws Exception

Throws:

Exception

TestCoveringPlanJoin_1

public void TestCoveringPlanJoin_1()
                            throws Exception

Throws:

Exception

TestCoveringPlanJoin_2

public void TestCoveringPlanJoin_2()
                            throws Exception

Throws:

Exception

TestCoveringPlanSortPrefix_1

public void TestCoveringPlanSortPrefix_1()
                                  throws Exception

Throws:

Exception

TestCoveringPlanSortPrefix_2

public void TestCoveringPlanSortPrefix_2()
                                  throws Exception

Throws:

Exception

TestCoveringPlanSortPrefix_3

public void TestCoveringPlanSortPrefix_3()
                                  throws Exception

Throws:

Exception

TestCoveringPlanSortPrefix_4

public void TestCoveringPlanSortPrefix_4()
                                  throws Exception

Throws:

Exception

TestCoveringPlanSortPrefix_5

public void TestCoveringPlanSortPrefix_5()
                                  throws Exception

Throws:

Exception

TestCoveringPlanSortPrefix_6

public void TestCoveringPlanSortPrefix_6()
                                  throws Exception

Throws:

Exception

TestCoveringPlanSortPrefix_7

public void TestCoveringPlanSortPrefix_7()
                                  throws Exception

Throws:

Exception

orderByCastCoveringPlan

public void orderByCastCoveringPlan()
                             throws Exception

Throws:

Exception

orderByNonCoveringPlan

public void orderByNonCoveringPlan()
                            throws Exception

Throws:

Exception

orderByCastNonCoveringPlan

public void orderByCastNonCoveringPlan()
                                throws Exception

Throws:

Exception

NonCoveringPlan_SortPrefix_1

public void NonCoveringPlan_SortPrefix_1()
                                  throws Exception

Throws:

Exception

NonCoveringPlan_SortPrefix_2

public void NonCoveringPlan_SortPrefix_2()
                                  throws Exception

Throws:

Exception

nonIndexedColumnFilterCoveringPlan

public void nonIndexedColumnFilterCoveringPlan()
                                        throws Exception

Throws:

Exception

orderByLimitNonCoveringPlan

public void orderByLimitNonCoveringPlan()
                                 throws Exception

Throws:

Exception

orderByLimitCoveringPlan

public void orderByLimitCoveringPlan()
                              throws Exception

Throws:

Exception

pickAnyIndexWithFTSDisabledPlan

public void pickAnyIndexWithFTSDisabledPlan()
                                     throws Exception

Throws:

Exception

testCaseSensitive

public void testCaseSensitive()
                       throws Exception

Throws:

Exception

testCaseSensitiveIncludedField

public void testCaseSensitiveIncludedField()
                                    throws Exception

Throws:

Exception

testHashIndexNoRemovingSort

public void testHashIndexNoRemovingSort()
                                 throws Exception

Throws:

Exception

testCastTimestampPlan

public void testCastTimestampPlan()
                           throws Exception

Throws:

Exception

testNotConditionNoIndexPlan

public void testNotConditionNoIndexPlan()
                                 throws Exception

Throws:

Exception

testNoFilterOrderByCoveringPlan

public void testNoFilterOrderByCoveringPlan()
                                     throws Exception

Throws:

Exception

testNoFilterAndLimitOrderByCoveringPlan

public void testNoFilterAndLimitOrderByCoveringPlan()
                                             throws Exception

Throws:

Exception

testNoFilterOrderByCast

public void testNoFilterOrderByCast()
                             throws Exception

Throws:

Exception

testNoFilterAndLimitOrderByCast

public void testNoFilterAndLimitOrderByCast()
                                     throws Exception

Throws:

Exception

testNoFilterOrderByHashIndex

public void testNoFilterOrderByHashIndex()
                                  throws Exception

Throws:

Exception

testNoFilterOrderBySimpleField

public void testNoFilterOrderBySimpleField()
                                    throws Exception

Throws:

Exception

testNoFilterOrderByNoIndexMatch

public void testNoFilterOrderByNoIndexMatch()
                                     throws Exception

Throws:

Exception

IntersectPlanWithOneSideNoRows

public void IntersectPlanWithOneSideNoRows()
                                    throws Exception

Throws:

Exception

testTrailingFieldIndexCovering

public void testTrailingFieldIndexCovering()
                                    throws Exception

Throws:

Exception

testIncludedFieldCovering

public void testIncludedFieldCovering()
                               throws Exception

Throws:

Exception

testWithFilterGroupBy

public void testWithFilterGroupBy()
                           throws Exception

Throws:

Exception

testNoFilterOrderByDesc

public void testNoFilterOrderByDesc()
                             throws Exception

Throws:

Exception

testNoFilterGroupBy

public void testNoFilterGroupBy()
                         throws Exception

Throws:

Exception

testNoFilterGroupByCoveringPlan

public void testNoFilterGroupByCoveringPlan()
                                     throws Exception

Throws:

Exception

testNoFilterGroupByCast

public void testNoFilterGroupByCast()
                             throws Exception

Throws:

Exception

testNoFilterGroupByHashIndex

public void testNoFilterGroupByHashIndex()
                                  throws Exception

Throws:

Exception

testNoFilterGroupBySimpleField

public void testNoFilterGroupBySimpleField()
                                    throws Exception

Throws:

Exception

testNoFilterGroupByNoIndexMatch

public void testNoFilterGroupByNoIndexMatch()
                                     throws Exception

Throws:

Exception

testNoFilterGroupBySimpleFieldParallel

public void testNoFilterGroupBySimpleFieldParallel()
                                            throws Exception

Throws:

Exception

testLimitPushdownCoveringPlan

public void testLimitPushdownCoveringPlan()
                                   throws Exception

Throws:

Exception

testLimitPushdownOrderByCoveringPlan

public void testLimitPushdownOrderByCoveringPlan()
                                          throws Exception

Throws:

Exception

testLimitPushdownNonCoveringPlan

public void testLimitPushdownNonCoveringPlan()
                                      throws Exception

Throws:

Exception

testLimitPushdownOrderByNonCoveringPlan

public void testLimitPushdownOrderByNonCoveringPlan()
                                             throws Exception

Throws:

Exception

testLimit0Pushdown

public void testLimit0Pushdown()
                        throws Exception

Throws:

Exception

testRemovalOfReduntantHashToMergeExchange

public void testRemovalOfReduntantHashToMergeExchange()
                                               throws Exception

Throws:

Exception

testMultiPhaseAgg

public void testMultiPhaseAgg()
                       throws Exception

Throws:

Exception

testHangForSimpleDistinct

public void testHangForSimpleDistinct()
                               throws Exception

Throws:

Exception

testRowkeyJoinPushdown_1

public void testRowkeyJoinPushdown_1()
                              throws Exception

Throws:

Exception

testRowkeyJoinPushdown_2

public void testRowkeyJoinPushdown_2()
                              throws Exception

Throws:

Exception

testRowkeyJoinPushdown_3

public void testRowkeyJoinPushdown_3()
                              throws Exception

Throws:

Exception

testRowkeyJoinPushdown_4

public void testRowkeyJoinPushdown_4()
                              throws Exception

Throws:

Exception

testRowkeyJoinPushdown_5

public void testRowkeyJoinPushdown_5()
                              throws Exception

Throws:

Exception

testRowkeyJoinPushdown_6

public void testRowkeyJoinPushdown_6()
                              throws Exception

Throws:

Exception

testRowkeyJoinPushdown_7

public void testRowkeyJoinPushdown_7()
                              throws Exception

Throws:

Exception

testRowkeyJoinPushdown_8

public void testRowkeyJoinPushdown_8()
                              throws Exception

Throws:

Exception

testRowkeyJoinPushdown_9

public void testRowkeyJoinPushdown_9()
                              throws Exception

Throws:

Exception

testRowkeyJoinPushdown_10

public void testRowkeyJoinPushdown_10()
                               throws Exception

Throws:

Exception

testRowkeyJoinPushdown_11

public void testRowkeyJoinPushdown_11()
                               throws Exception

Throws:

Exception

testRowkeyJoinPushdown_12

public void testRowkeyJoinPushdown_12()
                               throws Exception

Throws:

Exception

testRowkeyJoinPushdown_13

public void testRowkeyJoinPushdown_13()
                               throws Exception

Throws:

Exception

TestIndexScanWithDescOrderByNullsFirst

public void TestIndexScanWithDescOrderByNullsFirst()
                                            throws Exception

Throws:

Exception

TestIndexScanWithDescOrderByNullsLast

public void TestIndexScanWithDescOrderByNullsLast()
                                           throws Exception

Throws:

Exception