07 using sqoop to import & export data
DESCRIPTION
Using Sqoop to Import & Export DataTRANSCRIPT
1Copyright ©2012 Cloudwick Technologies
Copyright ©2012 Cloudwick Technologies2
Copyright ©2012 Cloudwick Technologies3
• Flume provides a method to import data into HDFS as it is generated– Rather than batch-processing the data later– For example, log files from a Web server
• Sqoop provides a method to import data from tables in a relational database into HDFS– Does this very efficiently via a Map-only MapReduce job– Populate database tables from files in HDFS
Copyright ©2012 Cloudwick Technologies4
Copyright ©2012 Cloudwick Technologies5
Copyright ©2012 Cloudwick Technologies6
Copyright ©2012 Cloudwick Technologies7
Copyright ©2012 Cloudwick Technologies8
Copyright ©2012 Cloudwick Technologies9
Copyright ©2012 Cloudwick Technologies10
Copyright ©2012 Cloudwick Technologies11
Copyright ©2012 Cloudwick Technologies12
Copyright ©2012 Cloudwick Technologies13
Copyright ©2012 Cloudwick Technologies14
Copyright ©2012 Cloudwick Technologies15
Copyright ©2012 Cloudwick Technologies16
Demo
Copyright ©2012 Cloudwick Technologies17