Hi Steve, I would try using the dedicated BigQuery input, it should also work with the local engine.
The issue seems to be some duplicate/shaded classes in the Simba driver. Kr, Hans On Sun, 10 May 2026 at 21:35, Zadroga, Stephen via dev <[email protected]> wrote: > Team, > Looking for some help regarding an issue I am having with trying to fetch > data from GCP / BigQuery and send to Postgres DB. I have a BQ connection > established and I can connect successfully, I also can successfully connect > to the Postgres DB, but when I try to move a larger count of records, 100k > the pipeline fails. If I attempt around 10k records, the pipeline runs > successfully. > > I am using Apache Hop 2.15.0. I have installed the driver > "SimbaJDBCDriverforGoogleBigQuery42_1.3.3.1004" for BigQuery and can > connect successfully. For fetching data from BQ, I am using "table input" > with SQL and for Postgres DB, I am using "table output". > > Below is the error message - any help is greatly appreciated. *Please let > me know if I can provide additional information. > > 2026/05/08 13:18:54 - SELECT GCP INC data.0 - ERROR: Unexpected error > 2026/05/08 13:18:54 - SELECT GCP INC data.0 - ERROR: > com.google.common.util.concurrent.ExecutionError: java.lang.LinkageError: > loader constraint violation: when resolving method 'io.grpc.Deadline > io.grpc.CallOptions.getDeadline()' the class loader > org.apache.hop.core.plugins.HopURLClassLoader @35c344ce of the current > class, com/google/api/gax/grpc/GrpcClientCalls, and the class loader 'app' > for the method's defining class, io/grpc/CallOptions, have different Class > objects for the type io/grpc/Deadline used in the signature > (com.google.api.gax.grpc.GrpcClientCalls is in unnamed module of loader > org.apache.hop.core.plugins.HopURLClassLoader @35c344ce, parent loader > 'app'; io.grpc.CallOptions is in unnamed module of loader 'app') > 2026/05/08 13:18:54 - SELECT GCP INC data.0 - at > com.google.common.util.concurrent.Futures.wrapAndThrowUnchecked(Futures.java:1388) > 2026/05/08 13:18:54 - SELECT GCP INC data.0 - at > com.google.common.util.concurrent.Futures.getUnchecked(Futures.java:1381) > 2026/05/08 13:18:54 - SELECT GCP INC data.0 - at > com.google.api.gax.rpc.ApiExceptions.callAndTranslateApiException(ApiExceptions.java:53) > 2026/05/08 13:18:54 - SELECT GCP INC data.0 - at > com.google.api.gax.rpc.UnaryCallable.call(UnaryCallable.java:112) > 2026/05/08 13:18:54 - SELECT GCP INC data.0 - at > com.google.cloud.bigquery.storage.v1.BigQueryReadClient.createReadSession(BigQueryReadClient.java:232) > 2026/05/08 13:18:54 - SELECT GCP INC data.0 - at > com.simba.googlebigquery.googlebigquery.client.BQClient.createReadSession(Unknown > Source) > 2026/05/08 13:18:54 - SELECT GCP INC data.0 - at > com.simba.googlebigquery.googlebigquery.dataengine.BQBufferManager.startReadingWithHTAPI(Unknown > Source) > 2026/05/08 13:18:54 - SELECT GCP INC data.0 - at > com.simba.googlebigquery.googlebigquery.dataengine.BQBufferManager.processTheFirstPage(Unknown > Source) > 2026/05/08 13:18:54 - SELECT GCP INC data.0 - at > com.simba.googlebigquery.googlebigquery.dataengine.BQBufferManager.<init>(Unknown > Source) > 2026/05/08 13:18:54 - SELECT GCP INC data.0 - at > com.simba.googlebigquery.googlebigquery.dataengine.BQResultSet.<init>(Unknown > Source) > 2026/05/08 13:18:54 - SELECT GCP INC data.0 - at > com.simba.googlebigquery.googlebigquery.dataengine.BQSQLExecutor.execute(Unknown > Source) > 2026/05/08 13:18:54 - SELECT GCP INC data.0 - at > com.simba.googlebigquery.jdbc.common.SStatement.executeNoParams(Unknown > Source) > 2026/05/08 13:18:54 - SELECT GCP INC data.0 - at > com.simba.googlebigquery.jdbc.common.BaseStatement.executeQuery(Unknown > Source) > 2026/05/08 13:18:54 - SELECT GCP INC data.0 - at > org.apache.hop.core.database.Database.openQuery(Database.java:1585) > 2026/05/08 13:18:54 - SELECT GCP INC data.0 - at > org.apache.hop.pipeline.transforms.tableinput.TableInput.doQuery(TableInput.java:231) > 2026/05/08 13:18:54 - SELECT GCP INC data.0 - at > org.apache.hop.pipeline.transforms.tableinput.TableInput.processRow(TableInput.java:137) > 2026/05/08 13:18:54 - SELECT GCP INC data.0 - at > org.apache.hop.pipeline.transform.RunThread.run(RunThread.java:54) > 2026/05/08 13:18:54 - SELECT GCP INC data.0 - at > java.base/java.lang.Thread.run(Thread.java:840) > 2026/05/08 13:18:54 - SELECT GCP INC data.0 - Caused by: > java.lang.LinkageError: loader constraint violation: when resolving method > 'io.grpc.Deadline io.grpc.CallOptions.getDeadline()' the class loader > org.apache.hop.core.plugins.HopURLClassLoader @35c344ce of the current > class, com/google/api/gax/grpc/GrpcClientCalls, and the class loader 'app' > for the method's defining class, io/grpc/CallOptions, have different Class > objects for the type io/grpc/Deadline used in the signature > (com.google.api.gax.grpc.GrpcClientCalls is in unnamed module of loader > org.apache.hop.core.plugins.HopURLClassLoader @35c344ce, parent loader > 'app'; io.grpc.CallOptions is in unnamed module of loader 'app') > 2026/05/08 13:18:54 - SELECT GCP INC data.0 - at > com.google.api.gax.grpc.GrpcClientCalls.newCall(GrpcClientCalls.java:80) > 2026/05/08 13:18:54 - SELECT GCP INC data.0 - at > com.google.api.gax.grpc.GrpcDirectCallable.futureCall(GrpcDirectCallable.java:60) > 2026/05/08 13:18:54 - SELECT GCP INC data.0 - at > com.google.api.gax.grpc.GrpcUnaryRequestParamCallable.futureCall(GrpcUnaryRequestParamCallable.java:65) > 2026/05/08 13:18:54 - SELECT GCP INC data.0 - at > com.google.api.gax.grpc.GrpcExceptionCallable.futureCall(GrpcExceptionCallable.java:64) > 2026/05/08 13:18:54 - SELECT GCP INC data.0 - at > com.google.api.gax.rpc.AttemptCallable.call(AttemptCallable.java:87) > 2026/05/08 13:18:54 - SELECT GCP INC data.0 - at > com.google.api.gax.rpc.RetryingCallable.futureCall(RetryingCallable.java:63) > 2026/05/08 13:18:54 - SELECT GCP INC data.0 - at > com.google.api.gax.rpc.RetryingCallable.futureCall(RetryingCallable.java:41) > 2026/05/08 13:18:54 - SELECT GCP INC data.0 - at > com.google.api.gax.tracing.TracedUnaryCallable.futureCall(TracedUnaryCallable.java:75) > 2026/05/08 13:18:54 - SELECT GCP INC data.0 - at > com.google.api.gax.rpc.UnaryCallable$1.futureCall(UnaryCallable.java:126) > 2026/05/08 13:18:54 - SELECT GCP INC data.0 - at > com.google.api.gax.rpc.UnaryCallable.futureCall(UnaryCallable.java:87) > 2026/05/08 13:18:54 - SELECT GCP INC data.0 - ... 15 more > 2026/05/08 13:18:54 - SELECT GCP INC data.0 - child index = 1, logging > object : org.apache.hop.core.logging.LoggingObject@5c24d925<mailto: > org.apache.hop.core.logging.LoggingObject@5c24d925> > parent=81b51b41-4de2-435b-a42a-dfc6361e253a > 2026/05/08 13:18:54 - SELECT GCP INC data.0 - Finished reading query, > closing connection. > 2026/05/08 13:18:54 - sky BQ - Connection to database closed! > 2026/05/08 13:18:54 - SELECT GCP INC data.0 - Finished processing (I=0, > O=0, R=0, W=0, U=0, E=1) > 2026/05/08 13:18:54 - incident - Pipeline detected one or more transforms > with errors. > 2026/05/08 13:18:54 - incident - Pipeline is killing the other transforms! > 2026/05/08 13:18:54 - incident - Looking at transform: SELECT GCP INC data > 2026/05/08 13:18:54 - incident - Looking at transform: truncLoad > tmp_********************* > 2026/05/08 13:18:54 - truncLoad tmp_ ******************0 - Signaling > 'output done' to 0 output rowsets. > 2026/05/08 13:18:54 - ck -rw- - Commit on database connection [ck -rw-] > 2026/05/08 13:18:54 - ck -rw- - Connection to database closed! > 2026/05/08 13:18:54 - truncLoad tmp_************ - Finished processing > (I=0, O=0, R=0, W=0, U=0, E=0) > 2026/05/08 13:18:54 - incident - Pipeline duration : 13.988 seconds [ > 13.987" ] > 2026/05/08 13:18:54 - incident - Execution finished on a local pipeline > engine with run configuration 'local' > > Steve Zadroga > Senior Engineer - REactor platform > > 1800 Arch St Philadelphia, PA 19103 > <https://www.google.com/maps/search/1800+Arch+St+Philadelphia,+PA+19103?entry=gmail&source=g> > | 26.S1-F > (215) 286-8306 > >
