How are large objects handled in Sqoop?

Question

How does Sqoop handle large objects?

Answer 1

In Hadoop, Sqoop can be used to store big data files in a single field. This is done based on the type of data that is being stored. There are two specific types of data that can be stored:

•  CLOB - Character Large Objects 
•  BLOB - Binary Large Objects 

In Sqoop, large objects are managed by importing them into a file known as "LobFile" which is short for a Large Object File. These LobFiles have the capability to store large sized data records.