@saranvisa   Already tried using the --query. cast the column as timestamp but still converted TIMESTAMP to BIGINT in the HIVE table.   Here's my query: sqoop import \ --connect "jdbc:oracle:thin:@192.168.1.17:1521:XE" \ --username "xxxxx" \ --password-file /user/cloudera/credentials/ora.password \ --as-parquetfile \ --hive-import \ --hive-overwrite \ --target-dir /user/cloudera/oracle \ --compression-codec snappy \ --query "select EMPLOYEE_ID, START_DATE, END_DATE, JOB_ID, DEPARTMENT_ID, cast(TSTAMP as TIMESTAMP) from SQOOPDB.JOB_HISTORY where \$CONDITIONS" \ --hive-table job_history9 \ --hive-database oracle \ -m 1 ... View more