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

PutDatabaseRecord error

Explorer

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
Highlighted

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;

Highlighted

Re: PutDatabaseRecord error

Explorer

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

PutDatabaseRecord

Highlighted

Re: PutDatabaseRecord error

@Thuy Le

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

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