Support Questions

Find answers, ask questions, and share your expertise
Announcements
Check out our newest addition to the community, the Cloudera Data Analytics (CDA) group hub.

How to make DELETE statement type auto retrieve primary key like "UPDATE" of PutDatabaseRecord

New Contributor

I am using to ingest json data using PutDatabaseRecord with JsonTreeReader. The statement type is "DELETE"

{
"BATCH_INFO_ID": 1514,
"REF_NO": "REF-001-M",
"BATCH_TYPE": "Fax",
"BATCH_DATE": "2011-07-14T00:00:00Z",
"RESULT_IND": "T",
}

However, I got below query finally:

Batch entry 0 DELETE FROM "IOSH"."CMI_BATCH_INFO" WHERE ("BATCH_INFO_ID" = 1514) AND ("REF_NO" = 'REF-001-M' OR ("REF_NO" is null AND 'REF-001-M' is null)) AND ("BATCH_TYPE" = 'Fax' OR ("BATCH_TYPE" is null AND 'Fax' is null)) ....

 

How to make it like "UPDATE" behavior to get primary key in where clause instead of put all fields in side where clause?

 

0 REPLIES 0
Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.