Expecting throwable message: "Failed reading data from sheet: 1S625j2oTptRepg6Yci68fCYE1269tdoSjljNOmTgQ3U#number_text!D1:D1" to contain: "No non-empty cells found in sheet: 1S625j2oTptRepg6Yci68fCYE1269tdoSjljNOmTgQ3U#number_text!D1:D1" but did not. Throwable that failed the check: io.trino.testing.QueryFailedException: Failed reading data from sheet: 1S625j2oTptRepg6Yci68fCYE1269tdoSjljNOmTgQ3U#number_text!D1:D1 at io.trino.testing.AbstractTestingTrinoClient.execute(AbstractTestingTrinoClient.java:133) at io.trino.testing.DistributedQueryRunner.executeInternal(DistributedQueryRunner.java:554) at io.trino.testing.DistributedQueryRunner.execute(DistributedQueryRunner.java:537) at io.trino.sql.query.QueryAssertions$QueryAssert.lambda$new$1(QueryAssertions.java:316) at com.google.common.base.Suppliers$NonSerializableMemoizingSupplier.get(Suppliers.java:186) at org.assertj.core.api.ThrowableAssert.catchThrowable(ThrowableAssert.java:63) at org.assertj.core.api.AssertionsForClassTypes.catchThrowable(AssertionsForClassTypes.java:892) at org.assertj.core.api.Assertions.catchThrowable(Assertions.java:1365) at io.trino.testing.assertions.TrinoExceptionAssert.assertTrinoExceptionThrownBy(TrinoExceptionAssert.java:67) at io.trino.sql.query.QueryAssertions$QueryAssert.failure(QueryAssertions.java:399) at io.trino.plugin.google.sheets.TestGoogleSheets.testSheetQueryWithNoDataInRangeFails(TestGoogleSheets.java:283) at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103) at java.base/java.lang.reflect.Method.invoke(Method.java:580) at org.junit.platform.commons.util.ReflectionUtils.invokeMethod(ReflectionUtils.java:728) at org.junit.jupiter.engine.execution.MethodInvocation.proceed(MethodInvocation.java:60) at org.junit.jupiter.engine.execution.InvocationInterceptorChain$ValidatingInvocation.proceed(InvocationInterceptorChain.java:131) at org.junit.jupiter.engine.extension.TimeoutExtension.intercept(TimeoutExtension.java:156) at org.junit.jupiter.engine.extension.TimeoutExtension.interceptTestableMethod(TimeoutExtension.java:147) at org.junit.jupiter.engine.extension.TimeoutExtension.interceptTestMethod(TimeoutExtension.java:86) at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker$ReflectiveInterceptorCall.lambda$ofVoidMethod$0(InterceptingExecutableInvoker.java:103) at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker.lambda$invoke$0(InterceptingExecutableInvoker.java:93) at org.junit.jupiter.engine.execution.InvocationInterceptorChain$InterceptedInvocation.proceed(InvocationInterceptorChain.java:106) at org.junit.jupiter.engine.execution.InvocationInterceptorChain.proceed(InvocationInterceptorChain.java:64) at org.junit.jupiter.engine.execution.InvocationInterceptorChain.chainAndInvoke(InvocationInterceptorChain.java:45) at org.junit.jupiter.engine.execution.InvocationInterceptorChain.invoke(InvocationInterceptorChain.java:37) at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker.invoke(InterceptingExecutableInvoker.java:92) at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker.invoke(InterceptingExecutableInvoker.java:86) at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.lambda$invokeTestMethod$7(TestMethodTestDescriptor.java:218) at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73) at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.invokeTestMethod(TestMethodTestDescriptor.java:214) at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.execute(TestMethodTestDescriptor.java:139) at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.execute(TestMethodTestDescriptor.java:69) at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$6(NodeTestTask.java:151) at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73) at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$8(NodeTestTask.java:141) at org.junit.platform.engine.support.hierarchical.Node.around(Node.java:137) at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$9(NodeTestTask.java:139) at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73) at org.junit.platform.engine.support.hierarchical.NodeTestTask.executeRecursively(NodeTestTask.java:138) at org.junit.platform.engine.support.hierarchical.NodeTestTask.execute(NodeTestTask.java:95) at org.junit.platform.engine.support.hierarchical.ForkJoinPoolHierarchicalTestExecutorService$ExclusiveTask.compute(ForkJoinPoolHierarchicalTestExecutorService.java:202) at java.base/java.util.concurrent.RecursiveAction.exec(RecursiveAction.java:194) at java.base/java.util.concurrent.ForkJoinTask.doExec(ForkJoinTask.java:507) at java.base/java.util.concurrent.ForkJoinPool$WorkQueue.topLevelExec(ForkJoinPool.java:1491) at java.base/java.util.concurrent.ForkJoinPool.scan(ForkJoinPool.java:2073) at java.base/java.util.concurrent.ForkJoinPool.runWorker(ForkJoinPool.java:2035) at java.base/java.util.concurrent.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:187) Suppressed: java.lang.Exception: SQL: SELECT * FROM TABLE(gsheets.system.sheet(id => '1S625j2oTptRepg6Yci68fCYE1269tdoSjljNOmTgQ3U', range => 'number_text!D1:D1')) at io.trino.testing.DistributedQueryRunner.executeInternal(DistributedQueryRunner.java:561) ... 45 more Caused by: io.trino.spi.TrinoException: Failed reading data from sheet: 1S625j2oTptRepg6Yci68fCYE1269tdoSjljNOmTgQ3U#number_text!D1:D1 at io.trino.plugin.google.sheets.SheetsClient.readAllValuesFromSheetExpression(SheetsClient.java:319) at com.google.common.cache.CacheLoader$FunctionToCacheLoader.load(CacheLoader.java:169) at io.trino.cache.EvictableCache$TokenCacheLoader.load(EvictableCache.java:447) at io.trino.cache.EvictableCache$TokenCacheLoader.load(EvictableCache.java:433) at com.google.common.cache.LocalCache$LoadingValueReference.loadFuture(LocalCache.java:3576) at com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2318) at com.google.common.cache.LocalCache$Segment.lockedGetOrLoad(LocalCache.java:2191) at com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2081) at com.google.common.cache.LocalCache.get(LocalCache.java:4019) at com.google.common.cache.LocalCache.getOrLoad(LocalCache.java:4042) at com.google.common.cache.LocalCache$LocalLoadingCache.get(LocalCache.java:5024) at io.trino.cache.EvictableCache.get(EvictableCache.java:145) at com.google.common.cache.AbstractLoadingCache.getUnchecked(AbstractLoadingCache.java:53) at io.trino.plugin.google.sheets.SheetsClient.readAllValuesFromSheet(SheetsClient.java:200) at io.trino.plugin.google.sheets.SheetsClient.getTable(SheetsClient.java:129) at io.trino.plugin.google.sheets.SheetsMetadata.getColumnHandles(SheetsMetadata.java:111) at io.trino.plugin.google.sheets.ptf.Sheet$SheetFunction.analyze(Sheet.java:114) at io.trino.sql.analyzer.StatementAnalyzer$Visitor.visitTableFunctionInvocation(StatementAnalyzer.java:1682) at io.trino.sql.analyzer.StatementAnalyzer$Visitor.visitTableFunctionInvocation(StatementAnalyzer.java:520) at io.trino.sql.tree.TableFunctionInvocation.accept(TableFunctionInvocation.java:56) at io.trino.sql.tree.AstVisitor.process(AstVisitor.java:27) at io.trino.sql.analyzer.StatementAnalyzer$Visitor.process(StatementAnalyzer.java:539) at io.trino.sql.analyzer.StatementAnalyzer$Visitor.analyzeFrom(StatementAnalyzer.java:4886) at io.trino.sql.analyzer.StatementAnalyzer$Visitor.visitQuerySpecification(StatementAnalyzer.java:3080) at io.trino.sql.analyzer.StatementAnalyzer$Visitor.visitQuerySpecification(StatementAnalyzer.java:520) at io.trino.sql.tree.QuerySpecification.accept(QuerySpecification.java:155) at io.trino.sql.tree.AstVisitor.process(AstVisitor.java:27) at io.trino.sql.analyzer.StatementAnalyzer$Visitor.process(StatementAnalyzer.java:539) at io.trino.sql.analyzer.StatementAnalyzer$Visitor.process(StatementAnalyzer.java:547) at io.trino.sql.analyzer.StatementAnalyzer$Visitor.visitQuery(StatementAnalyzer.java:1568) at io.trino.sql.analyzer.StatementAnalyzer$Visitor.visitQuery(StatementAnalyzer.java:520) at io.trino.sql.tree.Query.accept(Query.java:118) at io.trino.sql.tree.AstVisitor.process(AstVisitor.java:27) at io.trino.sql.analyzer.StatementAnalyzer$Visitor.process(StatementAnalyzer.java:539) at io.trino.sql.analyzer.StatementAnalyzer.analyze(StatementAnalyzer.java:499) at io.trino.sql.analyzer.StatementAnalyzer.analyze(StatementAnalyzer.java:488) at io.trino.sql.analyzer.Analyzer.analyze(Analyzer.java:97) at io.trino.sql.analyzer.Analyzer.analyze(Analyzer.java:86) at io.trino.execution.SqlQueryExecution.analyze(SqlQueryExecution.java:285) at io.trino.execution.SqlQueryExecution.<init>(SqlQueryExecution.java:218) at io.trino.execution.SqlQueryExecution$SqlQueryExecutionFactory.createQueryExecution(SqlQueryExecution.java:884) at io.trino.dispatcher.LocalDispatchQueryFactory.lambda$createDispatchQuery$0(LocalDispatchQueryFactory.java:153) at io.trino.$gen.Trino_testversion____20240523_125722_143.call(Unknown Source) at com.google.common.util.concurrent.TrustedListenableFutureTask$TrustedFutureInterruptibleTask.runInterruptibly(TrustedListenableFutureTask.java:131) at com.google.common.util.concurrent.InterruptibleTask.run(InterruptibleTask.java:76) at com.google.common.util.concurrent.TrustedListenableFutureTask.run(TrustedListenableFutureTask.java:82) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642) at java.base/java.lang.Thread.run(Thread.java:1570) Caused by: com.google.api.client.googleapis.json.GoogleJsonResponseException: 503 Service Unavailable GET https://sheets.googleapis.com/v4/spreadsheets/1S625j2oTptRepg6Yci68fCYE1269tdoSjljNOmTgQ3U/values/number_text!D1:D1 { "code" : 503, "errors" : [ { "domain" : "global", "message" : "The service is currently unavailable.", "reason" : "backendError" } ], "message" : "The service is currently unavailable.", "status" : "UNAVAILABLE" } at com.google.api.client.googleapis.json.GoogleJsonResponseException.from(GoogleJsonResponseException.java:146) at com.google.api.client.googleapis.services.json.AbstractGoogleJsonClientRequest.newExceptionOnError(AbstractGoogleJsonClientRequest.java:118) at com.google.api.client.googleapis.services.json.AbstractGoogleJsonClientRequest.newExceptionOnError(AbstractGoogleJsonClientRequest.java:37) at com.google.api.client.googleapis.services.AbstractGoogleClientRequest$3.interceptResponse(AbstractGoogleClientRequest.java:466) at com.google.api.client.http.HttpRequest.execute(HttpRequest.java:1111) at com.google.api.client.googleapis.services.AbstractGoogleClientRequest.executeUnparsed(AbstractGoogleClientRequest.java:552) at com.google.api.client.googleapis.services.AbstractGoogleClientRequest.executeUnparsed(AbstractGoogleClientRequest.java:493) at com.google.api.client.googleapis.services.AbstractGoogleClientRequest.execute(AbstractGoogleClientRequest.java:603) at io.trino.plugin.google.sheets.SheetsClient.readAllValuesFromSheetExpression(SheetsClient.java:310) ... 48 more

