I would like to query a hive table only for those rows that have coulmn1 as integer only. Due to some data corruption, without this check I am getting a lot of junk data(mix integer & letters), I would like to get rid of that data by applying something like "where column1 is INT" kind of condition, but I couldn't find anything like that in hive. Could anyone suggest how I could do it?
- can we add column type in where clause in a hive query? Mohit Durgapal
