question Re: numeric check in hive in Archives of Support Questions (Read Only)

numeric check in hive

muthaiyaprabhu — Thu, 24 Aug 2017 22:52:42 GMT

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

Re: numeric check in hive

jvaria — Fri, 25 Aug 2017 04:37:56 GMT

@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

Re: numeric check in hive

Kasi — Wed, 18 Jul 2018 18:30:58 GMT

@Prabhu Muthaiyan , you can use rlike regex

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