Purpose: Sqoop is a command-line interface application for transferring data between relational databases and Hadoop.
Home Page: https://sqoop.apache.org/
Documentation: https://sqoop.apache.org/docs/1.99.7/index.html
Related resources to learn: https://cloudxlab.com/assessment/playlist-intro/13/sqoop?course_id=1&playlist_id=13
How to get started:
In the web console tab on the right side of the screen, get help with sqoop using:
sqoop help
To import data from MySQL into HDFS using Sqoop, use:
sqoop import --connect jdbc:mysql://172.31.13.154/sqoopex --table widgets -m 2 --username sqoopuser -P --split-by id
To import data from MySQL into Hive using Sqoop, use:
sqoop import --connect jdbc:mysql://172.31.13.154/sqoopex --table widgets -m 2 --hive-import --username sqoopuser -P --hive-database sqoop_testing
To import data from MySQL into HBase using Sqoop, use:
sqoop import --connect jdbc:mysql://172.31.13.154/sqoopex --table widgets --hbase-table 'widgets' --column-family cf2 --username sqoopuser -P --hbase-create-table --columns id,widget_name,price --hbase-row-key 'widget_name' -m 1
To export data from Hive to MySQL using Sqoop, use:
sqoop export --connect jdbc:mysql://172.31.13.154/sqoopex -m 1 --table sales_test --export-dir /apps/hive/warehouse/sales_test --input-fields-terminated-by ',' --username sqoopuser -P
Taking you to the next exercise in seconds...
Want to create exercises like this yourself? Click here.
No hints are availble for this assesment
Answer is not availble for this assesment
Loading comments...