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
