org.apache.drill

Class TestExampleQueries

java.lang.Object

DrillTest

org.apache.drill.exec.ExecTest

org.apache.drill.test.BaseTestQuery

org.apache.drill.TestExampleQueries

public class TestExampleQueries
extends BaseTestQuery

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.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
TestExampleQueries()

Method Summary

Modifier and Type	Method and Description
void	createJsonWithEmptyList()
static void	setupTestFiles()
void	test2PhaseAggAfterOrderBy()
void	testAggExpressionWithGroupBy()
void	testAggExpressionWithGroupByHaving()
void	testCase()
void	testCaseInsensitiveJoin()
void	testCaseInsensitiveSubQuery()
void	testCaseReturnValueBigInt()
void	testCaseReturnValueVarChar()
void	testCastToVarcharWithLength()
void	testColumnNamesDifferInCaseOnly()
void	testColunValueCnt()
void	testCombineFilterWithNumericAndVarcharLiteral()
void	testComparisonWithSingleValueSubQuery()
void	testConcatOnNull()
void	testConcatOperator()
void	testCorrelatedExistsWithInSubq()
void	testCreateTableSameColumnNames()
void	testCTASOrderByCoumnNotInSelectClause()
void	testDateImplicitCasting()
void	testDistinctOverAggFunctionWithGroupBy()
void	testDRILL_3004()
void	testDRILL_811Json()
void	testDRILL_811View()
void	testDRILL_811ViewJoin()
void	testDrill428()
void	testEmptyCSVinDirectory()
void	testExchangeRemoveForJoinPlan()
void	testExplainLogical()
void	testExplainPhysical()
void	testFilterInSubqueryAndOutside()
void	testFilterOnArrayTypes()
void	testGbAndObDifferentExp()
void	testGroupBy()
void	testGroupByCaseInSubquery()
void	testGroupByStarSchemaless()
void	testGroupScanRowCount1()
void	testGroupScanRowCount2()
void	testGroupScanRowCountExp1()
void	testGroupScanRowCountExp2()
void	testHashPartitionSV2()
void	testHashPartitionSV4()
void	testHavingAggFunction()
void	testIdentifierMaxLength()
void	testImplicitDownwardCast()
void	testItemPushdownPastLeftOuterJoin()
void	testJoin()
void	testJoinCondWithDifferentTypes()
void	testJoinExpOn()
void	testJoinExpWhere()
void	testJoinMerge()
void	testLikeEscape()
void	testLimit0_1()
void	testLimit0SubqueryWithFilter()
void	testLimitInSubqAndOrderByOuter()
void	testMultipleComparisonWithSingleValueSubQuery()
void	testMultipleCountDistinctWithGroupBy()
void	testNegativeExtractOperator()
void	testNestedTypesPastJoinReportsValidResult()
void	testNestLoopJoinScalarSubQ()
void	testOrderbyArrayElement()
void	testOrderbyArrayElementInSubquery()
void	testOrderByDiffColumn()
void	testOrderByDiffColumnsInSubqAndOuter()
void	testParquetComplex()
void	testPartitionCTAS()
void	testPushExpInJoinConditionInnerJoin()
void	testPushExpInJoinConditionLeftJoin()
void	testPushExpInJoinConditionRightJoin()
void	testPushExpInJoinConditionWhere()
void	testQueryWithNullValues()
void	testRepeatedListProjectionPastJoin()
void	testSelectWithLimit()
void	testSelectWithLimit2()
void	testSimilar()
void	testSimilarEscape()
void	testSubQueryInProjectWithVarChar()
void	testSVRV4()
void	testSVRV4Join()
void	testSVRV4MultBatch()
void	testText()
void	testTextInClasspathStorage()
void	testTextJoin()
void	testTextPartitions()
void	testTextQueries()
void	testTopNWithSV2()
void	testViewFileName()
void	testWhere()
void	testWindowFunAndStarCol()

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

TestExampleQueries

public TestExampleQueries()

Method Detail

setupTestFiles

public static void setupTestFiles()

testConcatOnNull

public void testConcatOnNull()
                      throws Exception

Throws:

Exception

testConcatOperator

public void testConcatOperator()
                        throws Exception

Throws:

Exception

testViewFileName

public void testViewFileName()
                      throws Exception

Throws:

Exception

testTextInClasspathStorage

public void testTextInClasspathStorage()
                                throws Exception

Throws:

Exception

testParquetComplex

public void testParquetComplex()
                        throws Exception

Throws:

Exception

testQueryWithNullValues

public void testQueryWithNullValues()
                             throws Exception

Throws:

Exception

testJoinMerge

public void testJoinMerge()
                   throws Exception

Throws:

Exception

testJoinExpOn

public void testJoinExpOn()
                   throws Exception

