Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Delete data issue with PutdatabaseRecord

Delete data issue with PutdatabaseRecord

New Contributor

Hi team,

I faced the issue with PutdatabaseRecord. This processor always delete miss some record, just some records. Could you help me give some advise >>>

DuongNT_0-1588494464939.png

 

 

2 REPLIES 2
Highlighted

Re: Delete data issue with PutdatabaseRecord

Explorer

Looks like there is on a table 2 or more PRIMERY_KEY columns.

You can check it with:

SHOW CREATE TABLE MYSQL_TABLE_NAME

The Problem occurs if the same value is entered for several primary key columns.

 

So you have to remove some of them 

Highlighted

Re: Delete data issue with PutdatabaseRecord

New Contributor

Thanks for your response.

But it have only 1 primary key on my table and as i checked, just some id are not deleted @@.

Now i use PutSQL instead of PutdatabaseRecord to delete these records, it work well.

Don't have an account?
Coming from Hortonworks? Activate your account here