Scenario-23

Have you subscribed for update ? Please subscribe here

Problem Scenario 23 : You have given a CSV file, which contain Employee and Salary data. You need to accomplish following.

1. Load this file to HDFS.

2. Create two tables in MySQL named as EMPLOYEE and SALARY.

3. Once file in HDFS load in RDBMS using Sqoop on above two tables.

3. Create an Avro file for this EMPLOYEE and SALARY tables.

4. Extract the Schema from this Avro file (And without downloading AVRO file locally).