Sqoop

41.Give a Sqoop command to import all the records from employee table divided into groups of records by the values in the column department_id. $ sqoop import –connect jdbc:mysql://db.foo.com/corp –table EMPLOYEES \ –split-by dept_id (217)

Read More

31.In a sqoop import command you have mentioned to run 8 parallel Mapreduce task but sqoop runs only 4. What can be the reason? The Mapreduce cluster is configured to run 4 parallel tasks. So the sqoop command must have…

Read More

21.How do you clear the data in a staging table before loading it by Sqoop? By specifying the –clear-staging-table option we can clear the staging table before it is loaded. This can be done again and again till we get…

Read More

11.How can you avoid importing tables one-by-one when importing a large number of tables from a database? Using the command sqoop import-all-tables –connect –usrename –password –exclude-tables table1,table2 .. This will import all the tables except the ones mentioned in the…

Read More

1.What is the role of JDBC driver in a Sqoop set up? To connect to different relational databases sqoop needs a connector. Almost every DB vendor makes this connecter available as a JDBC driver which is specific to that DB.…

Read More