Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Page properties



Please keep the discussion on the mailing list rather than commenting on the wiki (wiki discussions get unwieldy fast).

...

When running table API program "table.execute().print();", the columns with long string value are truncated to 30 chars, e.g.,:

Image Added

After setting the max width with: tEnv.getConfig.getConfiguration.setInteger("sql-client.display.max-column-width", 100); It has no effect.  

...

It is not configurable. By default, PrintStyle.DEFAULT_MAX_COLUMN_WIDTHis used. [1]

Test didn't cover case with text whose length exceeds PrintStyle.DEFAULT_MAX_COLUMN_WIDTH, i.e. 30. [2]


Job running in streaming execution mode with SqlClient

...

It only works for jobs running in streaming execution mode. There is a bug in documentation [23].


Job running in batch execution mode with Table API

It is not configurable. By default, PrintStyle.DEFAULT_MAX_COLUMN_WIDTHis used. [24]

 

Job running in streaming execution mode with Table API

Same as in batch execution mode, it is not configurable. By default, PrintStyle.DEFAULT_MAX_COLUMN_WIDTHis used. [34]

Conceptually, there is no difference between printing table results of jobs running in batch and streaming exec mode. The snapshot at the calling time will be printed. [45]

Summary

Topics mentioned above are mixed with layered and orthogonal issues. In order to provide a clear big picture, all of them will be summarized in the following table:

...



Deprecated: sql-client.display.max-column-width, default value is 30

table.display.max-column-width, default value is 30

sqlclient

Streaming

Changes will be forwarded to table.display.max-column-width

Text longer than the value will be truncated and replaced with “...”

sqlclient

Batch

No effect. 

Changes will be forwarded to table.display.max-column-width with the default value 30 will be used

Text longer than the value will be truncated and replaced with “...”

Table API

Streaming

No effect. 

table.display.max-column-width with the default value 30 will be used

Text longer than the value will be truncated and replaced with “...”

Table API

Batch

No effect. 

table.display.max-column-width with the default value 30 will be used

Text longer than the value will be truncated and replaced with “...”

...

[1] https://github.com/apache/flink/blob/06ba29458536a75f4c8d78f41452b22bf6cc7fe7/flink-table/flink-sql-client/src/main/java/org/apache/flink/table/client/cli/CliTableauResultView.java#L129

[2] https://github.com/apache/flink/blob/06ba29458536a75f4c8d78f41452b22bf6cc7fe7/flink-table/flink-sql-client/src/test/java/org/apache/flink/table/client/cli/CliTableauResultViewTest.java#L149

[3] https://nightlies.apache.org/flink/flink-docs-master/docs/dev/table/sqlclient/#sql-client-display-max-column-width

[34] https://github.com/apache/flink/blob/06ba29458536a75f4c8d78f41452b22bf6cc7fe7/flink-table/flink-table-api-java/src/main/java/org/apache/flink/table/api/internal/TableEnvironmentImpl.java#L929

[45] https://github.com/apache/flink/blob/8b4cb7583d509898b09782bbd4fb06388a219efe/flink-table/flink-table-api-java/src/main/java/org/apache/flink/table/api/internal/TableResultImpl.java#L152