Search code examples
etlapache-nifi

Can Nifi insert data into uppercase table in postgesql?

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

Here are my setting for QueryDatabaseTable and PutDatabaseRecord.

nifi dataflow querydatabasetable

nifi dataflow putdatabaserecord

The error message show below.

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

Here is a uppercase table ACPMA in postgesql.

nifi dataflow db table is exist

Solution

  • Try updating the table name to ACPMA (without quotes) in PutDatabaseRecord.