我正在尝试将数据从多个具有分区的表中从同一个数据库加载到另一个表中。为此,我遵循以下程序:
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}'
暂无答案!
目前还没有任何答案,快来回答吧!