jyothireddy119
Explorer

Re: Sqoop incremental import using merge-key - Ora...

by Explorer in Support Questions
‎12-21-2017 04:17 PM
‎12-21-2017 04:17 PM
Hi @Bala Vignesh N V I have another table in Oracle DB which has a single column primary key, and it also has blob data in it. When I am trying to do Sqoop import using Merge-key for this table also, it is giving me the same error - Null Pointer Exception. I think the issue is with blob data and merge-key. In the Merge-key I am passing the primary key attribute, but still it is throwing me the exception. No clue of why it is doing so. Please help ! Thanks, Jyothi ... View more

Re: sqoop incremental import using composite prima...

by Explorer in Support Questions
‎12-20-2017 07:58 PM
‎12-20-2017 07:58 PM
Hi @Krishna Srinivas I am facing the same issue, where in I have to specify the composite primary key in merge-key. But it is giving me the error. Can you please explain me on how can I achieve the above mentioned answer by taking an example. That will help me understand more clearly. Thanks in Advance !! ... View more

Re: Sqoop incremental import using merge-key - Ora...

by Explorer in Support Questions
‎12-20-2017 07:54 PM
‎12-20-2017 07:54 PM
Hi @Bala Vignesh N V Actually, my table in Oracle DB has a composite primary key, but in the merge-key I am specifying only one column. So, it is throwing me the Null pointer exception. Now, the problem is merge-key will not accept the composite primary key. So I am kind of struck there. Can you please help me if you have any idea on how to deal with this. Thanks Jyothi ... View more

Re: Error with Sqoop import Blob data type

by Explorer in Support Questions
‎12-19-2017 09:24 PM
‎12-19-2017 09:24 PM
@Prabhat Ratnala @Geoffrey Shelton Okot @Sandeep Nemuri Hi, Even I am facing the same issue. But I am trying to import the data into HDFS. Please let me know if you got any solution for this. Thanks! ... View more

How can I convert the BLOB data to the actual file...

by Explorer in Support Questions
‎12-19-2017 07:54 PM
‎12-19-2017 07:54 PM
Hi Team, I have a table in Oracle DB with one column holding BLOB data. Using Sqoop import the blob content is stored as binary value in HDFS. I want to see the original content of the blob data. How can I do that? Please help. Thanks in Advance !! ... View more
Labels:

Sqoop incremental import using merge-key - Oracle ...

by Explorer in Support Questions
‎12-19-2017 06:08 PM
‎12-19-2017 06:08 PM
@ksuresh @SupportKB I am trying to import the table with BLOB data from Oracle to HDFS using sqoop. I am getting the following error Error: java.lang.NullPointerException at org.apache.sqoop.lib.BlobRef.writeInternal(BlobRef.java:98) at org.apache.sqoop.lib.LobRef.write(LobRef.java:307) at org.apache.sqoop.lib.LobSerializer.writeBlob(LobSerializer.java:38) at com.cloudera.sqoop.lib.LobSerializer.writeBlob(LobSerializer.java:41) at QueryResult.write(QueryResult.java:191) at org.apache.sqoop.mapreduce.MergeRecord.write(MergeRecord.java:124) at org.apache.hadoop.io.serializer.WritableSerialization$WritableSerializer.serialize(WritableSerialization.java:98) at org.apache.hadoop.io.serializer.WritableSerialization$WritableSerializer.serialize(WritableSerialization.java:82) Thanks in Advance !! ... View more
Labels:
Contact Me
Online
Offline
Last Visited
‎01-26-2018 08:42 PM
Public Statistics
Date Registered ‎12-19-2017 06:04 PM
Last Visited ‎01-26-2018 08:42 PM
Total Messages Posted 8