numeric check in hive

[#1]

Hive: I have a column name(varchar), table has now both alphabets and pure numeric values. I want to count the column name that has only numeric values

[#2 · Accepted solution]

@Prabhu Muthaiyan You can write query similar to this to get count of numberic values:

select count(*) from <tableName> where cast(<colName> as double) is not NULL

[#3]

@Prabhu Muthaiyan , you can use rlike regex

select count(*) from <tableName> where <colName>  not rlike '[^0-9]' ;