Additional Info: The blob does not contains objects larger than 16MB.
On Wed, Apr 24, 2013 at 7:33 PM, anil gupta <[email protected]> wrote: > Hi Jarcec, > > Thanks for your reply. Suppose if table "abc" has a blob column in it. > I ran the following query with sqoop for exporting data but the column is > not getting exported: > sqoop import --connect jdbc:oracle:thin:@db:1521:sid --username user > --password pass --query 'select * from abc where $CONDITIONS' --split-by > id --target-dir /tmp/data --as-textfile --fields-terminated-by \\001 > --escaped-by \\ --null-string '' --null-non-string '' --verbose > > Am i missing something in the above command? > > Thanks, > Anil Gupta > > > > > On Wed, Apr 24, 2013 at 3:17 PM, Jarek Jarcec Cecho <[email protected]>wrote: > >> Hi Anil, >> the BLOB columns are handled in special way, please take a look into our >> user guide [1]. >> >> Jarcec >> >> Links: >> 1: http://sqoop.apache.org/docs/1.4.3/SqoopUserGuide.html#_large_objects >> >> On Wed, Apr 24, 2013 at 10:48:08AM -0700, anil gupta wrote: >> > Hi All, >> > >> > I am using Sqoop 1.4.2 with cdh4.2.0 Enterprise. I am trying to use >> sqoop >> > to export the data from a Oracle table that contains blob. But, when i >> am >> > exporting that table through sqoop, BLOB column is not being exported. >> Can >> > anyone tell me whether Sqoop supports exporting Oracle Blob's? If not, >> is >> > there a way that i can write my own custom java code(mapper?) to export >> > Blob and use it with sqoop. >> > >> > -- >> > Thanks & Regards, >> > Anil Gupta >> > > > > -- > Thanks & Regards, > Anil Gupta > -- Thanks & Regards, Anil Gupta
