If my source(oracle) have int or date type or any data type then same type should be in target(hive) in the same job.
want load metadata and data in same job
You need to load files in oracle source into the HDFS first and then you can use Hive to interpret such files as database files.
tSqoopImport calls Sqoop to transfer data from a relational database management system (RDBMS) such as Oracle into the Hadoop Distributed File System (HDFS).
For your hive server, you can create an external table into hive which points out a HDFS location or use thiveload, thiverow component.