Impala - Check if a string is a number

Question

Is there any way to check if a string is a number in Impala? like is_numeric is SQL?

Answer 1

This did work for me:

select
  case
    when cast(mycol as double) is not null
    then 'numeric'
    else 'string'
  end
from mytable

Answer 2

The 'regep_like' function is helpful here. For instance, the following will select integers:

select * from table where regexp_like(field,'^[[:digit:]]+$')