Impala - Check if a string is a number

Question

5.8k views Asked by M.C.G At 27 June 2018 at 19:36

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

There are 2 answers

**M.C.G** · Answer 1 · 2018-06-27T20:13:49+00:00

M.C.G On 27 June 2018 at 20:13

This did work for me:

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

**adam.r** · Answer 2 · 2022-02-07T15:05:32+00:00

adam.r On 07 February 2022 at 15:05

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

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