https://community.cloudera.com/t5/Support-Questions/Read-a-flowfile-with-groovy-error/m-p/233766#M195589 <P>Looks like you are referring to the script provided in <A href="https://stackoverflow.com/questions/49053901/create-a-postgresql-table-from-avro-schema-in-nifi" target="_blank">this SO post</A>. The variable createTable is a GString, not a Java String. This causes invocation of <A href="http://docs.groovy-lang.org/docs/latest/html/api/groovy/sql/Sql.html#execute-groovy.lang.GString-" target="_blank">Sql.execute(GString)</A>, which converts the embedded expressions into parameters, and you can't use a parameter for a table name. Use the following instead:</P><OL> </OL><PRE>SQL.mydb.execute(createTable.toString())</PRE><P>This will cause the invocation of <A href="http://docs.groovy-lang.org/docs/latest/html/api/groovy/sql/Sql.html#execute-java.lang.String-" target="_blank">Sql.execute(String)</A>, which does not try to parameterize the statement.</P> Tue, 06 Mar 2018 00:03:54 GMT mburgess 2018-03-06T00:03:54Z