Is there any way to check if a string is a number in Impala?
like is_numeric
is SQL?
Impala - Check if a string is a number
5.8k views Asked by M.C.G At
2
There are 2 answers
0

The 'regep_like' function is helpful here. For instance, the following will select integers:
select * from table where regexp_like(field,'^[[:digit:]]+$')
This did work for me: