Support Questions

Find answers, ask questions, and share your expertise

Can Nifi insert data into uppercase table in postgesql ?

avatar
Explorer

Hi Team,
I create a dataflow try to insert data into uppercase table in postgesql.

But it does not work.

Appreciate any help on this issue, I am new to Nifi.

 

nifi dataflow.png

 

Here are my setting for QueryDatabaseTable and PutDatabaseRecord

 

nifi dataflow querydatabasetable.png

 

nifi dataflow putdatabaserecord.png

 

The error message show

org.apache.nifi.processors.standard.db.TableNotFoundException: Table "ACPMA" not found, ensure the Catalog, Schema, and/or Table Names match those in the database exactly

 

nifi dataflow table is not exist.png

 

Here is a uppercase table ACPMA in postgesql.

 

nifi dataflow db table is exist.png

1 ACCEPTED SOLUTION

avatar
Super Guru

Hi @mandychen ,

Have you tried removing the double quotes  from "ACPMA" in the Table Name property of the PutDatabaseRecord? I dont think you need it there.

 

If that helps please accept solution.

Thanks

 

View solution in original post

2 REPLIES 2

avatar
Super Guru

Hi @mandychen ,

Have you tried removing the double quotes  from "ACPMA" in the Table Name property of the PutDatabaseRecord? I dont think you need it there.

 

If that helps please accept solution.

Thanks

 

avatar
Explorer

I see, it work!

Thanks for your information