Dashboard errors

After the data is extracted locally, create a dashboard, add component with the corresponding data. Preview the dashboard and report the following errors:

Job aborted due to stage failure: Total size of serialized results of 154 tasks (1026.5 MB) is bigger than spark.driver.maxResultSize (1024.0 MB)

3.1.2 Cause analysis

This error is related to spark driver. Spark 1.2 adds a new feature to limit the amount of data that can be returned to the driver. When the data is too large during query, the protection mechanism will be triggered.

That is, the amount of data queried is greater than the default maximum returned data amount spark.driver.maxresultsize set by spark.

3.1.3 Solution

Add parameters to chart FINE_CONF_ENTITY DistributedOptimizationConfig.spiderConfig.spark_driver_maxResultSize, and set the value of this parameter to the appropriate maximum data size.

Note: the value here cannot be too large, which will lead to memory overflow.

3.2 sql{...}is wrong, please check

Open real-time data, directly connect to the database, create dashboard, preview the data, and then report an error:

The SQL：{...}is wrong, please check...

3.2.2 Cause analysis

This error is caused by sending SQL to the database during dashboard preview. For the error reported by the database, you need to adjust the data according to the error reason after the feedback, and then preview the dashboard again.

3.2.3 Solution

For example, the error in the above example is Data conversion error converting “No”. For this error, we can delete the "No" field, or adjust the field type, and then preview the dashboard again.