How to configure column width in Flink SQL client?

[Svend]

Hi everyone,

When using the Flink SQL client and displaying results interactively, it seems the values of any column wider than 24 characters is truncated, which is indicated by a '~' character, e.g. the "member_user_id" below:

```

SELECT

  metadata.true_as_of_timestamp_millis,

  member_user_id,

  membership_updated.new_status.updated_value

FROM fandom_members_events

WHERE

   group_id = '91170c98-2cc5-4935-9ea6-12b72d32fb3c'

true_as_of_timestamp_mil~            member_user_id             updated_value

             1622811665919 45ca821f-c0fc-4114-bef8-~                    (NULL)

             1622811665919 45ca821f-c0fc-4114-bef8-~                    JOINED

             1622118951005 b4734391-d3e1-417c-ad92-~                    (NULL)

...

```

Is there a way to configure the displayed width? I didn't find any parameter for this in https://ci.apache.org/projects/flink/flink-docs-release-1.13/docs/dev/table/sqlclient/#sql-client-startup-options

Thanks a lot in advance!

Svend

[Ingo Bürk]

Hi Svend,

unfortunately the column width in the SQL client cannot currently be configured.

Regards

Ingo

On Mon, Jun 7, 2021 at 4:19 PM Svend <[hidden email]> wrote:

Hi everyone,

When using the Flink SQL client and displaying results interactively, it seems the values of any column wider than 24 characters is truncated, which is indicated by a '~' character, e.g. the "member_user_id" below:

```

SELECT

  metadata.true_as_of_timestamp_millis,

  member_user_id,

  membership_updated.new_status.updated_value

FROM fandom_members_events

WHERE

   group_id = '91170c98-2cc5-4935-9ea6-12b72d32fb3c'

true_as_of_timestamp_mil~            member_user_id             updated_value

             1622811665919 45ca821f-c0fc-4114-bef8-~                    (NULL)

             1622811665919 45ca821f-c0fc-4114-bef8-~                    JOINED

             1622118951005 b4734391-d3e1-417c-ad92-~                    (NULL)

...

```

Is there a way to configure the displayed width? I didn't find any parameter for this in https://ci.apache.org/projects/flink/flink-docs-release-1.13/docs/dev/table/sqlclient/#sql-client-startup-options

Thanks a lot in advance!

Svend

[Svend]

Thanks for the feed-back Ingo,

Do you think a PR would be welcome to make that parameter configurable? At the place where I work, UUID are often used as column values and they are 36 character longs => very often a very useful piece of information to us is not readable.

I had a quick look, the max width seems to be defined in [1], and used in various places like [2] and [3]. Should I open a Jira to discuss this and cc you in it?

Cheers,

Svend

[1] https://github.com/apache/flink/blob/6d8c02f90a5a3054015f2f1ee83be821d925ccd1/flink-table/flink-table-common/src/main/java/org/apache/flink/table/utils/PrintUtils.java#L74

[2] https://github.com/apache/flink/blob/6d8c02f90a5a3054015f2f1ee83be821d925ccd1/flink-table/flink-table-common/src/main/java/org/apache/flink/table/utils/PrintUtils.java#L102

[3] https://github.com/apache/flink/blob/6d8c02f90a5a3054015f2f1ee83be821d925ccd1/flink-table/flink-sql-client/src/main/java/org/apache/flink/table/client/cli/CliTableauResultView.java#L143

On Tue, 8 Jun 2021, at 7:34 AM, Ingo Bürk wrote:

Hi Svend,

unfortunately the column width in the SQL client cannot currently be configured.

Regards

Ingo

On Mon, Jun 7, 2021 at 4:19 PM Svend <[hidden email]> wrote:

Hi everyone,

When using the Flink SQL client and displaying results interactively, it seems the values of any column wider than 24 characters is truncated, which is indicated by a '~' character, e.g. the "member_user_id" below:

```

SELECT

  metadata.true_as_of_timestamp_millis,

  member_user_id,

  membership_updated.new_status.updated_value

FROM fandom_members_events

WHERE

   group_id = '91170c98-2cc5-4935-9ea6-12b72d32fb3c'

true_as_of_timestamp_mil~            member_user_id             updated_value

             1622811665919 45ca821f-c0fc-4114-bef8-~                    (NULL)

             1622811665919 45ca821f-c0fc-4114-bef8-~                    JOINED

             1622118951005 b4734391-d3e1-417c-ad92-~                    (NULL)

...

```

Is there a way to configure the displayed width? I didn't find any parameter for this in https://ci.apache.org/projects/flink/flink-docs-release-1.13/docs/dev/table/sqlclient/#sql-client-startup-options

Thanks a lot in advance!

Svend

[Ingo Bürk]

Hi Svend,

I think it definitely makes sense to open a JIRA issue for it to discuss it also with the people working on the SQL client. Thanks for taking care of this!

Regards

Ingo

On Wed, Jun 9, 2021 at 7:25 AM Svend <[hidden email]> wrote:

Thanks for the feed-back Ingo,

Do you think a PR would be welcome to make that parameter configurable? At the place where I work, UUID are often used as column values and they are 36 character longs => very often a very useful piece of information to us is not readable.

I had a quick look, the max width seems to be defined in [1], and used in various places like [2] and [3]. Should I open a Jira to discuss this and cc you in it?

Cheers,

Svend

[1] https://github.com/apache/flink/blob/6d8c02f90a5a3054015f2f1ee83be821d925ccd1/flink-table/flink-table-common/src/main/java/org/apache/flink/table/utils/PrintUtils.java#L74

[2] https://github.com/apache/flink/blob/6d8c02f90a5a3054015f2f1ee83be821d925ccd1/flink-table/flink-table-common/src/main/java/org/apache/flink/table/utils/PrintUtils.java#L102

[3] https://github.com/apache/flink/blob/6d8c02f90a5a3054015f2f1ee83be821d925ccd1/flink-table/flink-sql-client/src/main/java/org/apache/flink/table/client/cli/CliTableauResultView.java#L143

On Tue, 8 Jun 2021, at 7:34 AM, Ingo Bürk wrote:

Hi Svend,

unfortunately the column width in the SQL client cannot currently be configured.

Regards

Ingo

On Mon, Jun 7, 2021 at 4:19 PM Svend <[hidden email]> wrote:

Hi everyone,

When using the Flink SQL client and displaying results interactively, it seems the values of any column wider than 24 characters is truncated, which is indicated by a '~' character, e.g. the "member_user_id" below:

```

SELECT

  metadata.true_as_of_timestamp_millis,

  member_user_id,

  membership_updated.new_status.updated_value

FROM fandom_members_events

WHERE

   group_id = '91170c98-2cc5-4935-9ea6-12b72d32fb3c'

true_as_of_timestamp_mil~            member_user_id             updated_value

             1622811665919 45ca821f-c0fc-4114-bef8-~                    (NULL)

             1622811665919 45ca821f-c0fc-4114-bef8-~                    JOINED

             1622118951005 b4734391-d3e1-417c-ad92-~                    (NULL)

...

```

Is there a way to configure the displayed width? I didn't find any parameter for this in https://ci.apache.org/projects/flink/flink-docs-release-1.13/docs/dev/table/sqlclient/#sql-client-startup-options

Thanks a lot in advance!

Svend