Sqoop provides the capability to store large sized data into a single field based on the type of data. Sqoop supports the ability to store-
1)CLOB ‘s
– Character Large Objects
2)BLOB’s
–Binary Large Objects
Large
objects in Sqoop are handled by importing the large objects into a file
referred as “LobFile” i.e. Large Object File. The LobFile has the ability to
store records of huge size, thus each record in the LobFile is a large object.