You have an employee who is a Date Analyst and is very comfortable with SQL. He would like to
run ad-hoc analysis on data in your HDFS duster. Which of the following is a data warehousing
software built on top of Apache Hadoop that defines a simple SQL-like query language well-suited
for this kind of user?

A.
Pig

B.
Hue

C.
Hive

D.
Sqoop

E.
Oozie

F.
Flume

G.
Hadoop Streaming

Explanation:
Hive defines a simple SQL-like query language, called QL, that enables users
familiar with SQL to query the data. At the same time, this language also allows programmers who
are familiar with the MapReduce framework to be able to plug in their custom mappers and
reducers to perform more sophisticated analysis that may not be supported by the built-in
capabilities of the language. QL can also be extended with custom scalar functions (UDF’s),
aggregations (UDAF’s), and table functions (UDTF’s).

Reference:https://cwiki.apache.org/Hive/(Apache Hive, first sentence and second paragraph)