Throws:

Exception

testJoinExpWhere

public void testJoinExpWhere()
                      throws Exception

Throws:

Exception

testPushExpInJoinConditionInnerJoin

public void testPushExpInJoinConditionInnerJoin()
                                         throws Exception

Throws:

Exception

testPushExpInJoinConditionWhere

public void testPushExpInJoinConditionWhere()
                                     throws Exception

Throws:

Exception

testPushExpInJoinConditionLeftJoin

public void testPushExpInJoinConditionLeftJoin()
                                        throws Exception

Throws:

Exception

testPushExpInJoinConditionRightJoin

public void testPushExpInJoinConditionRightJoin()
                                         throws Exception

Throws:

Exception

testCaseReturnValueVarChar

public void testCaseReturnValueVarChar()
                                throws Exception

Throws:

Exception

testCaseReturnValueBigInt

public void testCaseReturnValueBigInt()
                               throws Exception

Throws:

Exception

testHashPartitionSV2

public void testHashPartitionSV2()
                          throws Exception

Throws:

Exception

testHashPartitionSV4

public void testHashPartitionSV4()
                          throws Exception

Throws:

Exception

testSelectWithLimit

public void testSelectWithLimit()
                         throws Exception

Throws:

Exception

testSelectWithLimit2

public void testSelectWithLimit2()
                          throws Exception

Throws:

Exception

testSVRV4

public void testSVRV4()
               throws Exception

Throws:

Exception

testSVRV4MultBatch

public void testSVRV4MultBatch()
                        throws Exception

Throws:

Exception

testSVRV4Join

public void testSVRV4Join()
                   throws Exception

Throws:

Exception

testText

public void testText()
              throws Exception

Throws:

Exception

testFilterOnArrayTypes

public void testFilterOnArrayTypes()
                            throws Exception

Throws:

Exception

testTextPartitions

public void testTextPartitions()
                        throws Exception

Throws:

Exception

testJoin

public void testJoin()
              throws Exception

Throws:

Exception

testWhere

public void testWhere()
               throws Exception

Throws:

Exception

testGroupBy

public void testGroupBy()
                 throws Exception

Throws:

Exception

testExplainPhysical

public void testExplainPhysical()
                         throws Exception

Throws:

Exception

testExplainLogical

public void testExplainLogical()
                        throws Exception

Throws:

Exception

testGroupScanRowCountExp1

public void testGroupScanRowCountExp1()
                               throws Exception

Throws:

Exception

testGroupScanRowCount1

public void testGroupScanRowCount1()
                            throws Exception

Throws:

Exception

testColunValueCnt

public void testColunValueCnt()
                       throws Exception

Throws:

Exception

testGroupScanRowCountExp2

public void testGroupScanRowCountExp2()
                               throws Exception

Throws:

Exception

testGroupScanRowCount2

public void testGroupScanRowCount2()
                            throws Exception

Throws:

Exception

testDrill428

public void testDrill428()
                  throws Exception

Throws:

Exception

testOrderByDiffColumn

public void testOrderByDiffColumn()
                           throws Exception

Throws:

Exception

testLimit0_1

public void testLimit0_1()
                  throws Exception

Throws:

Exception

testTextJoin

public void testTextJoin()
                  throws Exception

Throws:

Exception

testDRILL_811View

public void testDRILL_811View()
                       throws Exception

Throws:

Exception

testDRILL_811ViewJoin

public void testDRILL_811ViewJoin()
                           throws Exception

Throws:

Exception

testDRILL_811Json

public void testDRILL_811Json()
                       throws Exception

Throws:

Exception

testCase

public void testCase()
              throws Exception

Throws:

Exception

testJoinCondWithDifferentTypes

public void testJoinCondWithDifferentTypes()
                                    throws Exception

Throws:

Exception

testTopNWithSV2

public void testTopNWithSV2()
                     throws Exception

Throws:

Exception

testTextQueries

public void testTextQueries()
                     throws Exception

Throws:

Exception

testLikeEscape

public void testLikeEscape()
                    throws Exception

Throws:

Exception

testSimilarEscape

public void testSimilarEscape()
                       throws Exception

Throws:

Exception

testImplicitDownwardCast

public void testImplicitDownwardCast()
                              throws Exception

Throws:

Exception

testCastToVarcharWithLength

public void testCastToVarcharWithLength()
                                 throws Exception

Throws:

Exception

testIdentifierMaxLength

public void testIdentifierMaxLength()
                             throws Exception

Throws:

Exception

testOrderByDiffColumnsInSubqAndOuter

public void testOrderByDiffColumnsInSubqAndOuter()
                                          throws Exception

Throws:

Exception

testLimitInSubqAndOrderByOuter

