Date add/subtract in cassandra/spark query
<p>I have a scenario where I need to join multiple tables and identify if the date + another integer column is greater than another date column.</p>

<pre><code>Select case when (manufacturedate + LeadTime &lt; DueDate) then numericvalue ((DueDate - manufacturepdate) + 1) else PartSource.EffLeadTime)
</code></pre>

<p>Is there a way to handle it in spark sql?</p>

<p>Thanks,
Ash</p>