hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mohit Durgapal <durgapalmo...@gmail.com>
Subject can we add column type in where clause in a hive query?
Date Wed, 02 Sep 2015 11:09:14 GMT
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?

Mime
View raw message