title: how to resolve Arithmetic overflow error in Databricks SQL Editor
body: <p>In Databricks SQL editor , I am trying to get the SUM of few 'Bigint' and 'Double' data type columns of a table. But am getting below error.</p>
  <pre><code>Job aborted due to stage failure: Task 0 in stage 29.0 failed 4 times, most recent 
  failure: Lost task 0.3 in stage 29.0 (TID 2517) (10.128.2.66 executor 3): 
  org.apache.spark.SparkArithmeticException: [ARITHMETIC_OVERFLOW] long overflow. If 
  necessary set ansi_mode to &quot;false&quot; to bypass this error.
  </code></pre>
  <p>How to set ansi_mode from Databricks SQL editor?</p>
  <p>I tried below in SQL editor</p>
  <pre><code>SET spark.sql.ansi.enabled = false
  </code></pre>
  <p>Getting below error</p>
  <pre><code>Error running query: org.apache.spark.sql.AnalysisException: Configuration 
  spark.sql.ansi.enabled is not available.
  </code></pre>
  <p>How to resolve this Arithmetic overflow error in Databricks?</p>