Execution of 'actual' query 20240523_125728_00005_q5fbn failed: SELECT * FROM TABLE(gsheets.system.sheet(id => '1S625j2oTptRepg6Yci68fCYE1269tdoSjljNOmTgQ3U', range => 'number_text!A2:B6'))WHERE "1" = "1" and "one" = "one"

Execution of 'actual' query 20240523_125728_00008_q5fbn failed: SELECT * FROM TABLE(gsheets.system.sheet(id => '1S625j2oTptRepg6Yci68fCYE1269tdoSjljNOmTgQ3U', range => 'number_text!B3:B5'))WHERE "two" = "two"

Execution of 'actual' query 20240523_125730_00016_q5fbn failed: SELECT * FROM TABLE(gsheets.system.sheet(id => '1S625j2oTptRepg6Yci68fCYE1269tdoSjljNOmTgQ3U'))WHERE number = '1' and text = 'one'

Execution of 'actual' query 20240523_125730_00020_q5fbn failed: SELECT * FROM TABLE(gsheets.system.sheet(id => '1S625j2oTptRepg6Yci68fCYE1269tdoSjljNOmTgQ3U', range => 'number_text'))

Execution of 'actual' query 20240523_125730_00021_q5fbn failed: SELECT * FROM TABLE(gsheets.system.sheet(id => '1S625j2oTptRepg6Yci68fCYE1269tdoSjljNOmTgQ3U'))

Execution of 'actual' query 20240523_125730_00026_q5fbn failed: SELECT * FROM TABLE(gsheets.system.sheet(id => '1S625j2oTptRepg6Yci68fCYE1269tdoSjljNOmTgQ3U', range => 'number_text!A1:A6'))WHERE number = number

Execution of 'actual' query 20240523_125727_00001_q5fbn failed: SELECT * FROM TABLE(gsheets.system.sheet(id => '1S625j2oTptRepg6Yci68fCYE1269tdoSjljNOmTgQ3U', range => 'number_text!A1:B4'))WHERE number = number and text = text