org.apache.drill.exec.store.excel

Class TestExcelFormat

java.lang.Object

org.apache.drill.test.BaseTest

org.apache.drill.test.DrillTest

org.apache.drill.test.ClusterTest

org.apache.drill.exec.store.excel.TestExcelFormat

public class TestExcelFormat
extends ClusterTest

Nested Class Summary

Nested classes/interfaces inherited from class org.apache.drill.test.DrillTest

DrillTest.MemWatcher

Field Summary

Fields inherited from class org.apache.drill.test.ClusterTest

client, cluster, dirTestWatcher

Fields inherited from class org.apache.drill.test.DrillTest

logOutcome, objectMapper, REPEAT_RULE, thrownException, TIMEOUT

Constructor Summary

Constructors

Constructor and Description
TestExcelFormat()

Method Summary

Modifier and Type	Method and Description
static void	setup()
void	testBlankColumnFix()
void	testBlankRowsInFileQuery()
void	testDefineColumnsQuery()
void	testEmptySheetQuery() This tests to what happens if you attempt to query a completely empty sheet The result should be an empty data set.
void	testExplicitAllQuery()
void	testExplicitMetadataQuery()
void	testExplicitNoFieldNamesQuery()
void	testExplicitNonDefaultSheetQuery()
void	testExplicitSomeQuery()
void	testExplicitSomeQueryWithCompressedFile()
void	testFileWithDoubleDates()
void	testGetSheetNames()
void	testInconsistentDataQuery()
void	testInvalidSheetQuery() This test verifies that when a user attempts to open a sheet that doesn't exist, the plugin will throw an error
void	testLastRowQuery()
void	testLimitPushdown()
void	testMissingDataQuery()
void	testNonDefaultSheetQuery()
void	testNumericFormula()
void	testSerDe()
void	testStarNoFieldNamesQuery()
void	testStarQuery()
void	testTextFormula()

Methods inherited from class org.apache.drill.test.ClusterTest

getFile, queryBuilder, run, runAndLog, runAndPrint, runAndPrint, shutdown, startCluster, testBuilder

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

TestExcelFormat

public TestExcelFormat()

Method Detail

setup

public static void setup()
                  throws Exception

Throws:

Exception

testStarQuery

public void testStarQuery()
                   throws Exception

Throws:

Exception

testExplicitAllQuery

public void testExplicitAllQuery()
                          throws RpcException

Throws:

RpcException

testExplicitMetadataQuery

public void testExplicitMetadataQuery()
                               throws RpcException

Throws:

RpcException

testExplicitSomeQuery

public void testExplicitSomeQuery()
                           throws RpcException

Throws:

RpcException

testNonDefaultSheetQuery

public void testNonDefaultSheetQuery()
                              throws RpcException

Throws:

RpcException

testExplicitNonDefaultSheetQuery

public void testExplicitNonDefaultSheetQuery()
                                      throws RpcException

Throws:

RpcException

testInvalidSheetQuery

public void testInvalidSheetQuery()
                           throws Exception

This test verifies that when a user attempts to open a sheet that doesn't exist, the plugin will throw an error

Throws:

Exception

testDefineColumnsQuery

public void testDefineColumnsQuery()
                            throws RpcException

Throws:

RpcException

testLastRowQuery

public void testLastRowQuery()
                      throws RpcException

Throws:

RpcException

testStarNoFieldNamesQuery

public void testStarNoFieldNamesQuery()
                               throws RpcException

Throws:

RpcException

testExplicitNoFieldNamesQuery

public void testExplicitNoFieldNamesQuery()
                                   throws RpcException

Throws:

RpcException

testBlankRowsInFileQuery

public void testBlankRowsInFileQuery()
                              throws RpcException

Throws:

RpcException

testEmptySheetQuery

public void testEmptySheetQuery()
                         throws RpcException

This tests to what happens if you attempt to query a completely empty sheet The result should be an empty data set.

Throws:

RpcException - Throws exception if unable to connect to Drill cluster.

testMissingDataQuery

public void testMissingDataQuery()
                          throws Exception

Throws:

Exception

testInconsistentDataQuery

public void testInconsistentDataQuery()
                               throws Exception

Throws:

Exception

testSerDe

public void testSerDe()
               throws Exception

Throws:

Exception

testExplicitSomeQueryWithCompressedFile

public void testExplicitSomeQueryWithCompressedFile()
                                             throws Exception

Throws:

Exception

testFileWithDoubleDates

public void testFileWithDoubleDates()
                             throws Exception

Throws:

Exception

testTextFormula

public void testTextFormula()
                     throws Exception

Throws:

Exception

testNumericFormula

public void testNumericFormula()
                        throws Exception

Throws:

Exception

testLimitPushdown

public void testLimitPushdown()
                       throws Exception

Throws:

Exception

testBlankColumnFix

public void testBlankColumnFix()
                        throws Exception

Throws:

Exception

testGetSheetNames

public void testGetSheetNames()
                       throws RpcException

Throws:

RpcException