Does Cassandra allow user defined function in where clause?
<p>I created user defined function <code>fStringToDouble</code> which takes string as an argument and returns double. This user defined functions works fine in select statement.</p>

<pre><code>SELECT applieddatetime, fStringToDouble(variablevalue)  from my_table WHERE locationid='xyz' and applieddatetime &gt;= '2016-08-22' AND applieddatetime &lt; '2016-08-23' ;
</code></pre>

<p>When I put this user defined function in where clause , I get syntax error as <code>"no viable alternative at input"</code></p>

<pre><code>SELECT applieddatetime from my_table WHERE locationid='xyz' and applieddatetime &gt;= '2016-08-22' AND applieddatetime &lt; '2016-08-23'and fStringToDouble(variablevalue)&lt;6.0;
</code></pre>

<p>What is wrong with above query ? Is there any built in function to cast String to Double in Cassandra?</p>