https://community.cloudera.com/t5/Support-Questions/Data-Type-Validation-in-Hive/m-p/143250#M105839 <P>With Hive what you can do is reading those fields as string and validate them through regexp. Otherwise, if you are sure that you don't have NULL values, you can simply define your schema and if a int field is NULL, this means that it is not properly formatted.</P> Thu, 12 May 2016 03:49:15 GMT mgaido 2016-05-12T03:49:15Z