You can translate the question and the replies:

Querry execution return error

Hi I just strart testing denodo Sandbox free trial but when executing some querry its return error DataBriks.historical_store_sales Finished with error: Error executing query. Total time 92.279 seconds. HISTORICAL_STORE_SALES [BASE] [ERROR] HISTORICAL_STORE_SALES [JDBC WRAPPER] [ERROR] HISTORICAL_STORE_SALES#0 [JDBC ROUTE] [ERROR] Received exception with message '[Simba][SparkJDBCDriver](500051) ERROR processing query/statement. Error Code: 0, SQL state: Error running query: org.apache.spark.SparkException: Job aborted due to stage failure: Total size of serialized results of 43 tasks (8.1 GB) is bigger than spark.driver.maxResultSize (8.0 GB), Query: SELECT * FROM `default`.`historical_store_sales` `t0`.' I already put limit of 100 records for the query
user
25-03-2020 10:50:54 -0400

1 Answer

Hi, When running this query, you also need to check the “Stop query when the limit is reached” box in addition to limiting rows. You can find this check box in the execution panel of the base view below the limit rows option. Also, you can find this check box in the VQL shell beside the limit row option if you are running your query in the VQL shell. Hope it helps!
Denodo Team
26-03-2020 10:30:07 -0400
You must sign in to add an answer. If you do not have an account, you can register here