tempto
tempto copied to clipboard
Tempto fails when unable to list all tables
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)