org.apache.drill.exec.sql

Class TestViewSupport

java.lang.Object

DrillTest

org.apache.drill.exec.ExecTest

org.apache.drill.test.BaseTestQuery

org.apache.drill.PlanTestBase

org.apache.drill.exec.sql.TestBaseViewSupport

org.apache.drill.exec.sql.TestViewSupport

public class TestViewSupport
extends TestBaseViewSupport

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

Method Summary

Modifier and Type	Method and Description
void	createViewIfNotExistsWhenTableAlreadyExists()
void	createViewIfNotExistsWhenViewAlreadyExists()
void	createViewWhenATableWithSameNameAlreadyExists()
void	createViewWhenInEqualColumnCountInViewDefVsInViewQuery()
void	createViewWhenViewAlreadyExists()
void	createViewWhenViewQueryColumnHasStarAndViewFiledListIsSpecified()
void	createViewWithBothOrReplaceAndIfNotExists()
void	createViewWithDuplicateColumnsInDef1()
void	createViewWithDuplicateColumnsInDef2()
void	createViewWithDuplicateColumnsInDef3()
void	createViewWithDuplicateColumnsInDef4()
void	createViewWithDuplicateColumnsInDef5()
void	createViewWithDuplicateColumnsInDef6()
void	createViewWithUniqueColsInFieldListDuplicateColsInQuery1()
void	createViewWithUniqueColsInFieldListDuplicateColsInQuery2()
void	dropViewIfExistsWhenItIsATable()
void	dropViewIfExistsWhenViewDoesNotExist()
void	dropViewIfExistsWhenViewExists()
void	infoSchemaWithView()
void	nullabilityPropertyInViewPersistence() DRILL-2342 This test is for case where output columns are nullable.
void	referToSchemaInsideAndOutsideView()
void	selectFromViewCreatedOnCalcite1_4()
static void	setupTestFiles()
void	showProperMsgWhenDroppingNonExistentView()
void	showProperMsgWhenTryingToDropANonViewTable()
void	showProperMsgWhenTryingToDropAViewInImmutableSchema()
void	testCreateViewIfNotExists()
void	testDropViewNameStartsWithSlash()
void	testMapColumnOfOlderViewWithUntypedMap()
void	testMapTypeTreatedAsAnyInNewlyCreatedView()
void	testMapTypeTreatedAsAnyInOlderViewWithUntypedMap()
void	testSelectMapColumnOfNewlyCreatedView()
void	testViewContainingWithClauseAndUnionAllInDefinition()
void	testViewIsCreatedWithinWorkspace()
void	testViewIsFoundWithinWorkspaceWhenNameStartsWithSlash()
void	viewCreatedFromAnotherView()
void	viewResolvingTablesInWorkspaceSchema()
void	viewSchemaWhenSelectFieldsInDef_SelectFieldsInView()
void	viewWithCompoundIdentifiersInDef()
void	viewWithPartialSchemaIdentifier()
void	viewWithSelectFieldsInDef_SelectFieldsInQuery1()
void	viewWithSelectFieldsInDef_SelectFieldsInQuery2()
void	viewWithSelectFieldsInDef_SelectFieldsInView_SelectFieldsInQuery1()
void	viewWithSelectFieldsInDef_SelectFieldsInView_SelectFieldsInQuery2()
void	viewWithSelectFieldsInDef_SelectFieldsInView_StarInQuery()
void	viewWithSelectFieldsInDef_StarInQuery()
void	viewWithStarInDef_SelectFieldsInQuery()
void	viewWithStarInDef_StarInQuery()
void	viewWithUnionWithSelectFieldsInDef_StarInQuery()

Methods inherited from class org.apache.drill.exec.sql.TestBaseViewSupport

baselineColumns, baselineRows, createViewHelper, dropViewHelper, dropViewIfExistsHelper, generateViewName, queryViewHelper, row, testViewHelper

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

TestViewSupport

public TestViewSupport()

Method Detail

setupTestFiles

public static void setupTestFiles()

referToSchemaInsideAndOutsideView

