[
https://issues.apache.org/jira/browse/FLINK-30025?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jing Ge resolved FLINK-30025.
-----------------------------
Resolution: Fixed
> 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: Major
> Labels: pull-request-available
> Fix For: 1.18.0
>
>
> 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)
