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.

Apache NiFi ExecuteSQL not working for where Clause

Apache NiFi ExecuteSQL not working for where Clause

New Contributor

Hello..,

 i am trying to load data from multiple tables with partition from same database to another tables. for that, i am following following procedure:

 

ListDatabaseTables --> RouteOnAttribute --> Replacetext --> ExecuteSQL --> PutHive3Streaming

 

in the executeSQL processor, getting following exception:

 

unable to execute SQL select query select * from test.department1 where dt='20190901' due to java.sql.SQLFeatureNotSuppoertedException:method not supported; routing to failure:org.apache.nifi.procssor.exception.processException:java.sql.SQLFeaturenotSupportedException: Method not Supported.

 

in Replacetext processor, ,my query is like : select * from '{$db.table.fullname}'

 

 

 

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