org.apache.drill.exec.sql

Class TestInfoSchema

java.lang.Object

DrillTest

org.apache.drill.exec.ExecTest

org.apache.drill.test.BaseTestQuery

org.apache.drill.exec.sql.TestInfoSchema

public class TestInfoSchema
extends BaseTestQuery

Contains tests for -- InformationSchema -- Queries on InformationSchema such as SHOW TABLES, SHOW SCHEMAS or DESCRIBE table -- USE schema

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

Method Summary

Modifier and Type	Method and Description
void	catalogs()
void	completeSchemaRef1()
void	defaultSchemaClasspath()
void	defaultSchemaDfs()
void	describePartialSchema()
void	describeSchemaInvalid()
void	describeSchemaOutput()
void	describeSchemaSyntax()
void	describeTable()
void	describeTableWithColQualifier()
void	describeTableWithColumnName()
void	describeTableWithColumnNameAndTableKeyword()
void	describeTableWithSchema()
void	describeTableWithSchemaAndColQualifier()
void	describeTableWithSchemaAndColumnName()
void	describeTableWithSchemaAndColumnNameAndTableKeyword()
void	describeTableWithSchemaAndTableKeyword()
void	describeTableWithTableKeyword()
void	describeWhenSameTableNameExistsInMultipleSchemas()
void	describeWhenSameTableNameExistsInMultipleSchemasWithTableKeyword()
void	queryFromNonDefaultSchema()
void	selectFromAllTables()
static void	setupFiles()
void	showDatabases()
void	showDatabasesLike()
void	showDatabasesWhere()
void	showDatabasesWhereIn()
void	showTablesFromDb()
void	showTablesFromDbWhere()
void	showTablesLike()
void	testDescribeAlias()
void	testSerDe()
void	useSchema()
void	useSchemaNegative()
void	useSubSchemaWithinSchema()

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

TestInfoSchema

public TestInfoSchema()

Method Detail

setupFiles

public static void setupFiles()

selectFromAllTables

public void selectFromAllTables()
                         throws Exception

Throws:

Exception

catalogs

public void catalogs()
              throws Exception

Throws:

Exception

showTablesFromDb

public void showTablesFromDb()
                      throws Exception

Throws:

Exception

showTablesFromDbWhere

public void showTablesFromDbWhere()
                           throws Exception

Throws:

Exception

showTablesLike

public void showTablesLike()
                    throws Exception

Throws:

Exception

showDatabases

public void showDatabases()
                   throws Exception

Throws:

Exception

showDatabasesWhere

public void showDatabasesWhere()
                        throws Exception

Throws:

Exception

showDatabasesWhereIn

public void showDatabasesWhereIn()
                          throws Exception

Throws:

Exception

showDatabasesLike

public void showDatabasesLike()
                       throws Exception

Throws:

Exception

describeTable

public void describeTable()
                   throws Exception

Throws:

Exception

describeTableWithTableKeyword

public void describeTableWithTableKeyword()
                                   throws Exception

Throws:

Exception

describeTableWithSchema

public void describeTableWithSchema()
                             throws Exception

Throws:

Exception

describeTableWithSchemaAndTableKeyword

public void describeTableWithSchemaAndTableKeyword()
                                            throws Exception

Throws:

Exception

describeWhenSameTableNameExistsInMultipleSchemas

public void describeWhenSameTableNameExistsInMultipleSchemas()
                                                      throws Exception

Throws:

Exception

describeWhenSameTableNameExistsInMultipleSchemasWithTableKeyword

public void describeWhenSameTableNameExistsInMultipleSchemasWithTableKeyword()
                                                                      throws Exception

Throws:

Exception

describeTableWithColumnName

public void describeTableWithColumnName()
                                 throws Exception

Throws:

Exception

describeTableWithColumnNameAndTableKeyword

public void describeTableWithColumnNameAndTableKeyword()
                                                throws Exception

Throws:

Exception

describeTableWithSchemaAndColumnName

public void describeTableWithSchemaAndColumnName()
                                          throws Exception

Throws:

Exception

describeTableWithSchemaAndColumnNameAndTableKeyword

public void describeTableWithSchemaAndColumnNameAndTableKeyword()
                                                         throws Exception

Throws:

Exception

describeTableWithColQualifier

public void describeTableWithColQualifier()
                                   throws Exception

Throws:

Exception

describeTableWithSchemaAndColQualifier

public void describeTableWithSchemaAndColQualifier()
                                            throws Exception

Throws:

Exception

defaultSchemaDfs

public void defaultSchemaDfs()
                      throws Exception

Throws:

Exception

defaultSchemaClasspath

public void defaultSchemaClasspath()
                            throws Exception

Throws:

Exception

queryFromNonDefaultSchema

public void queryFromNonDefaultSchema()
                               throws Exception

Throws:

Exception

useSchema

public void useSchema()
               throws Exception

Throws:

Exception

useSubSchemaWithinSchema

public void useSubSchemaWithinSchema()
                              throws Exception

Throws:

Exception

useSchemaNegative

public void useSchemaNegative()
                       throws Exception

Throws:

Exception

completeSchemaRef1

public void completeSchemaRef1()
                        throws Exception

Throws:

Exception

describeSchemaSyntax

public void describeSchemaSyntax()
                          throws Exception

Throws:

Exception

describePartialSchema

public void describePartialSchema()
                           throws Exception

Throws:

Exception

describeSchemaOutput

public void describeSchemaOutput()
                          throws Exception

Throws:

Exception

describeSchemaInvalid

public void describeSchemaInvalid()
                           throws Exception

Throws:

Exception

testDescribeAlias

public void testDescribeAlias()
                       throws Exception

Throws:

Exception

testSerDe

public void testSerDe()
               throws Exception

Throws:

Exception