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