You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@nifi.apache.org by tzhu <js...@gmail.com> on 2017/11/10 20:59:32 UTC

Re: Ingest data into SQL database using NiFi

Hi Koji,

I was not working on NiFi for a while, and now I'm back with more
questions...

In QueryRecord, how should I write a SQL query? It doesn't seem to give me
the choice to use SQL anywhere, even if I choose the script option. And what
exactly should I do for the reader and writer?

Thanks,

Tina



--
Sent from: http://apache-nifi-developer-list.39713.n7.nabble.com/

Re: Ingest data into SQL database using NiFi

Posted by Pierre Villard <pi...@gmail.com>.

Hi Tina,

For QueryRecord processor, I'd recommend you reading this excellent article
[1].

[1] https://blogs.apache.org/nifi/entry/real-time-sql-on-event

Hope this helps,
Pierre

2017-11-10 21:59 GMT+01:00 tzhu <js...@gmail.com>:

> Hi Koji,
>
> I was not working on NiFi for a while, and now I'm back with more
> questions...
>
> In QueryRecord, how should I write a SQL query? It doesn't seem to give me
> the choice to use SQL anywhere, even if I choose the script option. And
> what
> exactly should I do for the reader and writer?
>
> Thanks,
>
> Tina
>
>
>
> --
> Sent from: http://apache-nifi-developer-list.39713.n7.nabble.com/
>