Valid CCA175 Dumps shared by EduDump.com for Helping Passing CCA175 Exam! EduDump.com now offer the newest CCA175 exam dumps, the EduDump.com CCA175 exam questions have been updated and answers have been corrected get the newest EduDump.com CCA175 dumps with Test Engine here:
CORRECT TEXT Problem Scenario 5 : You have been given following mysql database details. user=retail_dba password=cloudera database=retail_db jdbc URL = jdbc:mysql://quickstart:3306/retail_db Please accomplish following activities. 1. List all the tables using sqoop command from retail_db 2. Write simple sqoop eval command to check whether you have permission to read database tables or not. 3 . Import all the tables as avro files in /user/hive/warehouse/retail cca174.db 4 . Import departments table as a text file in /user/cloudera/departments.
Correct Answer:
See the explanation for Step by Step Solution and configuration. Explanation: Solution: Step 1 : List tables using sqoop sqoop list-tables --connect jdbc:mysql://quickstart:330G/retail_db --username retail dba - password cloudera Step 2 : Eval command, just run a count query on one of the table. sqoop eval \ --connect jdbc:mysql://quickstart:3306/retail_db \ -username retail_dba \ -password cloudera \ --query "select count(1) from ordeMtems" Step 3 : Import all the tables as avro file. sqoop import-all-tables \ -connect jdbc:mysql://quickstart:3306/retail_db \ -username=retail_dba \ -password=cloudera \ -as-avrodatafile \ -warehouse-dir=/user/hive/warehouse/retail stage.db \ -ml Step 4 : Import departments table as a text file in /user/cloudera/departments sqoop import \ -connect jdbc:mysql://quickstart:3306/retail_db \ -username=retail_dba \ -password=cloudera \ -table departments \ -as-textfile \ -target-dir=/user/cloudera/departments Step 5 : Verify the imported data. hdfs dfs -Is /user/cloudera/departments hdfs dfs -Is /user/hive/warehouse/retailstage.db hdfs dfs -Is /user/hive/warehouse/retail_stage.db/products
