Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

numeric check in hive

avatar

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

avatar
Contributor

@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

avatar
Contributor

@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

avatar
New Contributor

@Prabhu Muthaiyan , you can use rlike regex

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