Hans, Thanks for the feedback – going to try the dedicated “BigQuery input”.
Best, Steve Zadroga Senior Engineer – REactor platform From: Hans Van Akelyen <[email protected]> Sent: Sunday, May 10, 2026 4:16 PM To: [email protected] Cc: Zadroga, Stephen <[email protected]> Subject: [EXTERNAL] Re: Trouble Moving Data - BigQuery to Postgres DB 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 <dev@ hop. apache. org> 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]<mailto:[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<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://urldefense.com/v3/__https:/www.google.com/maps/search/1800*Arch*St*Philadelphia,*PA*19103?entry=gmail&source=g__;KysrKys!!CQl3mcHX2A!FJE2FAXakyVo70vk4NnzIAAqATbJjhfyiy1IK5GO1khXPg3Hx0g8_fVtnIlLhYxepo6k1iIFdy7ZKAFY-ckt2VHGyMhQZFGNOw$> | 26.S1-F (215) 286-8306
