org.apache.drill.exec

Class TestWindowFunctions

java.lang.Object

DrillTest

org.apache.drill.exec.ExecTest

org.apache.drill.test.BaseTestQuery

org.apache.drill.exec.TestWindowFunctions

public class TestWindowFunctions
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
TestWindowFunctions()

Method Summary

Modifier and Type	Method and Description
static void	setupTestFiles()
void	testAvgVarianceWindowFunctions()
void	testCompoundIdentifierInWindowDefinition()
void	testConstantsInMultiplePartitions()
void	testCountEmptyPartitionByWithExchange()
void	testExpressionInWindowFunction()
void	testLeadMissingOver()
void	testMissingOverWithConstant()
void	testMissingOverWithWindowClause()
void	testMultiplePartitions1()
void	testMultiplePartitions2()
void	testNestedAggregates()
void	testNestedAggregates1()
void	testProjectPushPastWindow()
void	testRankWithGroupBy()
void	testSinglePartition()
void	testSinglePartitionDefinedInWindowList()
void	testStatisticalWindowFunctions()
void	testWindowConstants()
void	testWindowFrame()
void	testWindowFrameEquivalentToDefault()
void	testWindowFunctionWithDistinct()
void	testWindowFunctionWithKnownType()
void	testWindowFunInNestSubQ()
void	testWindowGroupBy()
void	testWindowGroupByOnView()
void	testWindowInWindow()
void	testWindowOnSubqueryWithStar()
void	testWindowSumAggIsNotNull()
void	testWindowWithAlias()
void	testWindowWithAllowDisallow()
void	testWindowWithJoin()
void	testWithAndWithoutPartitions()

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

TestWindowFunctions

public TestWindowFunctions()

Method Detail

setupTestFiles

public static void setupTestFiles()

testSinglePartition

public void testSinglePartition()
                         throws Exception

Throws:

Exception

testSinglePartitionDefinedInWindowList

public void testSinglePartitionDefinedInWindowList()
                                            throws Exception

Throws:

Exception

testWindowFunctionWithDistinct

public void testWindowFunctionWithDistinct()
                                    throws Exception

Throws:

Exception

testWindowFrame

public void testWindowFrame()
                     throws Exception

Throws:

Exception

testWindowWithAlias

public void testWindowWithAlias()
                         throws Exception

Throws:

Exception

testWindowWithAllowDisallow

public void testWindowWithAllowDisallow()
                                 throws Exception

Throws:

Exception

testWindowInWindow

public void testWindowInWindow()
                        throws Exception

Throws:

Exception

testMissingOverWithWindowClause

public void testMissingOverWithWindowClause()
                                     throws Exception

Throws:

Exception

testLeadMissingOver

public void testLeadMissingOver()
                         throws Exception

Throws:

Exception

testMissingOverWithConstant

public void testMissingOverWithConstant()
                                 throws Exception

Throws:

Exception

testWindowGroupBy

public void testWindowGroupBy()
                       throws Exception

Throws:

Exception

testWindowGroupByOnView

public void testWindowGroupByOnView()
                             throws Exception

Throws:

Exception

testWindowFrameEquivalentToDefault

public void testWindowFrameEquivalentToDefault()
                                        throws Exception

Throws:

Exception

testWindowWithJoin

public void testWindowWithJoin()
                        throws Exception

Throws:

Exception

testCountEmptyPartitionByWithExchange

public void testCountEmptyPartitionByWithExchange()
                                           throws Exception

Throws:

Exception

testAvgVarianceWindowFunctions

public void testAvgVarianceWindowFunctions()
                                    throws Exception

Throws:

Exception

testWindowFunctionWithKnownType

public void testWindowFunctionWithKnownType()
                                     throws Exception

Throws:

Exception

testCompoundIdentifierInWindowDefinition

public void testCompoundIdentifierInWindowDefinition()
                                              throws Exception

Throws:

Exception

testRankWithGroupBy

public void testRankWithGroupBy()
                         throws Exception

Throws:

Exception

testWindowSumAggIsNotNull

public void testWindowSumAggIsNotNull()
                               throws Exception

Throws:

Exception

testWindowConstants

public void testWindowConstants()
                         throws Exception

Throws:

Exception

testMultiplePartitions1

public void testMultiplePartitions1()
                             throws Exception

Throws:

Exception

testMultiplePartitions2

public void testMultiplePartitions2()
                             throws Exception

Throws:

Exception

testWithAndWithoutPartitions

public void testWithAndWithoutPartitions()
                                  throws Exception

Throws:

Exception

testConstantsInMultiplePartitions

public void testConstantsInMultiplePartitions()
                                       throws Exception

Throws:

Exception

testExpressionInWindowFunction

public void testExpressionInWindowFunction()
                                    throws Exception

Throws:

Exception

testProjectPushPastWindow

public void testProjectPushPastWindow()
                               throws Exception

Throws:

Exception

testWindowFunInNestSubQ

public void testWindowFunInNestSubQ()
                             throws Exception

Throws:

Exception

testStatisticalWindowFunctions

public void testStatisticalWindowFunctions()
                                    throws Exception

Throws:

Exception

testNestedAggregates

public void testNestedAggregates()
                          throws Exception

Throws:

Exception

testNestedAggregates1

public void testNestedAggregates1()
                           throws Exception

Throws:

Exception

testWindowOnSubqueryWithStar

public void testWindowOnSubqueryWithStar()
                                  throws Exception

Throws:

Exception