Related InterviewSolutions

• Where can the metastore database be hosted?
• Which database the sqoop metastore runs on?
• Give the sqoop command to see the content of the job named myjob?
• How can you see the list of stored jobs in sqoop metastore?
• What is the purpose of sqoop-merge?
• What is a sqoop metastore?
• Give a command to execute a stored procedure named proc1 which exports data to from MySQL db named DB1 into a HDFS directory named Dir1.
• Give a sqoop command to import data from all tables in the MySql DB DB1.
• What does the following query do?$ sqoop import --connect jdbc:mysql://db.foo.com/somedb --table sometable \ --where "id > 1000" --target-dir /incremental_dataset --append
• 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.