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 …
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 …
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. …
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 …
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 …
