ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Databricks Spark Driver error with Alteryx Designer

Matt7RS
アトム

Hello, have any of you encountered this error? 

Error: Data Stream Out (11): Error SQLExecute: [Simba][Hardy] (35) Error from server: error code: '0' error message: 'org.apache.hive.service.cli.HiveSQLException: Error running query: org.apache.spark.SparkException: Job aborted due to stage failure: Total size of serialized results of 8 tasks (4.1 GiB) is bigger than spark.driver.maxResultSize 4.0 GiB.
at org.apache.spark.sql.hive.thriftserver.HiveThriftServerErrors$.runningQueryError(HiveThriftServerErrors.scala:48)
at org.apache.spark.sql.hive.thriftserver.SparkExecuteStatementOperation.$anonfun$execute$1(SparkExecuteStatementOperation.scala:611)
at scala.runtime.java8.JFunction0$mcV$sp.apply(JFunction0$mcV$sp.java:23)
at com.databricks.unity.EmptyHandle$.runWith(UCSHandle.scala:124)
at org.apache.spark.sql.hive.thriftserver.SparkExecuteStatementOperation.org$apache$spark$sql$hive$thriftserver$SparkExecuteStatementOperation$$execute(SparkExecuteStatementOperation.scala:501)
at org.apache.spark.sql.hive.thriftserver.SparkExecuteStatementOperation$$anon$2$$anon$3.$anonfun$run$2(SparkExecuteState

 

I am trying to run a delta table in databricks using the Simba ODBC connector in Alteryx but it seems the size of the results are too high for the spark driver. I wasnt sure if the spark driver needs to be set at a higher size capacity to allow the total number of tasks.  

 

 

2件の返信2
apathetichell
アルクトゥルス

https://kb.databricks.com/jobs/job-fails-maxresultsize-exception.html

 

talk to your DB admin - this is a spark cluster setting vs an Odbc/Alteryx setting.

apathetichell
アルクトゥルス

Can you confirm if this worked?

ラベル
トップのソリューション投稿者