Identify the tool best suited to import a portion of a relational database every day as files into HDFS, and generate Java classes to interact with that imported data?

The correct answer is F. Sqoop. Sqoop ("SQL-to-Hadoop") is a straightforward command-line tool with the following capabilities: Imports individual tables or entire databases to files in HDFS Generates Java classes to allow you to interact with your imported data Provides the ability to import from SQL…

Hadoop Ecosystem Fundamentals

Question

Options

AOozie
BFlume
CPig
DHue
EHive
FSqoop
Gfuse-dfs

How the community answered

(37 responses)

B
3% (1)
D
5% (2)
E
14% (5)
F
76% (28)
G
3% (1)

Explanation

Sqoop ("SQL-to-Hadoop") is a straightforward command-line tool with the following capabilities: Imports individual tables or entire databases to files in HDFS Generates Java classes to allow you to interact with your imported data Provides the ability to import from SQL databases straight into your Hive data warehouse Data Movement Between Hadoop and Relational Databases Data can be moved between Hadoop and a relational database as a bulk data transfer, or relational tables can be accessed from within a MapReduce map function. * Cloudera's Distribution for Hadoop provides a bulk data transfer tool (i.e., Sqoop) that imports individual tables or entire databases into HDFS files. The tool also generates Java classes that support interaction with the imported data. Sqoop supports all relational databases over JDBC, and Quest Software provides a connector (i.e., OraOop) that has been optimized for access to data residing in Oracle databases.

Topics

#Sqoop#RDBMS import#HDFS#Java class generation

Community Discussion

No community discussion yet for this question.

Full CCD-410 Practice