In Hive, unix_timestamp()'s return type is bigint. https://cwiki.apache.org/confluence/display/Hive/LanguageManual+UDF When we use unix timestamp as data, we always use it as Integer(or BigInt). I ...