Hive DDL for Comma-Separated Employee Files Already in HDFS

Company: Accenture

Difficulty: medium

Problem Statement

Question 1

Identify the best Hive code snippet for the following scenario. Create a Hive table to query multiple comma separated files stored in HDFS at path '/user/hive/employees' and with the following sample rows: 1002, Murphy, Diane, President 1056, Patterson, Mary, VP Sales 1076, Firrelli, Jeff, VP Marketing