Tested using " sqoop-1.4.5-SNAPSHOT.bin__hadoop-2.0.4-alpha.tar.gz " on CDH4 (melhadoop01).
Unzipped the file to a folder and
Downloaded and Copied odbc6.jar file as mentioned in the user guide and copied to the relevant folder.
Modified path of the Sqoop to the current one (sqoop 1.4.5).
Ran basic import and Export (user creates export table)on few different tables using melintdbw90a db (tfh_userr1).
Since Davids automation test covers import feature, manual testing was mainly focused on Export feature.
Ran all the 15 export cases from Guy Ley Mar document on SASDB01.
All the export cases passed except Case 13, Raised a bug.
Enabled trace via oroop_template.xml files and tested these
Confirmed trace are written on Oracle db after running a job, "Oaoop.block.allocation", "oraoop.table.import.where.clause.location:SPLIT".
Tested Basic import and export on RAC instance melvsxspotl133:1521/spotl133 (10.20.29.15). Confirmed Exported data is correct.
Checked the User guide (html) ,Noticed few Sqoop commands in the examples are missing --direct switch. Apart from this did not notice any major issues.