You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@sqoop.apache.org by ದೀಪಕ್ <de...@gmail.com> on 2015/04/13 20:20:39 UTC

Re: SQOOP Increment for Oracle BLOB

Hi, we are using SQOOP Increment job for importing Data from the Oracle
DB=  to HBase.

All the tables come through from Oracle DB to HBase. However, the data
for=  BLOB column is not coming through.

Command used is



sqoop job --create SAMPLE_JOB  -- import --connect  jdbc:oracle:thin:@<Ora=
cle DB IP and schema> --username <> --password <> --table <Oracle BLOB tab=

le> -m 1 --hbase-table <hbase table> --column-family sample_data

le> --hbase-r=

ow-key SAMPLE_ID --map-column-java BLOB_CONTENTS=3DString
--hbase-bulkload=  --hbase-create-table



I don't get any errors but the BLOB column does not come through. Apprecia=
te any help to resolve this.



Thank

Deepak

On Tue, Mar 31, 2015 at 8:10 PM, ದೀಪಕ್ <de...@gmail.com> wrote:

> Hi, we are using SQOOP Increment job for importing Data from the Oracle
> DB=  to HBase.
>
> All the tables come through from Oracle DB to HBase. However, the data
> for=  BLOB column is not coming through.
>
> Command used is
>
>
>
> sqoop job --create SAMPLE_JOB  -- import --connect  jdbc:oracle:thin:@<Ora=
> cle DB IP and schema> --username <> --password <> --table <Oracle BLOB tab=
>
> le> -m 1 --hbase-table <hbase table> --column-family sample_data
>
> le> --hbase-r=
>
> ow-key SAMPLE_ID --map-column-java BLOB_CONTENTS=3DString
> --hbase-bulkload=  --hbase-create-table
>
>
>
> I don't get any errors but the BLOB column does not come through.
> Apprecia= te any help to resolve this.
>
>
>
> Thank
>
> Deepak
>
>