nifi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Koji Kawamura <ijokaruma...@gmail.com>
Subject Re: Ingest data into SQL database using NiFi
Date Tue, 26 Sep 2017 00:31:45 GMT
Hi Tina,

I wonder if the column name is the cause of that issue, because 'date'
is a reserved keyword.
I wonder whether ConvertJSONToSQL can wrap those columns with square
brackets as shown in your example query.

If possible, can you try to change the column name to different one
such as 'tx_date' and see if it works?

Thanks,
Koji

On Mon, Sep 25, 2017 at 10:13 PM, tzhu <js.tianluzhu@gmail.com> wrote:
> Hi Koji,
>
> The "transaction" table only has two columns, "Date" and "Institution". I
> don't know what else I could change to...
>
> Thanks,
> Tina
>
>
>
> --
> Sent from: http://apache-nifi-developer-list.39713.n7.nabble.com/

Mime
View raw message