Support Questions
Find answers, ask questions, and share your expertise

numeric check in hive

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

1 ACCEPTED SOLUTION

Explorer

@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

View solution in original post

2 REPLIES 2

Explorer

@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

New Contributor

@Prabhu Muthaiyan , you can use rlike regex

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