You have user profile records in an OLTP database that you want to join with web server logs
which you have already ingested into HDFS. What is the best way to acquire the user profile for
use in HDFS?

A.
Ingest with Hadoop streaming

B.
Ingest with Apache Flume

C.
Ingest using Hive’s LOAD DATA command

D.
Ingest using Sqoop

E.
Ingest using Pig’s LOAD command

Explanation:
https://thinkbiganalytics.com/leading_big_data_technologies/ingestion-and-streamingwith-storm-kafka-flume/