nifi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Matt Burgess <mattyb...@apache.org>
Subject Re: "Method not supported" error facing GenerateTableFetch and QueryDatabaseTable processor
Date Tue, 20 Mar 2018 13:43:31 GMT
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 <rsvangari@gmail.com> 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/

Mime
View raw message