How to test isnumeric condition in hive?
<p>I have data ID column ,it contains both numbers and letters, I want only numeric IDs list, is there any inbuilt condition for the same, I want to cast data latter.
I know in SQL as </p>

<pre><code> 'CASE WHEN ISNUMERIC([id])=1 THEN CAST([id] as int) ELSE 0 END [ID]' 
</code></pre>

<p>what is the query in hive ? 
<br>Please help on this.</p>