https://community.cloudera.com/t5/Support-Questions/Need-a-processor-to-test-if-a-table-sql-exists-and-return/m-p/176556#M138806 <P>As of NiFi 1.5.0 (via <A href="https://issues.apache.org/jira/browse/NIFI-4522" target="_blank">NIFI-4522</A>), you can issue a SQL query in <A href="https://nifi.apache.org/docs/nifi-docs/components/org.apache.nifi/nifi-standard-nar/1.7.0/org.apache.nifi.processors.standard.PutSQL/index.html" target="_blank">PutSQL</A> while still retaining the incoming flow file contents. For your case, you could send the CSV file to PutSQL and execute a "CREATE TABLE IF NOT EXISTS" statement, which will create the table the first time but allow the CSV to proceed to the "real" destination processor, likely <A href="https://nifi.apache.org/docs/nifi-docs/components/org.apache.nifi/nifi-standard-nar/1.7.0/org.apache.nifi.processors.standard.PutDatabaseRecord/index.html" target="_blank">PutDatabaseRecord</A>.</P> Fri, 29 Jun 2018 22:06:16 GMT mburgess 2018-06-29T22:06:16Z