public void referToSchemaInsideAndOutsideView()
                                       throws Exception

Throws:

Exception

nullabilityPropertyInViewPersistence

public void nullabilityPropertyInViewPersistence()
                                          throws Exception

DRILL-2342 This test is for case where output columns are nullable. Existing tests already cover the case where columns are required.

Throws:

Exception

viewWithStarInDef_StarInQuery

public void viewWithStarInDef_StarInQuery()
                                   throws Exception

Throws:

Exception

viewWithSelectFieldsInDef_StarInQuery

public void viewWithSelectFieldsInDef_StarInQuery()
                                           throws Exception

Throws:

Exception

viewWithSelectFieldsInDef_SelectFieldsInView_StarInQuery

public void viewWithSelectFieldsInDef_SelectFieldsInView_StarInQuery()
                                                              throws Exception

Throws:

Exception

viewWithStarInDef_SelectFieldsInQuery

public void viewWithStarInDef_SelectFieldsInQuery()
                                           throws Exception

Throws:

Exception

viewWithSelectFieldsInDef_SelectFieldsInQuery1

public void viewWithSelectFieldsInDef_SelectFieldsInQuery1()
                                                    throws Exception

Throws:

Exception

viewWithSelectFieldsInDef_SelectFieldsInQuery2

public void viewWithSelectFieldsInDef_SelectFieldsInQuery2()
                                                    throws Exception

Throws:

Exception

viewWithSelectFieldsInDef_SelectFieldsInView_SelectFieldsInQuery1

public void viewWithSelectFieldsInDef_SelectFieldsInView_SelectFieldsInQuery1()
                                                                       throws Exception

Throws:

Exception

viewWithSelectFieldsInDef_SelectFieldsInView_SelectFieldsInQuery2

public void viewWithSelectFieldsInDef_SelectFieldsInView_SelectFieldsInQuery2()
                                                                       throws Exception

Throws:

Exception

viewWithUnionWithSelectFieldsInDef_StarInQuery

public void viewWithUnionWithSelectFieldsInDef_StarInQuery()
                                                    throws Exception

Throws:

Exception

viewCreatedFromAnotherView

public void viewCreatedFromAnotherView()
                                throws Exception

Throws:

Exception

viewWithCompoundIdentifiersInDef

public void viewWithCompoundIdentifiersInDef()
                                      throws Exception

Throws:

Exception

createViewWhenViewAlreadyExists

public void createViewWhenViewAlreadyExists()
                                     throws Exception

Throws:

Exception

createViewIfNotExistsWhenTableAlreadyExists

public void createViewIfNotExistsWhenTableAlreadyExists()
                                                 throws Exception

Throws:

Exception

createViewIfNotExistsWhenViewAlreadyExists

public void createViewIfNotExistsWhenViewAlreadyExists()
                                                throws Exception

Throws:

Exception

testCreateViewIfNotExists

public void testCreateViewIfNotExists()
                               throws Exception

Throws:

Exception

createViewWithBothOrReplaceAndIfNotExists

public void createViewWithBothOrReplaceAndIfNotExists()
                                               throws Exception

Throws:

Exception

createViewWhenATableWithSameNameAlreadyExists

public void createViewWhenATableWithSameNameAlreadyExists()
                                                   throws Exception

Throws:

Exception

infoSchemaWithView

public void infoSchemaWithView()
                        throws Exception

Throws:

Exception

viewWithPartialSchemaIdentifier

public void viewWithPartialSchemaIdentifier()
                                     throws Exception

Throws:

Exception

viewResolvingTablesInWorkspaceSchema

public void viewResolvingTablesInWorkspaceSchema()
                                          throws Exception

Throws:

Exception

viewSchemaWhenSelectFieldsInDef_SelectFieldsInView

public void viewSchemaWhenSelectFieldsInDef_SelectFieldsInView()
                                                        throws Exception

Throws:

Exception

createViewWithDuplicateColumnsInDef1

public void createViewWithDuplicateColumnsInDef1()
                                          throws Exception

Throws:

Exception

