apache nifi executesql不适用于where子句

zqdjd7g9  于 2021-06-24  发布在  Hive
关注(0)|答案(0)|浏览(239)

我正在尝试将数据从多个具有分区的表中从同一个数据库加载到另一个表中。为此,我遵循以下程序:

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

在executesql处理器中,出现以下异常:

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.

在replacetext processor中,我的查询类似于: select * from '${$db.table.fullname}'

暂无答案!

目前还没有任何答案,快来回答吧!

相关问题