CCA175 exam

Problem Scenario 21: You have been given log generating service as below. startjogs (It will generate continuous logs) tailjogs (You can check, what logs are being generated) stopjogs (It will stop the log service) Path where logs are generated using above service: /opt/gen_logs/logs/access.log Now write a flume configuration file named...

Problem Scenario 23: You have been given log generating service as below. Start_logs (It will generate continuous logs) Tail_logs (You can check, what logs are being generated) Stop_logs (It will stop the log service) Path where logs are generated using above service: /opt/gen_logs/logs/access.log Now write a flume configuration file named...

Problem Scenario 21: You have been given log generating service as below. startjogs (It will generate continuous logs) tailjogs (You can check, what logs are being generated) stopjogs (It will stop the log service) Path where logs are generated using above service: /opt/gen_logs/logs/access.log Now write a flume configuration file named...

Now import data from mysql table departments to this hive table. Please make sure that data should be visible using below hive command, select" from departments_hiveView AnswerAnswer: Solution: Step 1: Create hive table as said. hive show tables; create table departments_hive(department_id int, department_name string); Step 2: The important here is,...

Import departments table as a text file in /user/cloudera/departments.View AnswerAnswer: 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...

Problem Scenario 2: There is a parent organization called "ABC Group Inc", which has two child companies named Tech Inc and MPTech. Both companies employee information is given in two separate text file as below. Please do the following activity for employee details. Tech Inc.txt View AnswerAnswer: Solution: Step 1:...

Problem Scenario 30: You have been given three csv files in hdfs as below. EmployeeName.csv with the field (id, name) EmployeeManager.csv (id, manager Name) EmployeeSalary.csv (id, Salary) Using Spark and its API you have to generate a joined output as below and save as a text tile (Separated by comma)...