createViewWithDuplicateColumnsInDef2

public void createViewWithDuplicateColumnsInDef2()
                                          throws Exception

Throws:

Exception

createViewWithDuplicateColumnsInDef3

public void createViewWithDuplicateColumnsInDef3()
                                          throws Exception

Throws:

Exception

createViewWithDuplicateColumnsInDef4

public void createViewWithDuplicateColumnsInDef4()
                                          throws Exception

Throws:

Exception

createViewWithDuplicateColumnsInDef5

public void createViewWithDuplicateColumnsInDef5()
                                          throws Exception

Throws:

Exception

createViewWithDuplicateColumnsInDef6

public void createViewWithDuplicateColumnsInDef6()
                                          throws Exception

Throws:

Exception

createViewWithUniqueColsInFieldListDuplicateColsInQuery1

public void createViewWithUniqueColsInFieldListDuplicateColsInQuery1()
                                                              throws Exception

Throws:

Exception

createViewWithUniqueColsInFieldListDuplicateColsInQuery2

public void createViewWithUniqueColsInFieldListDuplicateColsInQuery2()
                                                              throws Exception

Throws:

Exception

createViewWhenInEqualColumnCountInViewDefVsInViewQuery

public void createViewWhenInEqualColumnCountInViewDefVsInViewQuery()
                                                            throws Exception

Throws:

Exception

createViewWhenViewQueryColumnHasStarAndViewFiledListIsSpecified

public void createViewWhenViewQueryColumnHasStarAndViewFiledListIsSpecified()
                                                                     throws Exception

Throws:

Exception

showProperMsgWhenDroppingNonExistentView

public void showProperMsgWhenDroppingNonExistentView()
                                              throws Exception

Throws:

Exception

showProperMsgWhenTryingToDropAViewInImmutableSchema

public void showProperMsgWhenTryingToDropAViewInImmutableSchema()
                                                         throws Exception

Throws:

Exception

showProperMsgWhenTryingToDropANonViewTable

public void showProperMsgWhenTryingToDropANonViewTable()
                                                throws Exception

Throws:

Exception

dropViewIfExistsWhenViewExists

public void dropViewIfExistsWhenViewExists()
                                    throws Exception

Throws:

Exception

dropViewIfExistsWhenViewDoesNotExist

public void dropViewIfExistsWhenViewDoesNotExist()
                                          throws Exception

Throws:

Exception

dropViewIfExistsWhenItIsATable

public void dropViewIfExistsWhenItIsATable()
                                    throws Exception

Throws:

Exception

selectFromViewCreatedOnCalcite1_4

public void selectFromViewCreatedOnCalcite1_4()
                                       throws Exception

Throws:

Exception

testDropViewNameStartsWithSlash

public void testDropViewNameStartsWithSlash()
                                     throws Exception

Throws:

Exception

testViewIsCreatedWithinWorkspace

public void testViewIsCreatedWithinWorkspace()
                                      throws Exception

Throws:

Exception

testViewIsFoundWithinWorkspaceWhenNameStartsWithSlash

public void testViewIsFoundWithinWorkspaceWhenNameStartsWithSlash()
                                                           throws Exception

Throws:

Exception

testSelectMapColumnOfNewlyCreatedView

public void testSelectMapColumnOfNewlyCreatedView()
                                           throws Exception

Throws:

Exception

testMapTypeTreatedAsAnyInNewlyCreatedView

public void testMapTypeTreatedAsAnyInNewlyCreatedView()
                                               throws Exception

Throws:

Exception

testMapColumnOfOlderViewWithUntypedMap

public void testMapColumnOfOlderViewWithUntypedMap()
                                            throws Exception

Throws:

Exception

testMapTypeTreatedAsAnyInOlderViewWithUntypedMap

public void testMapTypeTreatedAsAnyInOlderViewWithUntypedMap()
                                                      throws Exception

Throws:

Exception

testViewContainingWithClauseAndUnionAllInDefinition

public void testViewContainingWithClauseAndUnionAllInDefinition()
                                                         throws Exception

Throws:

Exception