[
https://issues.apache.org/jira/browse/FLINK-30025?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jing Ge updated FLINK-30025:
----------------------------
Description:
FLIP-279
[https://cwiki.apache.org/confluence/display/FLINK/FLIP-279+Unified+the+max+display+column+width+for+SqlClient+and+Table+APi+in+both+Streaming+and+Batch+execMode]
Background info:
table.execute().print() can only use the default max column width. When running
table API program "table.execute().print();", the columns with long string
value are truncated to 30 chars. E.g.,:
!https://static.dingtalk.com/media/lALPF6XTM7ZO1FXNASrNBEI_1090_298.png_620x10000q90.jpg?auth_bizType=%27IM%27&bizType=im|width=457,height=125!
I tried set the max width with:
tEnv.getConfig.getConfiguration.setInteger("sql-client.display.max-column-width",
100); It has no effect. How can I set the max-width?
Here is the example code:
val env = StreamExecutionEnvironment.getExecutionEnvironment
val tEnv = StreamTableEnvironment.create(env)
tEnv.getConfig.getConfiguration.setInteger("sql-client.display.max-column-width",
100)
val orderA = env
.fromCollection(Seq(Order(1L, "beer", 3), Order(1L,
"diaper-{-}{{-}}.diaper{{-}}{-}{-}.diaper{-}{-}{{-}}.diaper{{-}}{-}-.", 4),
Order(3L, "rubber", 2)))
.toTable(tEnv)
orderA.execute().print()
"sql-client.display.max-column-width" seems only work in cli: SET
'sql-client.display.max-column-width' = '40';
While using Table API, by default, the DEFAULT_MAX_COLUMN_WIDTH in PrintStyle
is used now. It should be configurable.
was:
table.execute().print() can only use the default max column width. When running
table API program "table.execute().print();", the columns with long string
value are truncated to 30 chars. E.g.,:
!https://static.dingtalk.com/media/lALPF6XTM7ZO1FXNASrNBEI_1090_298.png_620x10000q90.jpg?auth_bizType=%27IM%27&bizType=im|width=457,height=125!
I tried set the max width with:
tEnv.getConfig.getConfiguration.setInteger("sql-client.display.max-column-width",
100); It has no effect. How can I set the max-width?
Here is the example code:
val env = StreamExecutionEnvironment.getExecutionEnvironment
val tEnv = StreamTableEnvironment.create(env)
tEnv.getConfig.getConfiguration.setInteger("sql-client.display.max-column-width",
100)
val orderA = env
.fromCollection(Seq(Order(1L, "beer", 3), Order(1L,
"diaper--{-}.diaper{-}-{-}.diaper{-}-{-}.diaper{-}--.", 4), Order(3L, "rubber",
2)))
.toTable(tEnv)
orderA.execute().print()
"sql-client.display.max-column-width" seems only work in cli: SET
'sql-client.display.max-column-width' = '40';
While using Table API, by default, the DEFAULT_MAX_COLUMN_WIDTH in PrintStyle
is used now. It should be configurable.
> Unified the max display column width for SqlClient and Table APi in both
> Streaming and Batch execMode
> -----------------------------------------------------------------------------------------------------
>
> Key: FLINK-30025
> URL: https://issues.apache.org/jira/browse/FLINK-30025
> Project: Flink
> Issue Type: Improvement
> Components: Table SQL / API
> Affects Versions: 1.16.0, 1.15.2
> Reporter: Jing Ge
> Assignee: Jing Ge
> Priority: Minor
> Labels: pull-request-available
>
> FLIP-279
> [https://cwiki.apache.org/confluence/display/FLINK/FLIP-279+Unified+the+max+display+column+width+for+SqlClient+and+Table+APi+in+both+Streaming+and+Batch+execMode]
>
> Background info:
> table.execute().print() can only use the default max column width. When
> running table API program "table.execute().print();", the columns with long
> string value are truncated to 30 chars. E.g.,:
> !https://static.dingtalk.com/media/lALPF6XTM7ZO1FXNASrNBEI_1090_298.png_620x10000q90.jpg?auth_bizType=%27IM%27&bizType=im|width=457,height=125!
> I tried set the max width with:
> tEnv.getConfig.getConfiguration.setInteger("sql-client.display.max-column-width",
> 100); It has no effect. How can I set the max-width?
> Here is the example code:
> val env = StreamExecutionEnvironment.getExecutionEnvironment
> val tEnv = StreamTableEnvironment.create(env)
> tEnv.getConfig.getConfiguration.setInteger("sql-client.display.max-column-width",
> 100)
> val orderA = env
> .fromCollection(Seq(Order(1L, "beer", 3), Order(1L,
> "diaper-{-}{{-}}.diaper{{-}}{-}{-}.diaper{-}{-}{{-}}.diaper{{-}}{-}-.", 4),
> Order(3L, "rubber", 2)))
> .toTable(tEnv)
> orderA.execute().print()
>
> "sql-client.display.max-column-width" seems only work in cli: SET
> 'sql-client.display.max-column-width' = '40';
> While using Table API, by default, the DEFAULT_MAX_COLUMN_WIDTH in PrintStyle
> is used now. It should be configurable.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
