You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@flink.apache.org by "Yubin Li (Jira)" <ji...@apache.org> on 2022/11/01 08:16:00 UTC
[jira] [Updated] (FLINK-29829) align explain results in different platforms
[ https://issues.apache.org/jira/browse/FLINK-29829?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Yubin Li updated FLINK-29829:
-----------------------------
Description:
Delete last line separator during explain results generation in design, but in fact, just delete the last character, it will result in the outputs in Windows has one more line than Linux.
{code:java}
//Windows
LegacySink(name=[`default_catalog`.`default_database`.`appendSink2`], fields=[a, b])
+- GroupWindowAggregate(groupBy=[id1], window=[SlidingGroupWindow('w$, rowtime, 6000, 12000)], select=[id1, LISTAGG(text, $f3) AS EXPR$1])
+- Exchange(distribution=[hash[id1]])
+- Calc(select=[id1, rowtime, text, '*' AS $f3])
+- Reused(reference_id=[1])
{code}
{code:java}
//linux
LegacySink(name=[`default_catalog`.`default_database`.`appendSink2`], fields=[a, b])
+- GroupWindowAggregate(groupBy=[id1], window=[SlidingGroupWindow('w$, rowtime, 6000, 12000)], select=[id1, LISTAGG(text, $f3) AS EXPR$1])
+- Exchange(distribution=[hash[id1]])
+- Calc(select=[id1, rowtime, text, '*' AS $f3])
+- Reused(reference_id=[1])
{code}
was:
Delete last line separator during explain results generation in design, but in fact, just delete the last character, it will result in results in the output in Windows has one more line than Linux.
{code:java}
//Windows
LegacySink(name=[`default_catalog`.`default_database`.`appendSink2`], fields=[a, b])
+- GroupWindowAggregate(groupBy=[id1], window=[SlidingGroupWindow('w$, rowtime, 6000, 12000)], select=[id1, LISTAGG(text, $f3) AS EXPR$1])
+- Exchange(distribution=[hash[id1]])
+- Calc(select=[id1, rowtime, text, '*' AS $f3])
+- Reused(reference_id=[1])
{code}
{code:java}
//linux
LegacySink(name=[`default_catalog`.`default_database`.`appendSink2`], fields=[a, b])
+- GroupWindowAggregate(groupBy=[id1], window=[SlidingGroupWindow('w$, rowtime, 6000, 12000)], select=[id1, LISTAGG(text, $f3) AS EXPR$1])
+- Exchange(distribution=[hash[id1]])
+- Calc(select=[id1, rowtime, text, '*' AS $f3])
+- Reused(reference_id=[1])
{code}
> align explain results in different platforms
> --------------------------------------------
>
> Key: FLINK-29829
> URL: https://issues.apache.org/jira/browse/FLINK-29829
> Project: Flink
> Issue Type: Bug
> Components: Table SQL / Planner
> Reporter: Yubin Li
> Priority: Major
>
> Delete last line separator during explain results generation in design, but in fact, just delete the last character, it will result in the outputs in Windows has one more line than Linux.
>
> {code:java}
> //Windows
> LegacySink(name=[`default_catalog`.`default_database`.`appendSink2`], fields=[a, b])
> +- GroupWindowAggregate(groupBy=[id1], window=[SlidingGroupWindow('w$, rowtime, 6000, 12000)], select=[id1, LISTAGG(text, $f3) AS EXPR$1])
> +- Exchange(distribution=[hash[id1]])
> +- Calc(select=[id1, rowtime, text, '*' AS $f3])
> +- Reused(reference_id=[1])
> {code}
>
>
> {code:java}
> //linux
> LegacySink(name=[`default_catalog`.`default_database`.`appendSink2`], fields=[a, b])
> +- GroupWindowAggregate(groupBy=[id1], window=[SlidingGroupWindow('w$, rowtime, 6000, 12000)], select=[id1, LISTAGG(text, $f3) AS EXPR$1])
> +- Exchange(distribution=[hash[id1]])
> +- Calc(select=[id1, rowtime, text, '*' AS $f3])
> +- Reused(reference_id=[1])
> {code}
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)