Re: How to configure column width in Flink SQL client?
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 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 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 > > >
Re: How to configure column width in Flink SQL client?
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 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
Re: How to configure column width in Flink SQL client?
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 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 >
How to configure column width in Flink SQL client?
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