Sqoop import hive datetime conversion


#1

when i import orders table in retail_db, order_date column is converted from datetime to long datatype.
why is that so , according to my understanding it should be converted to string datatype…
when we want to extract datetime , why we want to divide it by 1000 , normally unixtimestamp value is in seconds