Hi Ashok, Not sure what is MVS, but considering it some sort of database, as long as ports are open/ACL's are established, using sqoop to have data on hdfs is easy as a command - sqoop import -D mapred.job.queue.name=<your-queue-name> --connect jdbc:oracle:thin:@//<your-db>:1521/<your-db-sid> --username <your-username> --table <your-table> --target-dir <your-hdfs-dir> --password <your-pwd> -m 1
Thanks Rekha On 27/08/12 3:39 PM, "ashok.sa...@wipro.com" <ashok.sa...@wipro.com> wrote: >Can i load data from MVS to hadoop/hive by using sqoop.If yes please help >me with the steps and if no, please suggest me some other alternatives. >Need Urgent help. > >Thanks in Advance. >The information contained in this electronic message and any attachments >to this message are intended for the exclusive use of the addressee(s) >and may contain proprietary, confidential or privileged information. If >you are not the intended recipient, you should not disseminate, >distribute or copy this e-mail. Please notify the sender immediately and >destroy all copies of this message and any attachments. > >WARNING: Computer viruses can be transmitted via email. The recipient >should check this email and any attachments for the presence of viruses. >The company accepts no liability for any damage caused by any virus >transmitted by this email. > >www.wipro.com
