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.

PutDatabaseRecord error

Highlighted

PutDatabaseRecord error

New Contributor

Erorrs when PutDatabaseRecord

92525-putdatabaserecord-error.png

Script test with MySQL:

create databases nifi_a;

CREATE TABLE nifi_a.Test1 (DATE_INSERT DATE, G_INSTITUTION_ID varchar(25));

create databases nifi_b;

CREATE TABLE nifi_b.Test2 (tx_date DATE,Institution varchar(25) );

use nifi_a;

insert into Test1 values (now(), 'A');

insert into Test1 values (now(), 'B');

insert into Test1 values (now(), 'C');

select * from nifi_a.Test1;

select * from nifi_b.Test2;


putdatabaserecord-error.xml

Do you have any suggestions????

3 REPLIES 3

Re: PutDatabaseRecord error

@Thuy Le

In your script listed above you will need to add the following line before the last line, like this.

use nifi_b;

select * from nifi_b.Test2;

Re: PutDatabaseRecord error

New Contributor

The script on to test in MySQL, in Nifi we use processor

PutDatabaseRecord

Re: PutDatabaseRecord error

@Thuy Le

Your snapshot shows 1 flow file queued, would you post the contents of that flow file here?