tempto icon indicating copy to clipboard operation
tempto copied to clipboard

Tempto fails when unable to list all tables

Open mattsfuller opened this issue 8 years ago • 0 comments

Tempto fails in the scenario when listing all tables internally using system.jdbc.tables throws error. This happened on FB clusters as they have clusters that do not allow you to list the tables for some connectors

Exception in thread "main" java.lang.RuntimeException: java.sql.SQLException: Query failed (#20160324_203009_00028_2wc4a): Cannot list tables in all databases
        at com.teradata.tempto.internal.fulfillment.table.AbstractTableManager.dropAllMutableTables(AbstractTableManager.java:60)
        at java.util.Iterator.forEachRemaining(Iterator.java:116)
        at java.util.Spliterators$IteratorSpliterator.forEachRemaining(Spliterators.java:1801)
        at java.util.stream.ReferencePipeline$Head.forEach(ReferencePipeline.java:580)
        at com.teradata.tempto.internal.fulfillment.table.MutableTablesCleaner.fulfill(MutableTablesCleaner.java:38)
        at com.teradata.tempto.internal.initialization.TestInitializationListener.lambda$doFulfillment$44(TestInitializationListener.java:311)
        at com.teradata.tempto.context.TestContextDsl.runWithTestContext(TestContextDsl.java:51)
        at 


Caused by: com.facebook.presto.spi.PrestoException: Cannot list tables in all databases
        at com.facebook.presto.xdb.XdbClient.getTableNames(XdbClient.java:165)
        at com.facebook.presto.plugin.jdbc.JdbcMetadata.listTables(JdbcMetadata.java:103)
        at com.facebook.presto.transaction.LegacyConnectorMetadata.listTables(LegacyConnectorMetadata.java:94)
        at com.facebook.presto.metadata.MetadataManager.listTables(MetadataManager.java:367)
        at com.facebook.presto.connector.system.jdbc.TableJdbcTable.cursor(TableJdbcTable.java:90)
        at com.facebook.presto.connector.system.SystemRecordSetProvider$1.cursor(SystemRecordSetProvider.java:118)
        at com.facebook.presto.split.MappedRecordSet.cursor(MappedRecordSet.java:53)
        at com.facebook.presto.spi.RecordPageSource.<init>(RecordPageSource.java:37)
        at com.facebook.presto.split.RecordPageSourceProvider.createPageSource(RecordPageSourceProvider.java:42)
        at com.facebook.presto.split.PageSourceManager.createPageSource(PageSourceManager.java:48)
        at com.facebook.presto.operator.TableScanOperator.createSourceIfNecessary(TableScanOperator.java:268)  
        at com.facebook.presto.operator.TableScanOperator.isFinished(TableScanOperator.java:210)
        at com.facebook.presto.operator.Driver.processInternal(Driver.java:377)
        at com.facebook.presto.operator.Driver.processFor(Driver.java:303)
        at com.facebook.presto.execution.SqlTaskExecution$DriverSplitRunner.processFor(SqlTaskExecution.java:575)
        at com.facebook.presto.execution.TaskExecutor$PrioritizedSplitRunner.process(TaskExecutor.java:505)
        at com.facebook.presto.execution.TaskExecutor$Runner.run(TaskExecutor.java:640)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
        at java.lang.Thread.run(Thread.java:745)

mattsfuller avatar Sep 07 '16 18:09 mattsfuller