Flink job
This article summarizes how to deal with problems related to Flink jobs, so that you can quickly locate the cause and complete the repair.
Question 1
standalone模式无法执行mysql同步
Download flink’s cdc driver and upload resource center dependencies
https://zhiqingyun-saas.isxcode.com/tools/open/file/flink-connector-JDBC-3.1.2-1.18.jar
Question 2
'scan.incremental.snapshot.chunk.key-column' is required for table without primary key when 'scan.incremental.snapshot.enabled' enabled.
solution
在来源表添加
'scan.incremental.snapshot.enabled'='false'
Question 3
The main method caused an error: please declare primary key for sink table when query contains update/delete record.
solution
目标表添加
PRIMARY KEY(username) NOT ENFORCED
Question 4
The MySQL server has a timezone offset (0 seconds ahead of UTC) which does not match the configured timezone Asia/Shanghai. Specify the right server-time-zone to avoid inconsistencies for time-related fields.
solution
-- 时区问题
show variables like '%time_zone%';
set time_zone='+8:00';
-- 或者配置
来源表
'server-time-zone'='UTC'
Question 5
Caused by: java.sql.SQLSyntaxErrorException: Access denied; you need (at least one of) the RELOAD or FLUSH_TABLES privilege(s) for this operation
solution
-- 权限不足
SHOW GRANTS for ispong;
GRANT SELECT,RELOAD, SHOW DATABASES, REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO 'ispong'@'%';
FLUSH PRIVILEGES;
SHOW GRANTS for ispong;
Question 5
Caused by: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'MASTER STATUS' at line 1
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:121)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
at com.mysql.cj.jdbc.StatementImpl.executeQuery(StatementImpl.java:1200)
at io.debezium.jdbc.JdbcConnection.query(JdbcConnection.java:553)
at io.debezium.jdbc.JdbcConnection.query(JdbcConnection.java:496)
at io.debezium.connector.mysql.MySqlSnapshotChangeEventSource.determineSnapshotOffset(MySqlSnapshotChangeEventSource.java:276)
at io.debezium.connector.mysql.MySqlSnapshotChangeEventSource.determineSnapshotOffset(MySqlSnapshotChangeEventSource.java:46)
at io.debezium.relational.RelationalSnapshotChangeEventSource.doExecute(RelationalSnapshotChangeEventSource.java:113)
at io.debezium.pipeline.source.AbstractSnapshotChangeEventSource.execute(AbstractSnapshotChangeEventSource.java:76)
... 8 more
solution
不支持8.4以上的版本，换8.0的mysql版本
Question 6
来源表没有更新
solution
来源表必须要有个主键，否则只会增加不会更新
Question 6
Caused by: org.apache.flink.table.api.TableException: Column 'username' is NOT NULL, however, a null value is being written into it. You can set job configuration 'table.exec.sink.not-null-enforcer'='DROP' to suppress this exception and drop such records silently.
at org.apache.flink.table.runtime.operators.sink.ConstraintEnforcer.processNotNullConstraint(ConstraintEnforcer.java:261)
at org.apache.flink.table.runtime.operators.sink.ConstraintEnforcer.processElement(ConstraintEnforcer.java:241)
at org.apache.flink.streaming.runtime.tasks.CopyingChainingOutput.pushToOperator(CopyingChainingOutput.java:75)
at org.apache.flink.streaming.runtime.tasks.CopyingChainingOutput.collect(CopyingChainingOutput.java:50)
at org.apache.flink.streaming.runtime.tasks.CopyingChainingOutput.collect(CopyingChainingOutput.java:29)
at org.apache.flink.streaming.api.operators.StreamSourceContexts$ManualWatermarkContext.processAndCollect(StreamSourceContexts.java:425)
at org.apache.flink.streaming.api.operators.StreamSourceContexts$WatermarkContext.collect(StreamSourceContexts.java:520)
at org.apache.flink.streaming.api.operators.StreamSourceContexts$SwitchingOnClose.collect(StreamSourceContexts.java:110)
at org.apache.flink.cdc.debezium.internal.DebeziumChangeFetcher.emitRecordsUnderCheckpointLock(DebeziumChangeFetcher.java:273)
at org.apache.flink.cdc.debezium.internal.DebeziumChangeFetcher.handleBatch(DebeziumChangeFetcher.java:258)
at org.apache.flink.cdc.debezium.internal.DebeziumChangeFetcher.runFetchLoop(DebeziumChangeFetcher.java:155)
at org.apache.flink.cdc.debezium.DebeziumSourceFunction.run(DebeziumSourceFunction.java:447)
at org.apache.flink.streaming.api.operators.StreamSource.run(StreamSource.java:114)
at org.apache.flink.streaming.api.operators.StreamSource.run(StreamSource.java:71)
at org.apache.flink.streaming.runtime.tasks.SourceStreamTask$LegacySourceFunctionThread.run(SourceStreamTask.java:338)
solution
Add configuration in flinkConfig If the data contains null, skip it directly.
{
"table.exec.sink.not-null-enforcer": "DROP"
}
Question 7
k8s集群无法找到镜像
Maybe Kubernetes has specified a fixed image prefix, and you need to manually modify the image name and push it to the specified path.
docker tag flink:1.18.1-scala_2.12 isxcode:8443/library/flink:1.18.1-scala_2.12
docker push isxcode:8443/library/flink:1.18.1-scala_2.12
Question 8
Caused by: com.mysql.cj.exceptions.UnableToConnectException: Public Key Retrieval is not allowed
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:62)
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:86)
at com.mysql.cj.protocol.a.authentication.CachingSha2PasswordPlugin.nextAuthenticationStep(CachingSha2PasswordPlugin.java:130)
at com.mysql.cj.protocol.a.authentication.CachingSha2PasswordPlugin.nextAuthenticationStep(CachingSha2PasswordPlugin.java:49)
at com.mysql.cj.protocol.a.NativeAuthenticationProvider.proceedHandshakeWithPluggableAuthentication(NativeAuthenticationProvider.java:443)
at com.mysql.cj.protocol.a.NativeAuthenticationProvider.connect(NativeAuthenticationProvider.java:213)
at com.mysql.cj.protocol.a.NativeProtocol.connect(NativeProtocol.java:1430)
at com.mysql.cj.NativeSession.connect(NativeSession.java:134)
at com.mysql.cj.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:939)
at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:809)
... 23 more
solution
JDBC connection configuration issues
jdbc:mysql://localhost:3306/your_database?useSSL=false&allowPublicKeyRetrieval=trues
Question 9
Caused by: io.debezium.DebeziumException: java.sql.SQLSyntaxErrorException: Access denied; you need (at least one of) the SUPER, REPLICATION CLIENT privilege(s) for this operation
at io.debezium.pipeline.source.AbstractSnapshotChangeEventSource.execute(AbstractSnapshotChangeEventSource.java:85)
at io.debezium.pipeline.ChangeEventSourceCoordinator.doSnapshot(ChangeEventSourceCoordinator.java:155)
at io.debezium.pipeline.ChangeEventSourceCoordinator.executeChangeEventSources(ChangeEventSourceCoordinator.java:137)
at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:109)
... 5 more
Caused by: java.sql.SQLSyntaxErrorException: Access denied; you need (at least one of) the SUPER, REPLICATION CLIENT privilege(s) for this operation
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:121)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
at com.mysql.cj.jdbc.StatementImpl.executeQuery(StatementImpl.java:1200)
at io.debezium.jdbc.JdbcConnection.query(JdbcConnection.java:553)
at io.debezium.jdbc.JdbcConnection.query(JdbcConnection.java:496)
at io.debezium.connector.mysql.MySqlSnapshotChangeEventSource.determineSnapshotOffset(MySqlSnapshotChangeEventSource.java:276)
at io.debezium.connector.mysql.MySqlSnapshotChangeEventSource.readTableStructure(MySqlSnapshotChangeEventSource.java:315)
at io.debezium.connector.mysql.MySqlSnapshotChangeEventSource.readTableStructure(MySqlSnapshotChangeEventSource.java:46)
at io.debezium.relational.RelationalSnapshotChangeEventSource.doExecute(RelationalSnapshotChangeEventSource.java:116)
at io.debezium.pipeline.source.AbstractSnapshotChangeEventSource.execute(AbstractSnapshotChangeEventSource.java:76)
... 8 more
Insufficient permissions
GRANT SELECT, SHOW DATABASES, REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO 'ispong'@'%';
FLUSH PRIVILEGES;
Question 10
Caused by: io.debezium.DebeziumException: java.sql.SQLSyntaxErrorException: Access denied; you need (at least one of) the RELOAD or FLUSH_TABLES privilege(s) for this operation
at io.debezium.pipeline.source.AbstractSnapshotChangeEventSource.execute(AbstractSnapshotChangeEventSource.java:85)
at io.debezium.pipeline.ChangeEventSourceCoordinator.doSnapshot(ChangeEventSourceCoordinator.java:155)
at io.debezium.pipeline.ChangeEventSourceCoordinator.executeChangeEventSources(ChangeEventSourceCoordinator.java:137)
at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:109)
... 5 more
Caused by: java.sql.SQLSyntaxErrorException: Access denied; you need (at least one of) the RELOAD or FLUSH_TABLES privilege(s) for this operation
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:121)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:763)
at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java:648)
at io.debezium.jdbc.JdbcConnection.executeWithoutCommitting(JdbcConnection.java:1446)
at io.debezium.connector.mysql.MySqlSnapshotChangeEventSource.tableLock(MySqlSnapshotChangeEventSource.java:450)
at io.debezium.connector.mysql.MySqlSnapshotChangeEventSource.readTableStructure(MySqlSnapshotChangeEventSource.java:314)
at io.debezium.connector.mysql.MySqlSnapshotChangeEventSource.readTableStructure(MySqlSnapshotChangeEventSource.java:46)
at io.debezium.relational.RelationalSnapshotChangeEventSource.doExecute(RelationalSnapshotChangeEventSource.java:116)
at io.debezium.pipeline.source.AbstractSnapshotChangeEventSource.execute(AbstractSnapshotChangeEventSource.java:76)
... 8 more
Insufficient permissions
GRANT RELOAD ON *.* TO 'ispong'@'%';
FLUSH PRIVILEGES;
Question 11 Missing dependencies
Caused by: java.lang.ClassNotFoundException: org.apache.hadoop.mapred.JobConf
hadoop-mapreduce-client-core-3.0.0.jar
Caused by: java.lang.NoClassDefFoundError: org/apache/hadoop/fs/BatchListingOperations
hadoop-common-3.4.1.jar
Caused by: java.lang.ClassNotFoundException: org.apache.hadoop.hive.metastore.api.NoSuchObjectException
hive-metastore.jar
Question 12
java.util.concurrent.CompletionException: org.apache.flink.client.deployment.application.ApplicationExecutionException: The application contains no execute() calls.
at java.util.concurrent.CompletableFuture.encodeThrowable(CompletableFuture.java:292) ~[?:1.8.0_202]
at java.util.concurrent.CompletableFuture.completeThrowable(CompletableFuture.java:308) ~[?:1.8.0_202]
at java.util.concurrent.CompletableFuture.uniCompose(CompletableFuture.java:943) ~[?:1.8.0_202]
at java.util.concurrent.CompletableFuture$UniCompose.tryFire(CompletableFuture.java:926) ~[?:1.8.0_202]
at java.util.concurrent.CompletableFuture.postComplete(CompletableFuture.java:474) ~[?:1.8.0_202]
at java.util.concurrent.CompletableFuture.completeExceptionally(CompletableFuture.java:1977) ~[?:1.8.0_202]
at org.apache.flink.client.deployment.application.ApplicationDispatcherBootstrap.runApplicationEntryPoint(ApplicationDispatcherBootstrap.java:309) ~[flink-dist-1.18.1.jar:1.18.1]
at org.apache.flink.client.deployment.application.ApplicationDispatcherBootstrap.lambda$runApplicationAsync$2(ApplicationDispatcherBootstrap.java:254) ~[flink-dist-1.18.1.jar:1.18.1]
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) ~[?:1.8.0_202]
at java.util.concurrent.FutureTask.run(FutureTask.java:266) ~[?:1.8.0_202]
at org.apache.flink.runtime.concurrent.pekko.ActorSystemScheduledExecutorAdapter$ScheduledFutureTask.run(ActorSystemScheduledExecutorAdapter.java:172) ~[?:?]
at org.apache.flink.runtime.concurrent.ClassLoadingUtils.runWithContextClassLoader(ClassLoadingUtils.java:68) ~[flink-dist-1.18.1.jar:1.18.1]
at org.apache.flink.runtime.concurrent.ClassLoadingUtils.lambda$withContextClassLoader$0(ClassLoadingUtils.java:41) ~[flink-dist-1.18.1.jar:1.18.1]
at org.apache.pekko.dispatch.TaskInvocation.run(AbstractDispatcher.scala:59) [flink-rpc-akka878eb79e-f52f-45fd-948c-efa59f8e9145.jar:1.18.1]
at org.apache.pekko.dispatch.ForkJoinExecutorConfigurator$PekkoForkJoinTask.exec(ForkJoinExecutorConfigurator.scala:57) [flink-rpc-akka878eb79e-f52f-45fd-948c-efa59f8e9145.jar:1.18.1]
at java.util.concurrent.ForkJoinTask.doExec(ForkJoinTask.java:289) [?:1.8.0_202]
at java.util.concurrent.ForkJoinPool$WorkQueue.runTask(ForkJoinPool.java:1056) [?:1.8.0_202]
at java.util.concurrent.ForkJoinPool.runWorker(ForkJoinPool.java:1692) [?:1.8.0_202]
at java.util.concurrent.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:157) [?:1.8.0_202]
Caused by: org.apache.flink.client.deployment.application.ApplicationExecutionException: The application contains no execute() calls.
... 13 more
Flink SQL内容异常
Question 13
Caused by: java.lang.ClassNotFoundException: com.facebook.fb303.FacebookService$Iface
at java.net.URLClassLoader.findClass(URLClassLoader.java:387) ~[?:1.8.0_412]
at java.lang.ClassLoader.loadClass(ClassLoader.java:418) ~[?:1.8.0_412]
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:352) ~[?:1.8.0_412]
at java.lang.ClassLoader.loadClass(ClassLoader.java:351) ~[?:1.8.0_412]
at java.lang.ClassLoader.defineClass1(Native Method) ~[?:1.8.0_412]
at java.lang.ClassLoader.defineClass(ClassLoader.java:756) ~[?:1.8.0_412]
at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:142) ~[?:1.8.0_412]
at java.net.URLClassLoader.defineClass(URLClassLoader.java:473) ~[?:1.8.0_412]
at java.net.URLClassLoader.access$100(URLClassLoader.java:74) ~[?:1.8.0_412]
at java.net.URLClassLoader$1.run(URLClassLoader.java:369) ~[?:1.8.0_412]
at java.net.URLClassLoader$1.run(URLClassLoader.java:363) ~[?:1.8.0_412]
at java.security.AccessController.doPrivileged(Native Method) ~[?:1.8.0_412]
at java.net.URLClassLoader.findClass(URLClassLoader.java:362) ~[?:1.8.0_412]
at java.lang.ClassLoader.loadClass(ClassLoader.java:418) ~[?:1.8.0_412]
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:352) ~[?:1.8.0_412]
at java.lang.ClassLoader.loadClass(ClassLoader.java:351) ~[?:1.8.0_412]
at java.lang.Class.forName0(Native Method) ~[?:1.8.0_412]
at java.lang.Class.forName(Class.java:348) ~[?:1.8.0_412]
at org.apache.hadoop.hive.metastore.utils.JavaUtils.getClass(JavaUtils.java:52) ~[sy_1986612053931524096.jar:3.1.3]
at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.getProxy(RetryingMetaStoreClient.java:146) ~[sy_1986612053931524096.jar:3.1.3]
at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.getProxy(RetryingMetaStoreClient.java:119) ~[sy_1986612053931524096.jar:3.1.3]
at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.getProxy(RetryingMetaStoreClient.java:112) ~[sy_1986612053931524096.jar:3.1.3]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_412]
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_412]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_412]
at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_412]
at org.apache.iceberg.common.DynMethods$UnboundMethod.invokeChecked(DynMethods.java:62) ~[sy_1986723935774375936.jar:?]
at org.apache.iceberg.common.DynMethods$UnboundMethod.invoke(DynMethods.java:74) ~[sy_1986723935774375936.jar:?]
at org.apache.iceberg.common.DynMethods$StaticMethod.invoke(DynMethods.java:187) ~[sy_1986723935774375936.jar:?]
at org.apache.iceberg.hive.HiveClientPool.newClient(HiveClientPool.java:63) ~[sy_1986723935774375936.jar:?]
at org.apache.iceberg.hive.HiveClientPool.newClient(HiveClientPool.java:34) ~[sy_1986723935774375936.jar:?]
at org.apache.iceberg.ClientPoolImpl.get(ClientPoolImpl.java:143) ~[sy_1986723935774375936.jar:?]
at org.apache.iceberg.ClientPoolImpl.run(ClientPoolImpl.java:70) ~[sy_1986723935774375936.jar:?]
at org.apache.iceberg.ClientPoolImpl.run(ClientPoolImpl.java:65) ~[sy_1986723935774375936.jar:?]
at org.apache.iceberg.hive.CachedClientPool.run(CachedClientPool.java:122) ~[sy_1986723935774375936.jar:?]
at org.apache.iceberg.hive.HiveTableOperations.doRefresh(HiveTableOperations.java:147) ~[sy_1986723935774375936.jar:?]
at org.apache.iceberg.BaseMetastoreTableOperations.refresh(BaseMetastoreTableOperations.java:90) ~[sy_1986723935774375936.jar:?]
at org.apache.iceberg.BaseMetastoreTableOperations.current(BaseMetastoreTableOperations.java:73) ~[sy_1986723935774375936.jar:?]
at org.apache.iceberg.BaseMetastoreCatalog$BaseMetastoreCatalogTableBuilder.create(BaseMetastoreCatalog.java:191) ~[sy_1986723935774375936.jar:?]
at org.apache.iceberg.CachingCatalog$CachingTableBuilder.lambda$create$0(CachingCatalog.java:262) ~[sy_1986723935774375936.jar:?]
at org.apache.iceberg.shaded.com.github.benmanes.caffeine.cache.BoundedLocalCache.lambda$doComputeIfAbsent$14(BoundedLocalCache.java:2406) ~[sy_1986723935774375936.jar:?]
at java.util.concurrent.ConcurrentHashMap.compute(ConcurrentHashMap.java:1853) ~[?:1.8.0_412]
at org.apache.iceberg.shaded.com.github.benmanes.caffeine.cache.BoundedLocalCache.doComputeIfAbsent(BoundedLocalCache.java:2404) ~[sy_1986723935774375936.jar:?]
at org.apache.iceberg.shaded.com.github.benmanes.caffeine.cache.BoundedLocalCache.computeIfAbsent(BoundedLocalCache.java:2387) ~[sy_1986723935774375936.jar:?]
at org.apache.iceberg.shaded.com.github.benmanes.caffeine.cache.LocalCache.computeIfAbsent(LocalCache.java:108) ~[sy_1986723935774375936.jar:?]
at org.apache.iceberg.shaded.com.github.benmanes.caffeine.cache.LocalManualCache.get(LocalManualCache.java:62) ~[sy_1986723935774375936.jar:?]
at org.apache.iceberg.CachingCatalog$CachingTableBuilder.create(CachingCatalog.java:258) ~[sy_1986723935774375936.jar:?]
at org.apache.iceberg.catalog.Catalog.createTable(Catalog.java:75) ~[sy_1986723935774375936.jar:?]
at org.apache.iceberg.flink.FlinkCatalog.createIcebergTable(FlinkCatalog.java:415) ~[sy_1986723935774375936.jar:?]
at org.apache.iceberg.flink.FlinkCatalog.createTable(FlinkCatalog.java:395) ~[sy_1986723935774375936.jar:?]
at org.apache.flink.table.catalog.CatalogManager.lambda$createTable$18(CatalogManager.java:957) ~[flink-table-api-java-uber-1.18.1.jar:1.18.1]
at org.apache.flink.table.catalog.CatalogManager.execute(CatalogManager.java:1290) ~[flink-table-api-java-uber-1.18.1.jar:1.18.1]
at org.apache.flink.table.catalog.CatalogManager.createTable(CatalogManager.java:946) ~[flink-table-api-java-uber-1.18.1.jar:1.18.1]
at org.apache.flink.table.operations.ddl.CreateTableOperation.execute(CreateTableOperation.java:84) ~[flink-table-api-java-uber-1.18.1.jar:1.18.1]
at org.apache.flink.table.api.internal.TableEnvironmentImpl.executeInternal(TableEnvironmentImpl.java:1092) ~[flink-table-api-java-uber-1.18.1.jar:1.18.1]
at org.apache.flink.table.api.internal.TableEnvironmentImpl.executeSql(TableEnvironmentImpl.java:735) ~[flink-table-api-java-uber-1.18.1.jar:1.18.1]
at com.isxcode.zhiqingyun.plugin.flink.sql.execute.Job.main(Job.java:51) ~[flink-sql-execute-plugin.jar:?]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_412]
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_412]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_412]
at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_412]
at org.apache.flink.client.program.PackagedProgram.callMainMethod(PackagedProgram.java:355) ~[flink-dist-1.18.1.jar:1.18.1]
at org.apache.flink.client.program.PackagedProgram.invokeInteractiveModeForExecution(PackagedProgram.java:222) ~[flink-dist-1.18.1.jar:1.18.1]
at org.apache.flink.client.ClientUtils.executeProgram(ClientUtils.java:105) ~[flink-dist-1.18.1.jar:1.18.1]
at org.apache.flink.client.deployment.application.ApplicationDispatcherBootstrap.runApplicationEntryPoint(ApplicationDispatcherBootstrap.java:301) ~[flink-dist-1.18.1.jar:1.18.1]
... 12 more
Missing dependencies libfb303-0.9.3.jar download
Question 14
Caused by: java.lang.ClassNotFoundException: org.apache.thrift.TException
at java.net.URLClassLoader.findClass(URLClassLoader.java:387) ~[?:1.8.0_412]
at java.lang.ClassLoader.loadClass(ClassLoader.java:418) ~[?:1.8.0_412]
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:352) ~[?:1.8.0_412]
at java.lang.ClassLoader.loadClass(ClassLoader.java:351) ~[?:1.8.0_412]
... 35 more
Missing dependency libthrift-0.9.3.jar download
Question 15
Caused by: java.lang.ClassNotFoundException: org.apache.hadoop.hive.metastore.api.NoSuchObjectException
at java.net.URLClassLoader.findClass(URLClassLoader.java:387) ~[?:1.8.0_412]
at java.lang.ClassLoader.loadClass(ClassLoader.java:418) ~[?:1.8.0_412]
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:352) ~[?:1.8.0_412]
at java.lang.ClassLoader.loadClass(ClassLoader.java:351) ~[?:1.8.0_412]
... 35 more
Missing dependency hive-Standalone-metastore-3.1.3.jar download
Question 16
Caused by: java.lang.ClassNotFoundException: org.apache.hadoop.hive.conf.HiveConf$ConfVars
at java.net.URLClassLoader.findClass(URLClassLoader.java:387) ~[?:1.8.0_412]
at java.lang.ClassLoader.loadClass(ClassLoader.java:418) ~[?:1.8.0_412]
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:352) ~[?:1.8.0_412]
at java.lang.ClassLoader.loadClass(ClassLoader.java:351) ~[?:1.8.0_412]
at org.apache.iceberg.hive.HiveCatalog.initialize(HiveCatalog.java:95) ~[sy_1986723935774375936.jar:?]
at org.apache.iceberg.CatalogUtil.loadCatalog(CatalogUtil.java:256) ~[sy_1986723935774375936.jar:?]
at org.apache.iceberg.flink.CatalogLoader$HiveCatalogLoader.loadCatalog(CatalogLoader.java:128) ~[sy_1986723935774375936.jar:?]
at org.apache.iceberg.flink.FlinkCatalog.<init>(FlinkCatalog.java:114) ~[sy_1986723935774375936.jar:?]
at org.apache.iceberg.flink.FlinkCatalogFactory.createCatalog(FlinkCatalogFactory.java:166) ~[sy_1986723935774375936.jar:?]
at org.apache.iceberg.flink.FlinkCatalogFactory.createCatalog(FlinkCatalogFactory.java:139) ~[sy_1986723935774375936.jar:?]
at org.apache.flink.table.factories.FactoryUtil.createCatalog(FactoryUtil.java:476) ~[flink-table-api-java-uber-1.18.1.jar:1.18.1]
at org.apache.flink.table.catalog.CatalogManager.initCatalog(CatalogManager.java:316) ~[flink-table-api-java-uber-1.18.1.jar:1.18.1]
at org.apache.flink.table.catalog.CatalogManager.createCatalog(CatalogManager.java:308) ~[flink-table-api-java-uber-1.18.1.jar:1.18.1]
at org.apache.flink.table.operations.ddl.CreateCatalogOperation.execute(CreateCatalogOperation.java:68) ~[flink-table-api-java-uber-1.18.1.jar:1.18.1]
at org.apache.flink.table.api.internal.TableEnvironmentImpl.executeInternal(TableEnvironmentImpl.java:1092) ~[flink-table-api-java-uber-1.18.1.jar:1.18.1]
at org.apache.flink.table.api.internal.TableEnvironmentImpl.executeSql(TableEnvironmentImpl.java:735) ~[flink-table-api-java-uber-1.18.1.jar:1.18.1]
at com.isxcode.zhiqingyun.plugin.flink.sql.execute.Job.main(Job.java:51) ~[flink-sql-execute-plugin.jar:?]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_412]
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_412]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_412]
at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_412]
at org.apache.flink.client.program.PackagedProgram.callMainMethod(PackagedProgram.java:355) ~[flink-dist-1.18.1.jar:1.18.1]
at org.apache.flink.client.program.PackagedProgram.invokeInteractiveModeForExecution(PackagedProgram.java:222) ~[flink-dist-1.18.1.jar:1.18.1]
at org.apache.flink.client.ClientUtils.executeProgram(ClientUtils.java:105) ~[flink-dist-1.18.1.jar:1.18.1]
at org.apache.flink.client.deployment.application.ApplicationDispatcherBootstrap.runApplicationEntryPoint(ApplicationDispatcherBootstrap.java:301) ~[flink-dist-1.18.1.jar:1.18.1]
... 12 more
Missing dependency hive-common-3.1.3.jar download
Question 17
Caused by: java.lang.ClassNotFoundException: org.apache.hadoop.mapred.JobConf
at java.net.URLClassLoader.findClass(URLClassLoader.java:387) ~[?:1.8.0_412]
at java.lang.ClassLoader.loadClass(ClassLoader.java:418) ~[?:1.8.0_412]
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:352) ~[?:1.8.0_412]
at java.lang.ClassLoader.loadClass(ClassLoader.java:351) ~[?:1.8.0_412]
at org.apache.hadoop.hive.conf.HiveConf.initialize(HiveConf.java:5144) ~[sy_1986612332714328064.jar:3.1.3]
at org.apache.hadoop.hive.conf.HiveConf.<init>(HiveConf.java:5112) ~[sy_1986612332714328064.jar:3.1.3]
at org.apache.iceberg.hive.HiveClientPool.<init>(HiveClientPool.java:55) ~[sy_1986723935774375936.jar:?]
at org.apache.iceberg.hive.CachedClientPool.lambda$clientPool$0(CachedClientPool.java:96) ~[sy_1986723935774375936.jar:?]
at org.apache.iceberg.shaded.com.github.benmanes.caffeine.cache.BoundedLocalCache.lambda$doComputeIfAbsent$14(BoundedLocalCache.java:2406) ~[sy_1986723935774375936.jar:?]
at java.util.concurrent.ConcurrentHashMap.compute(ConcurrentHashMap.java:1853) ~[?:1.8.0_412]
at org.apache.iceberg.shaded.com.github.benmanes.caffeine.cache.BoundedLocalCache.doComputeIfAbsent(BoundedLocalCache.java:2404) ~[sy_1986723935774375936.jar:?]
at org.apache.iceberg.shaded.com.github.benmanes.caffeine.cache.BoundedLocalCache.computeIfAbsent(BoundedLocalCache.java:2387) ~[sy_1986723935774375936.jar:?]
at org.apache.iceberg.shaded.com.github.benmanes.caffeine.cache.LocalCache.computeIfAbsent(LocalCache.java:108) ~[sy_1986723935774375936.jar:?]
at org.apache.iceberg.shaded.com.github.benmanes.caffeine.cache.LocalManualCache.get(LocalManualCache.java:62) ~[sy_1986723935774375936.jar:?]
at org.apache.iceberg.hive.CachedClientPool.clientPool(CachedClientPool.java:96) ~[sy_1986723935774375936.jar:?]
at org.apache.iceberg.hive.CachedClientPool.run(CachedClientPool.java:122) ~[sy_1986723935774375936.jar:?]
at org.apache.iceberg.hive.HiveTableOperations.doRefresh(HiveTableOperations.java:147) ~[sy_1986723935774375936.jar:?]
at org.apache.iceberg.BaseMetastoreTableOperations.refresh(BaseMetastoreTableOperations.java:90) ~[sy_1986723935774375936.jar:?]
at org.apache.iceberg.BaseMetastoreTableOperations.current(BaseMetastoreTableOperations.java:73) ~[sy_1986723935774375936.jar:?]
at org.apache.iceberg.BaseMetastoreCatalog$BaseMetastoreCatalogTableBuilder.create(BaseMetastoreCatalog.java:191) ~[sy_1986723935774375936.jar:?]
at org.apache.iceberg.CachingCatalog$CachingTableBuilder.lambda$create$0(CachingCatalog.java:262) ~[sy_1986723935774375936.jar:?]
at org.apache.iceberg.shaded.com.github.benmanes.caffeine.cache.BoundedLocalCache.lambda$doComputeIfAbsent$14(BoundedLocalCache.java:2406) ~[sy_1986723935774375936.jar:?]
at java.util.concurrent.ConcurrentHashMap.compute(ConcurrentHashMap.java:1853) ~[?:1.8.0_412]
at org.apache.iceberg.shaded.com.github.benmanes.caffeine.cache.BoundedLocalCache.doComputeIfAbsent(BoundedLocalCache.java:2404) ~[sy_1986723935774375936.jar:?]
at org.apache.iceberg.shaded.com.github.benmanes.caffeine.cache.BoundedLocalCache.computeIfAbsent(BoundedLocalCache.java:2387) ~[sy_1986723935774375936.jar:?]
at org.apache.iceberg.shaded.com.github.benmanes.caffeine.cache.LocalCache.computeIfAbsent(LocalCache.java:108) ~[sy_1986723935774375936.jar:?]
at org.apache.iceberg.shaded.com.github.benmanes.caffeine.cache.LocalManualCache.get(LocalManualCache.java:62) ~[sy_1986723935774375936.jar:?]
at org.apache.iceberg.CachingCatalog$CachingTableBuilder.create(CachingCatalog.java:258) ~[sy_1986723935774375936.jar:?]
at org.apache.iceberg.catalog.Catalog.createTable(Catalog.java:75) ~[sy_1986723935774375936.jar:?]
at org.apache.iceberg.flink.FlinkCatalog.createIcebergTable(FlinkCatalog.java:415) ~[sy_1986723935774375936.jar:?]
at org.apache.iceberg.flink.FlinkCatalog.createTable(FlinkCatalog.java:395) ~[sy_1986723935774375936.jar:?]
at org.apache.flink.table.catalog.CatalogManager.lambda$createTable$18(CatalogManager.java:957) ~[flink-table-api-java-uber-1.18.1.jar:1.18.1]
at org.apache.flink.table.catalog.CatalogManager.execute(CatalogManager.java:1290) ~[flink-table-api-java-uber-1.18.1.jar:1.18.1]
at org.apache.flink.table.catalog.CatalogManager.createTable(CatalogManager.java:946) ~[flink-table-api-java-uber-1.18.1.jar:1.18.1]
at org.apache.flink.table.operations.ddl.CreateTableOperation.execute(CreateTableOperation.java:84) ~[flink-table-api-java-uber-1.18.1.jar:1.18.1]
at org.apache.flink.table.api.internal.TableEnvironmentImpl.executeInternal(TableEnvironmentImpl.java:1092) ~[flink-table-api-java-uber-1.18.1.jar:1.18.1]
at org.apache.flink.table.api.internal.TableEnvironmentImpl.executeSql(TableEnvironmentImpl.java:735) ~[flink-table-api-java-uber-1.18.1.jar:1.18.1]
at com.isxcode.zhiqingyun.plugin.flink.sql.execute.Job.main(Job.java:51) ~[flink-sql-execute-plugin.jar:?]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_412]
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_412]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_412]
at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_412]
at org.apache.flink.client.program.PackagedProgram.callMainMethod(PackagedProgram.java:355) ~[flink-dist-1.18.1.jar:1.18.1]
at org.apache.flink.client.program.PackagedProgram.invokeInteractiveModeForExecution(PackagedProgram.java:222) ~[flink-dist-1.18.1.jar:1.18.1]
at org.apache.flink.client.ClientUtils.executeProgram(ClientUtils.java:105) ~[flink-dist-1.18.1.jar:1.18.1]
at org.apache.flink.client.deployment.application.ApplicationDispatcherBootstrap.runApplicationEntryPoint(ApplicationDispatcherBootstrap.java:301) ~[flink-dist-1.18.1.jar:1.18.1]
... 12 more
Missing dependency hive-Standalone-metastore-3.1.3.jar download
Question 18
Caused by: java.lang.ClassNotFoundException: org.apache.commons.lang.StringUtils
at java.net.URLClassLoader.findClass(URLClassLoader.java:387) ~[?:1.8.0_412]
at java.lang.ClassLoader.loadClass(ClassLoader.java:418) ~[?:1.8.0_412]
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:352) ~[?:1.8.0_412]
at java.lang.ClassLoader.loadClass(ClassLoader.java:351) ~[?:1.8.0_412]
at org.apache.hadoop.hive.conf.HiveConf.initialize(HiveConf.java:5201) ~[sy_1986612332714328064.jar:3.1.3]
at org.apache.hadoop.hive.conf.HiveConf.<init>(HiveConf.java:5112) ~[sy_1986612332714328064.jar:3.1.3]
at org.apache.iceberg.hive.HiveClientPool.<init>(HiveClientPool.java:55) ~[sy_1986723935774375936.jar:?]
at org.apache.iceberg.hive.CachedClientPool.lambda$clientPool$0(CachedClientPool.java:96) ~[sy_1986723935774375936.jar:?]
at org.apache.iceberg.shaded.com.github.benmanes.caffeine.cache.BoundedLocalCache.lambda$doComputeIfAbsent$14(BoundedLocalCache.java:2406) ~[sy_1986723935774375936.jar:?]
at java.util.concurrent.ConcurrentHashMap.compute(ConcurrentHashMap.java:1853) ~[?:1.8.0_412]
at org.apache.iceberg.shaded.com.github.benmanes.caffeine.cache.BoundedLocalCache.doComputeIfAbsent(BoundedLocalCache.java:2404) ~[sy_1986723935774375936.jar:?]
at org.apache.iceberg.shaded.com.github.benmanes.caffeine.cache.BoundedLocalCache.computeIfAbsent(BoundedLocalCache.java:2387) ~[sy_1986723935774375936.jar:?]
at org.apache.iceberg.shaded.com.github.benmanes.caffeine.cache.LocalCache.computeIfAbsent(LocalCache.java:108) ~[sy_1986723935774375936.jar:?]
at org.apache.iceberg.shaded.com.github.benmanes.caffeine.cache.LocalManualCache.get(LocalManualCache.java:62) ~[sy_1986723935774375936.jar:?]
at org.apache.iceberg.hive.CachedClientPool.clientPool(CachedClientPool.java:96) ~[sy_1986723935774375936.jar:?]
at org.apache.iceberg.hive.CachedClientPool.run(CachedClientPool.java:122) ~[sy_1986723935774375936.jar:?]
at org.apache.iceberg.hive.HiveTableOperations.doRefresh(HiveTableOperations.java:147) ~[sy_1986723935774375936.jar:?]
at org.apache.iceberg.BaseMetastoreTableOperations.refresh(BaseMetastoreTableOperations.java:90) ~[sy_1986723935774375936.jar:?]
at org.apache.iceberg.BaseMetastoreTableOperations.current(BaseMetastoreTableOperations.java:73) ~[sy_1986723935774375936.jar:?]
at org.apache.iceberg.BaseMetastoreCatalog$BaseMetastoreCatalogTableBuilder.create(BaseMetastoreCatalog.java:191) ~[sy_1986723935774375936.jar:?]
at org.apache.iceberg.CachingCatalog$CachingTableBuilder.lambda$create$0(CachingCatalog.java:262) ~[sy_1986723935774375936.jar:?]
at org.apache.iceberg.shaded.com.github.benmanes.caffeine.cache.BoundedLocalCache.lambda$doComputeIfAbsent$14(BoundedLocalCache.java:2406) ~[sy_1986723935774375936.jar:?]
at java.util.concurrent.ConcurrentHashMap.compute(ConcurrentHashMap.java:1853) ~[?:1.8.0_412]
at org.apache.iceberg.shaded.com.github.benmanes.caffeine.cache.BoundedLocalCache.doComputeIfAbsent(BoundedLocalCache.java:2404) ~[sy_1986723935774375936.jar:?]
at org.apache.iceberg.shaded.com.github.benmanes.caffeine.cache.BoundedLocalCache.computeIfAbsent(BoundedLocalCache.java:2387) ~[sy_1986723935774375936.jar:?]
at org.apache.iceberg.shaded.com.github.benmanes.caffeine.cache.LocalCache.computeIfAbsent(LocalCache.java:108) ~[sy_1986723935774375936.jar:?]
at org.apache.iceberg.shaded.com.github.benmanes.caffeine.cache.LocalManualCache.get(LocalManualCache.java:62) ~[sy_1986723935774375936.jar:?]
at org.apache.iceberg.CachingCatalog$CachingTableBuilder.create(CachingCatalog.java:258) ~[sy_1986723935774375936.jar:?]
at org.apache.iceberg.catalog.Catalog.createTable(Catalog.java:75) ~[sy_1986723935774375936.jar:?]
at org.apache.iceberg.flink.FlinkCatalog.createIcebergTable(FlinkCatalog.java:415) ~[sy_1986723935774375936.jar:?]
at org.apache.iceberg.flink.FlinkCatalog.createTable(FlinkCatalog.java:395) ~[sy_1986723935774375936.jar:?]
at org.apache.flink.table.catalog.CatalogManager.lambda$createTable$18(CatalogManager.java:957) ~[flink-table-api-java-uber-1.18.1.jar:1.18.1]
at org.apache.flink.table.catalog.CatalogManager.execute(CatalogManager.java:1290) ~[flink-table-api-java-uber-1.18.1.jar:1.18.1]
at org.apache.flink.table.catalog.CatalogManager.createTable(CatalogManager.java:946) ~[flink-table-api-java-uber-1.18.1.jar:1.18.1]
at org.apache.flink.table.operations.ddl.CreateTableOperation.execute(CreateTableOperation.java:84) ~[flink-table-api-java-uber-1.18.1.jar:1.18.1]
at org.apache.flink.table.api.internal.TableEnvironmentImpl.executeInternal(TableEnvironmentImpl.java:1092) ~[flink-table-api-java-uber-1.18.1.jar:1.18.1]
at org.apache.flink.table.api.internal.TableEnvironmentImpl.executeSql(TableEnvironmentImpl.java:735) ~[flink-table-api-java-uber-1.18.1.jar:1.18.1]
at com.isxcode.zhiqingyun.plugin.flink.sql.execute.Job.main(Job.java:51) ~[flink-sql-execute-plugin.jar:?]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_412]
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_412]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_412]
at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_412]
at org.apache.flink.client.program.PackagedProgram.callMainMethod(PackagedProgram.java:355) ~[flink-dist-1.18.1.jar:1.18.1]
at org.apache.flink.client.program.PackagedProgram.invokeInteractiveModeForExecution(PackagedProgram.java:222) ~[flink-dist-1.18.1.jar:1.18.1]
at org.apache.flink.client.ClientUtils.executeProgram(ClientUtils.java:105) ~[flink-dist-1.18.1.jar:1.18.1]
at org.apache.flink.client.deployment.application.ApplicationDispatcherBootstrap.runApplicationEntryPoint(ApplicationDispatcherBootstrap.java:301) ~[flink-dist-1.18.1.jar:1.18.1]
... 12 more
Missing dependencies commons-lang-2.6.jar download
Question 19
Caused by: java.lang.ClassNotFoundException: org.apache.hadoop.hive.common.ValidWriteIdList
at java.net.URLClassLoader.findClass(URLClassLoader.java:387) ~[?:1.8.0_412]
at java.lang.ClassLoader.loadClass(ClassLoader.java:418) ~[?:1.8.0_412]
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:352) ~[?:1.8.0_412]
at java.lang.ClassLoader.loadClass(ClassLoader.java:351) ~[?:1.8.0_412]
at java.lang.Class.forName0(Native Method) ~[?:1.8.0_412]
at java.lang.Class.forName(Class.java:348) ~[?:1.8.0_412]
at org.apache.hadoop.hive.metastore.utils.JavaUtils.getClass(JavaUtils.java:52) ~[sy_1986612371608109056.jar:3.1.3]
at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.getProxy(RetryingMetaStoreClient.java:146) ~[sy_1986612371608109056.jar:3.1.3]
at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.getProxy(RetryingMetaStoreClient.java:119) ~[sy_1986612371608109056.jar:3.1.3]
at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.getProxy(RetryingMetaStoreClient.java:112) ~[sy_1986612371608109056.jar:3.1.3]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_412]
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_412]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_412]
at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_412]
at org.apache.iceberg.common.DynMethods$UnboundMethod.invokeChecked(DynMethods.java:62) ~[sy_1986723935774375936.jar:?]
at org.apache.iceberg.common.DynMethods$UnboundMethod.invoke(DynMethods.java:74) ~[sy_1986723935774375936.jar:?]
at org.apache.iceberg.common.DynMethods$StaticMethod.invoke(DynMethods.java:187) ~[sy_1986723935774375936.jar:?]
at org.apache.iceberg.hive.HiveClientPool.newClient(HiveClientPool.java:63) ~[sy_1986723935774375936.jar:?]
at org.apache.iceberg.hive.HiveClientPool.newClient(HiveClientPool.java:34) ~[sy_1986723935774375936.jar:?]
at org.apache.iceberg.ClientPoolImpl.get(ClientPoolImpl.java:143) ~[sy_1986723935774375936.jar:?]
at org.apache.iceberg.ClientPoolImpl.run(ClientPoolImpl.java:70) ~[sy_1986723935774375936.jar:?]
at org.apache.iceberg.ClientPoolImpl.run(ClientPoolImpl.java:65) ~[sy_1986723935774375936.jar:?]
at org.apache.iceberg.hive.CachedClientPool.run(CachedClientPool.java:122) ~[sy_1986723935774375936.jar:?]
at org.apache.iceberg.hive.HiveTableOperations.doRefresh(HiveTableOperations.java:147) ~[sy_1986723935774375936.jar:?]
at org.apache.iceberg.BaseMetastoreTableOperations.refresh(BaseMetastoreTableOperations.java:90) ~[sy_1986723935774375936.jar:?]
at org.apache.iceberg.BaseMetastoreTableOperations.current(BaseMetastoreTableOperations.java:73) ~[sy_1986723935774375936.jar:?]
at org.apache.iceberg.BaseMetastoreCatalog$BaseMetastoreCatalogTableBuilder.create(BaseMetastoreCatalog.java:191) ~[sy_1986723935774375936.jar:?]
at org.apache.iceberg.CachingCatalog$CachingTableBuilder.lambda$create$0(CachingCatalog.java:262) ~[sy_1986723935774375936.jar:?]
at org.apache.iceberg.shaded.com.github.benmanes.caffeine.cache.BoundedLocalCache.lambda$doComputeIfAbsent$14(BoundedLocalCache.java:2406) ~[sy_1986723935774375936.jar:?]
at java.util.concurrent.ConcurrentHashMap.compute(ConcurrentHashMap.java:1853) ~[?:1.8.0_412]
at org.apache.iceberg.shaded.com.github.benmanes.caffeine.cache.BoundedLocalCache.doComputeIfAbsent(BoundedLocalCache.java:2404) ~[sy_1986723935774375936.jar:?]
at org.apache.iceberg.shaded.com.github.benmanes.caffeine.cache.BoundedLocalCache.computeIfAbsent(BoundedLocalCache.java:2387) ~[sy_1986723935774375936.jar:?]
at org.apache.iceberg.shaded.com.github.benmanes.caffeine.cache.LocalCache.computeIfAbsent(LocalCache.java:108) ~[sy_1986723935774375936.jar:?]
at org.apache.iceberg.shaded.com.github.benmanes.caffeine.cache.LocalManualCache.get(LocalManualCache.java:62) ~[sy_1986723935774375936.jar:?]
at org.apache.iceberg.CachingCatalog$CachingTableBuilder.create(CachingCatalog.java:258) ~[sy_1986723935774375936.jar:?]
at org.apache.iceberg.catalog.Catalog.createTable(Catalog.java:75) ~[sy_1986723935774375936.jar:?]
at org.apache.iceberg.flink.FlinkCatalog.createIcebergTable(FlinkCatalog.java:415) ~[sy_1986723935774375936.jar:?]
at org.apache.iceberg.flink.FlinkCatalog.createTable(FlinkCatalog.java:395) ~[sy_1986723935774375936.jar:?]
at org.apache.flink.table.catalog.CatalogManager.lambda$createTable$18(CatalogManager.java:957) ~[flink-table-api-java-uber-1.18.1.jar:1.18.1]
at org.apache.flink.table.catalog.CatalogManager.execute(CatalogManager.java:1290) ~[flink-table-api-java-uber-1.18.1.jar:1.18.1]
at org.apache.flink.table.catalog.CatalogManager.createTable(CatalogManager.java:946) ~[flink-table-api-java-uber-1.18.1.jar:1.18.1]
at org.apache.flink.table.operations.ddl.CreateTableOperation.execute(CreateTableOperation.java:84) ~[flink-table-api-java-uber-1.18.1.jar:1.18.1]
at org.apache.flink.table.api.internal.TableEnvironmentImpl.executeInternal(TableEnvironmentImpl.java:1092) ~[flink-table-api-java-uber-1.18.1.jar:1.18.1]
at org.apache.flink.table.api.internal.TableEnvironmentImpl.executeSql(TableEnvironmentImpl.java:735) ~[flink-table-api-java-uber-1.18.1.jar:1.18.1]
at com.isxcode.zhiqingyun.plugin.flink.sql.execute.Job.main(Job.java:51) ~[flink-sql-execute-plugin.jar:?]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_412]
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_412]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_412]
at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_412]
at org.apache.flink.client.program.PackagedProgram.callMainMethod(PackagedProgram.java:355) ~[flink-dist-1.18.1.jar:1.18.1]
at org.apache.flink.client.program.PackagedProgram.invokeInteractiveModeForExecution(PackagedProgram.java:222) ~[flink-dist-1.18.1.jar:1.18.1]
at org.apache.flink.client.ClientUtils.executeProgram(ClientUtils.java:105) ~[flink-dist-1.18.1.jar:1.18.1]
at org.apache.flink.client.deployment.application.ApplicationDispatcherBootstrap.runApplicationEntryPoint(ApplicationDispatcherBootstrap.java:301) ~[flink-dist-1.18.1.jar:1.18.1]
... 12 more
Missing dependency hive-exec-3.1.3.jar download
Question 20
Caused by: java.lang.SecurityException: sealing violation: package oracle.jdbc.driver is sealed
at java.net.URLClassLoader.getAndVerifyPackage(URLClassLoader.java:405)
at java.net.URLClassLoader.definePackageInternal(URLClassLoader.java:425)
at java.net.URLClassLoader.defineClass(URLClassLoader.java:457)
at java.net.URLClassLoader.access$100(URLClassLoader.java:74)
at java.net.URLClassLoader$1.run(URLClassLoader.java:369)
at java.net.URLClassLoader$1.run(URLClassLoader.java:363)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:362)
at org.apache.flink.util.ChildFirstClassLoader.loadClassWithoutExceptionHandling(ChildFirstClassLoader.java:71)
at org.apache.flink.util.FlinkUserCodeClassLoader.loadClass(FlinkUserCodeClassLoader.java:51)
at java.lang.ClassLoader.loadClass(ClassLoader.java:351)
at org.apache.flink.util.FlinkUserCodeClassLoaders$SafetyNetWrapperClassLoader.loadClass(FlinkUserCodeClassLoaders.java:192)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:348)
at org.apache.flink.connector.jdbc.internal.connection.SimpleJdbcConnectionProvider.loadDriver(SimpleJdbcConnectionProvider.java:90)
at org.apache.flink.connector.jdbc.internal.connection.SimpleJdbcConnectionProvider.getLoadedDriver(SimpleJdbcConnectionProvider.java:100)
at org.apache.flink.connector.jdbc.internal.connection.SimpleJdbcConnectionProvider.getOrEstablishConnection(SimpleJdbcConnectionProvider.java:117)
at org.apache.flink.connector.jdbc.table.JdbcRowDataInputFormat.openInputFormat(JdbcRowDataInputFormat.java:107)
at org.apache.flink.streaming.api.functions.source.InputFormatSourceFunction.run(InputFormatSourceFunction.java:86)
at org.apache.flink.streaming.api.operators.StreamSource.run(StreamSource.java:114)
at org.apache.flink.streaming.api.operators.StreamSource.run(StreamSource.java:71)
at org.apache.flink.streaming.runtime.tasks.SourceStreamTask$LegacySourceFunctionThread.run(SourceStreamTask.java:338)
驱动重复，需要将作业配置中的依赖中删除多余的驱动文件
Question 21
Caused by: java.lang.NoClassDefFoundError: oracle/sql/CHAR
at org.apache.flink.connector.jdbc.databases.oracle.dialect.OracleRowConverter.lambda$createInternalConverter$224afae6$9(OracleRowConverter.java:117)
at org.apache.flink.connector.jdbc.converter.AbstractJdbcRowConverter.lambda$wrapIntoNullableInternalConverter$ea5b8348$1(AbstractJdbcRowConverter.java:127)
at org.apache.flink.connector.jdbc.converter.AbstractJdbcRowConverter.toInternal(AbstractJdbcRowConverter.java:78)
at org.apache.flink.connector.jdbc.table.JdbcRowDataInputFormat.nextRecord(JdbcRowDataInputFormat.java:257)
at org.apache.flink.connector.jdbc.table.JdbcRowDataInputFormat.nextRecord(JdbcRowDataInputFormat.java:56)
at org.apache.flink.streaming.api.functions.source.InputFormatSourceFunction.run(InputFormatSourceFunction.java:97)
at org.apache.flink.streaming.api.operators.StreamSource.run(StreamSource.java:114)
at org.apache.flink.streaming.api.operators.StreamSource.run(StreamSource.java:71)
at org.apache.flink.streaming.runtime.tasks.SourceStreamTask$LegacySourceFunctionThread.run(SourceStreamTask.java:338)
先判断，是否是standalone模式
如果是，则将oracle驱动拷贝到zhqingyun-agent代理的flink-min/lib目录下
并重新停止计算引擎，停止节点后，再重启节点
Question 22
failed to open a new selector
Caused by: java.lang.IllegalStateException: failed to create a child event loop
at org.apache.flink.shaded.netty4.io.netty.util.concurrent.MultithreadEventExecutorGroup.<init>(MultithreadEventExecutorGroup.java:88) ~[flink-shaded-netty-4.1.91.Final-17.0.jar!/:na]
at org.apache.flink.shaded.netty4.io.netty.util.concurrent.MultithreadEventExecutorGroup.<init>(MultithreadEventExecutorGroup.java:60) ~[flink-shaded-netty-4.1.91.Final-17.0.jar!/:na]
at org.apache.flink.shaded.netty4.io.netty.util.concurrent.MultithreadEventExecutorGroup.<init>(MultithreadEventExecutorGroup.java:49) ~[flink-shaded-netty-4.1.91.Final-17.0.jar!/:na]
at org.apache.flink.shaded.netty4.io.netty.channel.MultithreadEventLoopGroup.<init>(MultithreadEventLoopGroup.java:59) ~[flink-shaded-netty-4.1.91.Final-17.0.jar!/:na]
at org.apache.flink.shaded.netty4.io.netty.channel.nio.NioEventLoopGroup.<init>(NioEventLoopGroup.java:87) ~[flink-shaded-netty-4.1.91.Final-17.0.jar!/:na]
at org.apache.flink.runtime.rest.RestClient.<init>(RestClient.java:272) ~[flink-runtime-1.18.1.jar!/:1.18.1]
at org.apache.flink.runtime.rest.RestClient.<init>(RestClient.java:167) ~[flink-runtime-1.18.1.jar!/:1.18.1]
at org.apache.flink.runtime.rest.RestClient.<init>(RestClient.java:162) ~[flink-runtime-1.18.1.jar!/:1.18.1]
at org.apache.flink.client.program.rest.RestClusterClient.<init>(RestClusterClient.java:235) ~[flink-clients-1.18.1.jar!/:1.18.1]
at org.apache.flink.client.program.rest.RestClusterClient.<init>(RestClusterClient.java:202) ~[flink-clients-1.18.1.jar!/:1.18.1]
at org.apache.flink.client.program.rest.RestClusterClient.<init>(RestClusterClient.java:196) ~[flink-clients-1.18.1.jar!/:1.18.1]
at org.apache.flink.client.deployment.StandaloneClusterDescriptor.lambda$retrieve$0(StandaloneClusterDescriptor.java:51) ~[flink-clients-1.18.1.jar!/:1.18.1]
... 66 common frames omitted
Caused by: org.apache.flink.shaded.netty4.io.netty.channel.ChannelException: failed to open a new selector
at org.apache.flink.shaded.netty4.io.netty.channel.nio.NioEventLoop.openSelector(NioEventLoop.java:179) ~[flink-shaded-netty-4.1.91.Final-17.0.jar!/:na]
at org.apache.flink.shaded.netty4.io.netty.channel.nio.NioEventLoop.<init>(NioEventLoop.java:146) ~[flink-shaded-netty-4.1.91.Final-17.0.jar!/:na]
at org.apache.flink.shaded.netty4.io.netty.channel.nio.NioEventLoopGroup.newChild(NioEventLoopGroup.java:183) ~[flink-shaded-netty-4.1.91.Final-17.0.jar!/:na]
at org.apache.flink.shaded.netty4.io.netty.channel.nio.NioEventLoopGroup.newChild(NioEventLoopGroup.java:38) ~[flink-shaded-netty-4.1.91.Final-17.0.jar!/:na]
at org.apache.flink.shaded.netty4.io.netty.util.concurrent.MultithreadEventExecutorGroup.<init>(MultithreadEventExecutorGroup.java:84) ~[flink-shaded-netty-4.1.91.Final-17.0.jar!/:na]
... 77 common frames omitted
Caused by: java.io.IOException: Too many open files
at sun.nio.ch.EPollArrayWrapper.epollCreate(Native Method) ~[na:1.8.0_412]
at sun.nio.ch.EPollArrayWrapper.<init>(EPollArrayWrapper.java:130) ~[na:1.8.0_412]
at sun.nio.ch.EPollSelectorImpl.<init>(EPollSelectorImpl.java:69) ~[na:1.8.0_412]
at sun.nio.ch.EPollSelectorProvider.openSelector(EPollSelectorProvider.java:36) ~[na:1.8.0_412]
at org.apache.flink.shaded.netty4.io.netty.channel.nio.NioEventLoop.openSelector(NioEventLoop.java:177) ~[flink-shaded-netty-4.1.91.Final-17.0.jar!/:na]
... 81 common frames omitted
检查打开文件数限制
ulimit -n
# 如果是默认的1024，则需要重新设置大一点
# 比如临时配置： ulimit -n 65536
Question 23
Caused by: java.lang.IllegalArgumentException: Embedded metastore is not allowed. Make sure you have set a valid value for hive.metastore.uris
at org.apache.flink.util.Preconditions.checkArgument(Preconditions.java:138) ~[flink-dist-1.18.1.jar:1.18.1]
at org.apache.flink.table.catalog.hive.HiveCatalog.<init>(HiveCatalog.java:213) ~[sy_1991758871096602624.jar:1.18.1]
at org.apache.flink.table.catalog.hive.HiveCatalog.<init>(HiveCatalog.java:195) ~[sy_1991758871096602624.jar:1.18.1]
at org.apache.flink.table.catalog.hive.HiveCatalog.<init>(HiveCatalog.java:187) ~[sy_1991758871096602624.jar:1.18.1]
at org.apache.flink.table.catalog.hive.factories.HiveCatalogFactory.createCatalog(HiveCatalogFactory.java:76) ~[sy_1991758871096602624.jar:1.18.1]
at org.apache.flink.table.factories.FactoryUtil.createCatalog(FactoryUtil.java:498) ~[flink-table-api-java-uber-1.18.1.jar:1.18.1]
at org.apache.flink.table.catalog.CatalogManager.initCatalog(CatalogManager.java:316) ~[flink-table-api-java-uber-1.18.1.jar:1.18.1]
at org.apache.flink.table.catalog.CatalogManager.createCatalog(CatalogManager.java:308) ~[flink-table-api-java-uber-1.18.1.jar:1.18.1]
at org.apache.flink.table.operations.ddl.CreateCatalogOperation.execute(CreateCatalogOperation.java:68) ~[flink-table-api-java-uber-1.18.1.jar:1.18.1]
at org.apache.flink.table.api.internal.TableEnvironmentImpl.executeInternal(TableEnvironmentImpl.java:1092) ~[flink-table-api-java-uber-1.18.1.jar:1.18.1]
at org.apache.flink.table.api.internal.TableEnvironmentImpl.executeSql(TableEnvironmentImpl.java:735) ~[flink-table-api-java-uber-1.18.1.jar:1.18.1]
at com.isxcode.zhiqingyun.plugin.flink.sql.execute.Job.main(Job.java:73) ~[flink-sql-execute-plugin.jar:?]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_412]
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_412]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_412]
at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_412]
at org.apache.flink.client.program.PackagedProgram.callMainMethod(PackagedProgram.java:355) ~[flink-dist-1.18.1.jar:1.18.1]
at org.apache.flink.client.program.PackagedProgram.invokeInteractiveModeForExecution(PackagedProgram.java:222) ~[flink-dist-1.18.1.jar:1.18.1]
at org.apache.flink.client.ClientUtils.executeProgram(ClientUtils.java:105) ~[flink-dist-1.18.1.jar:1.18.1]
at org.apache.flink.client.deployment.application.ApplicationDispatcherBootstrap.runApplicationEntryPoint(ApplicationDispatcherBootstrap.java:301) ~[flink-dist-1.18.1.jar:1.18.1]
... 12 more
solution
原因是：Flink通过hive的配置文件找不到hive.metastore.uris的配置，导致报错
vim /opt/hive/conf/hive-site.xml
<property>
<name>hive.metastore.uris</name>
<value>thrift://139.224.195.82:9083</value>
<description>Thrift URI for the remote metastore. Used by metastore client to connect to remote metastore.</description>
</property>
Question 24
请求代理异常 : The number of requested virtual cores for application master 1 exceeds the maximum number of virtual cores 0 available in the Yarn Cluster.2026-03-12T17:32:08.709 ERROR : ❌ 运行作业失败
solution
这是yarn服务异常，检查NodeManager服务是否正常，检查服务器存储是否到90%，内存使用是否过高，导致无法申请yarn资源
Question 25
Cannot discover a connector using option: 'connector'='doris'
solution
下载依赖文件 - flink-doris-connector-1.18-25.0.0.jar