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 <stream...@svend.xyz> 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 <stream...@svend.xyz> 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
>
>
>

Reply via email to