When you the run the CALLS operator without excluding any columns from the display, we are capped at 104 characters at this time. If you hover over the SQL statement though you can see the full SQL statement as long as it is less than 256 characters.
Screenshot1:
In the above screenshot the SQL highlighted in
Red shows truncated output for the operator results. However when you hover over SQL statement you can see the complete SQL as highlighted in
Green.
The above is true only because the full SQL is less than 255 characters.
Now look at the SQL highlighted below
Screenshot2:
The above screenshot shows SQL that is result of the output is truncated at
104 characters but when you hover over the SQL statement you can see *more* of the characters but even that is truncated at
255 characters.
If you however do not want to hover over the SQL statement to look into the statement which is less than 255 but still not displayed completely then you need to exclude certain columns from call operator so we can display the statement without hovering (as long as it is less than 255 characters and more than 104 characters)
The below screenshot shows the same SQL which was truncated in Screenshot1 with excluding one column from display for the operator.
Screenshot3:
Currently there is no configuration setting accessible to use to control the length of the SQL statement that is displayed. There is an open bug to address the issue.
Bug 297442 - [Analysis Operator]: Ability to configure the analysis operator output sql column length to display the entire SQL