sqoop import --connect jdbc:oracle:thin:@ORA_IP:ORA_PORT:ORA_SID
--username user123 --password passwd123 -table SCHEMA.TBL_2
--hcatalog-table tbl2 --hcatalog-database testdb --num-mappers 1
--split-by SOME_ID --columns col1,col2,col3,col4 --hive-drop-import-delims
--outdir /tmp/temp_table_loc --class-name "SqoopWithHCAT"
--null-string ""

<li>Details:^M
    <ul>^M
        <li>

sqoop import --connect jdbc:oracle:thin:@ORA_IP:ORA_PORT:ORA_SID
--username user123 --password passwd123 -table SCHEMA.TBL_2
--hcatalog-table tbl2 --hcatalog-database testdb --num-mappers 1
--split-by SOME_ID --columns col1,col2,col3,col4 --hive-drop-import-delims
--outdir /tmp/temp_table_loc --class-name "SqoopWithHCAT"
--null-string "" --map-column-java col4=String

sqoop import
--connect jdbc:oracle:thin:@ORA_IP:ORA_PORT:ORA_SID
--username 123
--password 123
--table SCHEMA.TBL_2
--hcatalog-table tbl2 --hcatalog-database testdb --num-mappers 1
--split-by SOME_ID --columns col1,col2,col3,col4
--hive-delims-replacement "anything"
--outdir /tmp/temp_table_loc --class-name "SqoopWithHCAT"
--null-string ""