[jira] [Updated] (FLINK-30025) table.execute().print() can only use the default max column width
[
https://issues.apache.org/jira/browse/FLINK-30025?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jing Ge updated FLINK-30025:
Description:
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_620x1q90.jpg?auth_bizType=%27IM%27=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:
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_620x1q90.jpg?auth_bizType=%27IM%27=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.
> table.execute().print() can only use the default max column width
> --
>
> 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
>
> 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_620x1q90.jpg?auth_bizType=%27IM%27=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)
[jira] [Updated] (FLINK-30025) table.execute().print() can only use the default max column width
[
https://issues.apache.org/jira/browse/FLINK-30025?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jing Ge updated FLINK-30025:
Description:
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_620x1q90.jpg?auth_bizType=%27IM%27=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:
"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.
> table.execute().print() can only use the default max column width
> --
>
> 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
>
> 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_620x1q90.jpg?auth_bizType=%27IM%27=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)
[jira] [Updated] (FLINK-30025) table.execute().print() can only use the default max column width
[ https://issues.apache.org/jira/browse/FLINK-30025?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jing Ge updated FLINK-30025: Description: "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:By default, the DEFAULT_MAX_COLUMN_WIDTH in PrintStyle is used now. It should be configurable. > table.execute().print() can only use the default max column width > -- > > 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 > > "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)
[jira] [Updated] (FLINK-30025) table.execute().print() can only use the default max column width
[ https://issues.apache.org/jira/browse/FLINK-30025?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated FLINK-30025: --- Labels: pull-request-available (was: ) > table.execute().print() can only use the default max column width > -- > > 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 > > 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)