public void testLimitInSubqAndOrderByOuter()
                                    throws Exception

Throws:

Exception

testCaseInsensitiveJoin

public void testCaseInsensitiveJoin()
                             throws Exception

Throws:

Exception

test2PhaseAggAfterOrderBy

public void test2PhaseAggAfterOrderBy()
                               throws Exception

Throws:

Exception

testCaseInsensitiveSubQuery

public void testCaseInsensitiveSubQuery()
                                 throws Exception

Throws:

Exception

testMultipleCountDistinctWithGroupBy

public void testMultipleCountDistinctWithGroupBy()
                                          throws Exception

Throws:

Exception

testFilterInSubqueryAndOutside

public void testFilterInSubqueryAndOutside()
                                    throws Exception

Throws:

Exception

testLimit0SubqueryWithFilter

public void testLimit0SubqueryWithFilter()
                                  throws Exception

Throws:

Exception

testAggExpressionWithGroupBy

public void testAggExpressionWithGroupBy()
                                  throws Exception

Throws:

Exception

testAggExpressionWithGroupByHaving

public void testAggExpressionWithGroupByHaving()
                                        throws Exception

Throws:

Exception

testExchangeRemoveForJoinPlan

public void testExchangeRemoveForJoinPlan()
                                   throws Exception

Throws:

Exception

testNestedTypesPastJoinReportsValidResult

public void testNestedTypesPastJoinReportsValidResult()
                                               throws Exception

Throws:

Exception

testSimilar

public void testSimilar()
                 throws Exception

Throws:

Exception

testCreateTableSameColumnNames

public void testCreateTableSameColumnNames()
                                    throws Exception

Throws:

Exception

testColumnNamesDifferInCaseOnly

public void testColumnNamesDifferInCaseOnly()
                                     throws Exception

Throws:

Exception

testOrderbyArrayElement

public void testOrderbyArrayElement()
                             throws Exception

Throws:

Exception

testCorrelatedExistsWithInSubq

public void testCorrelatedExistsWithInSubq()
                                    throws Exception

Throws:

Exception

testOrderbyArrayElementInSubquery

public void testOrderbyArrayElementInSubquery()
                                       throws Exception

Throws:

Exception

testCTASOrderByCoumnNotInSelectClause

public void testCTASOrderByCoumnNotInSelectClause()
                                           throws Exception

Throws:

Exception

createJsonWithEmptyList

public void createJsonWithEmptyList()
                             throws Exception

Throws:

Exception

testGroupByStarSchemaless

public void testGroupByStarSchemaless()
                               throws Exception

Throws:

Exception

testGroupByCaseInSubquery

public void testGroupByCaseInSubquery()
                               throws Exception

Throws:

Exception

testHavingAggFunction

public void testHavingAggFunction()
                           throws Exception

Throws:

Exception

testNestLoopJoinScalarSubQ

public void testNestLoopJoinScalarSubQ()
                                throws Exception

Throws:

Exception

testGbAndObDifferentExp

public void testGbAndObDifferentExp()
                             throws Exception

Throws:

Exception

testDRILL_3004

public void testDRILL_3004()
                    throws Exception

Throws:

Exception

testRepeatedListProjectionPastJoin

public void testRepeatedListProjectionPastJoin()
                                        throws Exception

Throws:

Exception

testPartitionCTAS

public void testPartitionCTAS()
                       throws Exception

Throws:

Exception

testWindowFunAndStarCol

public void testWindowFunAndStarCol()
                             throws Exception

Throws:

Exception

testEmptyCSVinDirectory

public void testEmptyCSVinDirectory()
                             throws Exception

Throws:

Exception

testNegativeExtractOperator

public void testNegativeExtractOperator()
                                 throws Exception

Throws:

Exception

testDistinctOverAggFunctionWithGroupBy

public void testDistinctOverAggFunctionWithGroupBy()
                                            throws Exception

Throws:

Exception

testDateImplicitCasting

public void testDateImplicitCasting()
                             throws Exception

Throws:

Exception

testComparisonWithSingleValueSubQuery

public void testComparisonWithSingleValueSubQuery()
                                           throws Exception

Throws:

Exception

testMultipleComparisonWithSingleValueSubQuery

public void testMultipleComparisonWithSingleValueSubQuery()
                                                   throws Exception

Throws:

Exception

testSubQueryInProjectWithVarChar

public void testSubQueryInProjectWithVarChar()
                                      throws Exception

Throws:

Exception

testItemPushdownPastLeftOuterJoin

public void testItemPushdownPastLeftOuterJoin()
                                       throws Exception

Throws:

Exception

testCombineFilterWithNumericAndVarcharLiteral

public void testCombineFilterWithNumericAndVarcharLiteral()
                                                   throws Exception

Throws:

Exception