The list of reserved keywords: https://docs.microsoft.com/en-us/sql/t-sql/language-elements/reserved-keywords-transact-sql
On Tue, Sep 26, 2017 at 9:31 AM, Koji Kawamura <ijokaruma...@gmail.com> wrote: > 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.tianlu...@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/