question Re: SQOOP issues with ORACLE datatypes - RAW, BFILE, LONG RAW in Archives of Support Questions (Read Only)

SQOOP issues with ORACLE datatypes - RAW, BFILE, LONG RAW

nbalaji-elangov — Fri, 16 Dec 2016 04:20:03 GMT

Example oracle RAW datatype value “175D78D86FAFE6D19C631AF3BFC246EB” and the sqoop converts that data into string. The data has spaces when I check the hdfs file using "hive –orcdump –d <hdfsfile>”. The RAW dataype is expressed in hexadecimal on oracle side and sqoop adds space to the hdfs file like “17 5D 78 D8 6F AF E6 D1 9C 63 1A F3 BF C2 46 EB”. Has anyone faced this ?

RAW datatype is supported by sqoop in the documentation - https://sqoop.apache.org/docs/1.4.6/SqoopUserGuide.html

I see BFILE and LONG RAW datatypes are not supported in sqoop documentation. Do we have a workaround for this ?

Re: SQOOP issues with ORACLE datatypes - RAW, BFILE, LONG RAW

myoung — Fri, 16 Dec 2016 04:53:38 GMT

@nbalaji-elangovan

Have you looked into Type Mapping to override the data types?

https://sqoop.apache.org/docs/1.4.6/SqoopUserGuide.html#_controlling_type_mapping

Re: SQOOP issues with ORACLE datatypes - RAW, BFILE, LONG RAW

nbalaji-elangov — Sat, 17 Dec 2016 00:04:58 GMT

Ya I tried it and that doesn't help.

Re: SQOOP issues with ORACLE datatypes - RAW, BFILE, LONG RAW

nbalaji-elangov — Wed, 04 Jan 2017 02:39:40 GMT

This has been accepted as a bug by the support team and tracked in the internal JIRA.

Re: SQOOP issues with ORACLE datatypes - RAW, BFILE, LONG RAW

vetriselvan_gan — Tue, 31 Oct 2017 23:38:26 GMT

Hi balaji what is the status of this Jira. did you have any referance to that jira I can refer it ?