[jira] [Commented] (FLINK-33233) Null point exception when non-native udf used in join condition
[ https://issues.apache.org/jira/browse/FLINK-33233?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17810188#comment-17810188 ] luoyuxia commented on FLINK-33233: -- 1.17: https://github.com/apache/flink/commit/44a697c2537de02b96ca1044498e3f930dd6fdc7 1.18:https://github.com/apache/flink/commit/369fae70399798c1afa5041dec02d666b6d98008 > Null point exception when non-native udf used in join condition > --- > > Key: FLINK-33233 > URL: https://issues.apache.org/jira/browse/FLINK-33233 > Project: Flink > Issue Type: Bug > Components: Connectors / Hive >Affects Versions: 1.17.0 >Reporter: yunfan >Assignee: yunfan >Priority: Major > Labels: pull-request-available > Fix For: 1.19.0 > > > Any non-native udf used in hive-parser join condition. > It will caused NullPointException. > It can reproduced by follow code by adding this test to > {code:java} > org.apache.flink.connectors.hive.HiveDialectQueryITCase{code} > > {code:java} > // Add follow code to org.apache.flink.connectors.hive.HiveDialectQueryITCase > @Test > public void testUdfInJoinCondition() throws Exception { > List result = CollectionUtil.iteratorToList(tableEnv.executeSql( > "select foo.y, bar.I from bar join foo on hiveudf(foo.x) = bar.I > where bar.I > 1").collect()); > assertThat(result.toString()) > .isEqualTo("[+I[2, 2]]"); > } {code} -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Commented] (FLINK-33233) Null point exception when non-native udf used in join condition
[ https://issues.apache.org/jira/browse/FLINK-33233?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17808563#comment-17808563 ] yunfan commented on FLINK-33233: [~luoyuxia] [~mapohl] Hello. I have submitted the PR which back port to release-1.18 and release-1.17 > Null point exception when non-native udf used in join condition > --- > > Key: FLINK-33233 > URL: https://issues.apache.org/jira/browse/FLINK-33233 > Project: Flink > Issue Type: Bug > Components: Connectors / Hive >Affects Versions: 1.17.0 >Reporter: yunfan >Assignee: yunfan >Priority: Major > Labels: pull-request-available > Fix For: 1.19.0 > > > Any non-native udf used in hive-parser join condition. > It will caused NullPointException. > It can reproduced by follow code by adding this test to > {code:java} > org.apache.flink.connectors.hive.HiveDialectQueryITCase{code} > > {code:java} > // Add follow code to org.apache.flink.connectors.hive.HiveDialectQueryITCase > @Test > public void testUdfInJoinCondition() throws Exception { > List result = CollectionUtil.iteratorToList(tableEnv.executeSql( > "select foo.y, bar.I from bar join foo on hiveudf(foo.x) = bar.I > where bar.I > 1").collect()); > assertThat(result.toString()) > .isEqualTo("[+I[2, 2]]"); > } {code} -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Commented] (FLINK-33233) Null point exception when non-native udf used in join condition
[ https://issues.apache.org/jira/browse/FLINK-33233?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17804939#comment-17804939 ] luoyuxia commented on FLINK-33233: -- [~mapohl] Thanks for reminder. Haven't been aware of it. [~yunfanfight...@foxmail.com] Could you please back port to 1.17, 1.18? > Null point exception when non-native udf used in join condition > --- > > Key: FLINK-33233 > URL: https://issues.apache.org/jira/browse/FLINK-33233 > Project: Flink > Issue Type: Improvement > Components: Connectors / Hive >Affects Versions: 1.17.0 >Reporter: yunfan >Assignee: yunfan >Priority: Major > Labels: pull-request-available > Fix For: 1.19.0 > > > Any non-native udf used in hive-parser join condition. > It will caused NullPointException. > It can reproduced by follow code by adding this test to > {code:java} > org.apache.flink.connectors.hive.HiveDialectQueryITCase{code} > > {code:java} > // Add follow code to org.apache.flink.connectors.hive.HiveDialectQueryITCase > @Test > public void testUdfInJoinCondition() throws Exception { > List result = CollectionUtil.iteratorToList(tableEnv.executeSql( > "select foo.y, bar.I from bar join foo on hiveudf(foo.x) = bar.I > where bar.I > 1").collect()); > assertThat(result.toString()) > .isEqualTo("[+I[2, 2]]"); > } {code} -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Commented] (FLINK-33233) Null point exception when non-native udf used in join condition
[ https://issues.apache.org/jira/browse/FLINK-33233?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17804607#comment-17804607 ] Matthias Pohl commented on FLINK-33233: --- Out of curiosity: Is this really an improvement? It sounds more like a bug to me. If that's the case, it might be worth backporting it to 1.18 and 1.17 as well (since the affected version is stated as 1.17.0 in this Jira issue). [~luoyuxia] [~yunfanfight...@foxmail.com] WDYT? > Null point exception when non-native udf used in join condition > --- > > Key: FLINK-33233 > URL: https://issues.apache.org/jira/browse/FLINK-33233 > Project: Flink > Issue Type: Improvement > Components: Connectors / Hive >Affects Versions: 1.17.0 >Reporter: yunfan >Assignee: yunfan >Priority: Major > Labels: pull-request-available > Fix For: 1.19.0 > > > Any non-native udf used in hive-parser join condition. > It will caused NullPointException. > It can reproduced by follow code by adding this test to > {code:java} > org.apache.flink.connectors.hive.HiveDialectQueryITCase{code} > > {code:java} > // Add follow code to org.apache.flink.connectors.hive.HiveDialectQueryITCase > @Test > public void testUdfInJoinCondition() throws Exception { > List result = CollectionUtil.iteratorToList(tableEnv.executeSql( > "select foo.y, bar.I from bar join foo on hiveudf(foo.x) = bar.I > where bar.I > 1").collect()); > assertThat(result.toString()) > .isEqualTo("[+I[2, 2]]"); > } {code} -- This message was sent by Atlassian Jira (v8.20.10#820010)