An Error Is Reported When the SQL Job Result Is Previewed: The Preview Result Content Exceeds the Preview Threshold

Symptom

When a SQL job is executed, the job result fails to be previewed because the query result is too large.

Root Cause Analysis

If the job result fails to be obtained, the interface throws runException. The length of the parsed input exceeds the maximum number of characters defined in the parser settings.

Solution

You can export the job results to a specified bucket and then download the job results from the OBS bucket.

You can export job results on the SQL Jobs page or SQL Editor page.

• SQL Jobs page: In the navigation pane on the left, choose Job Management > SQL Jobs. On the displayed page, locate the row containing a desired job, click More in the Operation column, and select Export Result.
• SQL Editor page: In the navigation pane on the left, choose SQL Editor. On the displayed page, once query statements are successfully executed, click next to the View Result tab to export job results.

• If there are no numerical columns in the query results, job results cannot be exported.
• Ensure that the user who exports job results has the read and write permissions on the OBS bucket.