[ https://issues.apache.org/jira/browse/FLINK-28451?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
ASF GitHub Bot updated FLINK-28451: ----------------------------------- Labels: pull-request-available (was: ) > HiveFunctionDefinitionFactory load udf using user classloader instead of > thread context classloader > --------------------------------------------------------------------------------------------------- > > Key: FLINK-28451 > URL: https://issues.apache.org/jira/browse/FLINK-28451 > Project: Flink > Issue Type: Sub-task > Components: Connectors / Hive > Affects Versions: 1.16.0 > Reporter: dalongliu > Priority: Major > Labels: pull-request-available > Fix For: 1.16.0 > > > Currently `HiveFunctionDefinitionFactory` load user defined function using > thread context classloader, after we introducing user classloader to load > function class from FLINK-27659, this maybe doesn't work if the user jar not > in thread classloader. The following exception will be thrown: > {code:java} > 23478 [main] WARN org.apache.flink.table.client.cli.CliClient [] - Could > not execute SQL > statement.org.apache.flink.table.client.gateway.SqlExecutionException: Failed > to parse statement: SELECT id, func1(str) FROM (VALUES (1, 'Hello World')) AS > T(id, str) ; at > org.apache.flink.table.client.gateway.local.LocalExecutor.parseStatement(LocalExecutor.java:174) > ~[classes/:?] at > org.apache.flink.table.client.cli.SqlCommandParserImpl.parseCommand(SqlCommandParserImpl.java:45) > ~[classes/:?] at > org.apache.flink.table.client.cli.SqlMultiLineParser.parse(SqlMultiLineParser.java:71) > ~[classes/:?] at > org.jline.reader.impl.LineReaderImpl.acceptLine(LineReaderImpl.java:2964) > ~[jline-reader-3.21.0.jar:?] at > org.jline.reader.impl.LineReaderImpl$1.apply(LineReaderImpl.java:3778) > ~[jline-reader-3.21.0.jar:?] at > org.jline.reader.impl.LineReaderImpl.readLine(LineReaderImpl.java:679) > ~[jline-reader-3.21.0.jar:?] at > org.apache.flink.table.client.cli.CliClient.getAndExecuteStatements(CliClient.java:296) > [classes/:?] at > org.apache.flink.table.client.cli.CliClient.executeInteractive(CliClient.java:281) > [classes/:?] at > org.apache.flink.table.client.cli.CliClient.executeInInteractiveMode(CliClient.java:229) > [classes/:?] at > org.apache.flink.table.client.cli.CliClientITCase.runSqlStatements(CliClientITCase.java:172) > [test-classes/:?] at > org.apache.flink.table.client.cli.CliClientITCase.testSqlStatements(CliClientITCase.java:137) > [test-classes/:?] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native > Method) ~[?:1.8.0_291] at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) > ~[?:1.8.0_291] at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > ~[?:1.8.0_291] at java.lang.reflect.Method.invoke(Method.java:498) > ~[?:1.8.0_291] at > org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:59) > [junit-4.13.2.jar:4.13.2] at > org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12) > [junit-4.13.2.jar:4.13.2] at > org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:56) > [junit-4.13.2.jar:4.13.2] at > org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17) > [junit-4.13.2.jar:4.13.2] at > org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:26) > [junit-4.13.2.jar:4.13.2] at > org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:27) > [junit-4.13.2.jar:4.13.2] at > org.apache.flink.util.TestNameProvider$1.evaluate(TestNameProvider.java:45) > [classes/:?] at > org.junit.rules.TestWatcher$1.evaluate(TestWatcher.java:61) > [junit-4.13.2.jar:4.13.2] at > org.junit.runners.ParentRunner$3.evaluate(ParentRunner.java:306) > [junit-4.13.2.jar:4.13.2] at > org.junit.runners.BlockJUnit4ClassRunner$1.evaluate(BlockJUnit4ClassRunner.java:100) > [junit-4.13.2.jar:4.13.2] at > org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:366) > [junit-4.13.2.jar:4.13.2] at > org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:103) > [junit-4.13.2.jar:4.13.2] at > org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:63) > [junit-4.13.2.jar:4.13.2] at > org.junit.runners.ParentRunner$4.run(ParentRunner.java:331) > [junit-4.13.2.jar:4.13.2] at > org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:79) > [junit-4.13.2.jar:4.13.2] at > org.junit.runners.ParentRunner.runChildren(ParentRunner.java:329) > [junit-4.13.2.jar:4.13.2] at > org.junit.runners.ParentRunner.access$100(ParentRunner.java:66) > [junit-4.13.2.jar:4.13.2] at > org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:293) > [junit-4.13.2.jar:4.13.2] at > org.junit.runners.ParentRunner.run(ParentRunner.java:413) > [junit-4.13.2.jar:4.13.2] at > org.junit.runners.Suite.runChild(Suite.java:128) [junit-4.13.2.jar:4.13.2] > at org.junit.runners.Suite.runChild(Suite.java:27) [junit-4.13.2.jar:4.13.2] > at org.junit.runners.ParentRunner$4.run(ParentRunner.java:331) > [junit-4.13.2.jar:4.13.2] at > org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:79) > [junit-4.13.2.jar:4.13.2] at > org.junit.runners.ParentRunner.runChildren(ParentRunner.java:329) > [junit-4.13.2.jar:4.13.2] at > org.junit.runners.ParentRunner.access$100(ParentRunner.java:66) > [junit-4.13.2.jar:4.13.2] at > org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:293) > [junit-4.13.2.jar:4.13.2] at > org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:26) > [junit-4.13.2.jar:4.13.2] at > org.junit.rules.ExternalResource$1.evaluate(ExternalResource.java:54) > [junit-4.13.2.jar:4.13.2] at > org.junit.rules.ExternalResource$1.evaluate(ExternalResource.java:54) > [junit-4.13.2.jar:4.13.2] at > org.junit.rules.ExternalResource$1.evaluate(ExternalResource.java:54) > [junit-4.13.2.jar:4.13.2] at > org.junit.rules.RunRules.evaluate(RunRules.java:20) [junit-4.13.2.jar:4.13.2] > at org.junit.runners.ParentRunner$3.evaluate(ParentRunner.java:306) > [junit-4.13.2.jar:4.13.2] at > org.junit.runners.ParentRunner.run(ParentRunner.java:413) > [junit-4.13.2.jar:4.13.2] at > org.junit.runner.JUnitCore.run(JUnitCore.java:137) [junit-4.13.2.jar:4.13.2] > at > com.intellij.junit4.JUnit4IdeaTestRunner.startRunnerWithArgs(JUnit4IdeaTestRunner.java:69) > [junit-rt.jar:?] at > com.intellij.rt.junit.IdeaTestRunner$Repeater$1.execute(IdeaTestRunner.java:38) > [junit-rt.jar:?] at > com.intellij.rt.execution.junit.TestsRepeater.repeat(TestsRepeater.java:11) > [idea_rt.jar:?] at > com.intellij.rt.junit.IdeaTestRunner$Repeater.startRunnerWithArgs(IdeaTestRunner.java:35) > [junit-rt.jar:?] at > com.intellij.rt.junit.JUnitStarter.prepareStreamsAndStart(JUnitStarter.java:235) > [junit-rt.jar:?] at > com.intellij.rt.junit.JUnitStarter.main(JUnitStarter.java:54) > [junit-rt.jar:?]Caused by: org.apache.flink.table.api.ValidationException: > SQL validation failed. Can't resolve udf class LowerUDF at > org.apache.flink.table.planner.calcite.FlinkPlannerImpl.org$apache$flink$table$planner$calcite$FlinkPlannerImpl$$validate(FlinkPlannerImpl.scala:182) > ~[classes/:?] at > org.apache.flink.table.planner.calcite.FlinkPlannerImpl.validate(FlinkPlannerImpl.scala:109) > ~[classes/:?] at > org.apache.flink.table.planner.operations.SqlToOperationConverter.convert(SqlToOperationConverter.java:241) > ~[classes/:?] at > org.apache.flink.table.planner.delegation.ParserImpl.parse(ParserImpl.java:106) > ~[classes/:?] at > org.apache.flink.table.client.gateway.local.LocalExecutor.parseStatement(LocalExecutor.java:172) > ~[classes/:?] ... 54 moreCaused by: java.lang.RuntimeException: Can't > resolve udf class LowerUDF at > org.apache.flink.table.catalog.CatalogFunctionImpl.isGeneric(CatalogFunctionImpl.java:90) > ~[classes/:?] at > org.apache.flink.table.catalog.hive.factories.HiveFunctionDefinitionFactory.createFunctionDefinition(HiveFunctionDefinitionFactory.java:61) > ~[classes/:?] at > org.apache.flink.table.factories.FunctionDefinitionFactory.createFunctionDefinition(FunctionDefinitionFactory.java:60) > ~[classes/:?] at > org.apache.flink.table.catalog.FunctionCatalog.resolvePreciseFunctionReference(FunctionCatalog.java:586) > ~[classes/:?] at > org.apache.flink.table.catalog.FunctionCatalog.lambda$resolveAmbiguousFunctionReference$3(FunctionCatalog.java:634) > ~[classes/:?] at java.util.Optional.orElseGet(Optional.java:267) > ~[?:1.8.0_291] at > org.apache.flink.table.catalog.FunctionCatalog.resolveAmbiguousFunctionReference(FunctionCatalog.java:634) > ~[classes/:?] at > org.apache.flink.table.catalog.FunctionCatalog.lookupFunction(FunctionCatalog.java:368) > ~[classes/:?] at > org.apache.flink.table.planner.catalog.FunctionCatalogOperatorTable.lookupOperatorOverloads(FunctionCatalogOperatorTable.java:94) > ~[classes/:?] at > org.apache.calcite.sql.util.ChainedSqlOperatorTable.lookupOperatorOverloads(ChainedSqlOperatorTable.java:67) > ~[calcite-core-1.26.0.jar:1.26.0] at > org.apache.calcite.sql.validate.SqlValidatorImpl.performUnconditionalRewrites(SqlValidatorImpl.java:1183) > ~[classes/:1.26.0] at > org.apache.calcite.sql.validate.SqlValidatorImpl.performUnconditionalRewrites(SqlValidatorImpl.java:1200) > ~[classes/:1.26.0] at > org.apache.calcite.sql.validate.SqlValidatorImpl.performUnconditionalRewrites(SqlValidatorImpl.java:1169) > ~[classes/:1.26.0] at > org.apache.calcite.sql.validate.SqlValidatorImpl.validateScopedExpression(SqlValidatorImpl.java:945) > ~[classes/:1.26.0] at > org.apache.calcite.sql.validate.SqlValidatorImpl.validate(SqlValidatorImpl.java:704) > ~[classes/:1.26.0] at > org.apache.flink.table.planner.calcite.FlinkPlannerImpl.org$apache$flink$table$planner$calcite$FlinkPlannerImpl$$validate(FlinkPlannerImpl.scala:178) > ~[classes/:?] at > org.apache.flink.table.planner.calcite.FlinkPlannerImpl.validate(FlinkPlannerImpl.scala:109) > ~[classes/:?] at > org.apache.flink.table.planner.operations.SqlToOperationConverter.convert(SqlToOperationConverter.java:241) > ~[classes/:?] at > org.apache.flink.table.planner.delegation.ParserImpl.parse(ParserImpl.java:106) > ~[classes/:?] at > org.apache.flink.table.client.gateway.local.LocalExecutor.parseStatement(LocalExecutor.java:172) > ~[classes/:?] ... 54 more {code} -- This message was sent by Atlassian Jira (v8.20.10#820010)