Hi SohamHive Supports pretty much all the primitive data types including INT. For a detaild list please referhttps://cwiki.apache.org/confluence/display/Hive/Tutorial#Tutorial-PrimitiveTypesThe only draw back as in common is when you have the data type as String you cannot use it directly on Mathematical functions.Your requirement can easily be satisfied with a few date functions on String data it