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 Continue Reading »
Home / Interview Questions and Answers / Technical Interview Questions and Answers / Archive by Category "Sqoop"
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 Continue Reading »
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. Continue Reading »
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 Continue Reading »
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 Continue Reading »