Rohit, Hive is not supported by the database fetch processors yet, there is a Jira [1] and some PRs [2],[3] under review to add this capability.
Regards, Matt [1] https://issues.apache.org/jira/browse/NIFI-3093 [2] https://github.com/apache/nifi/pull/1281 [3] https://github.com/apache/nifi/pull/2507 On Tue, Mar 20, 2018 at 8:32 AM, Rohit <[email protected]> wrote: > Hi, > > I trying to read hive table using QueryDatabaseTable processor and when i > executed my flow, i am getting below error. > > ""' > 2018-03-20 00:42:20,717 ERROR [Timer-Driven Process Thread-5] > o.a.n.p.standard.GenerateTableFetch > GenerateTableFetch[id=3ddee0d9-0162-1000-7696-273b8816bcff] Unable to > execute SQL select query SELECT COUNT(*) FROM table2 due to > java.sql.SQLException: Method not supported: {} > java.sql.SQLException: Method not supported""' > > and also tried with GenerateTableFetch but facing same error. > > QueryDatabaseTable1.PNG > <http://apache-nifi-developer-list.39713.n7.nabble.com/file/t927/QueryDatabaseTable1.PNG> > QueryDatabaseTable2.PNG > <http://apache-nifi-developer-list.39713.n7.nabble.com/file/t927/QueryDatabaseTable2.PNG> > QueryDatabaseTable3.PNG > <http://apache-nifi-developer-list.39713.n7.nabble.com/file/t927/QueryDatabaseTable3.PNG> > > Thanks, > RohitC > > > > -- > Sent from: http://apache-nifi-developer-list.39713.n7.nabble.com/
