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 <[email protected]> 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/
