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:32:44 GMT
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 <ijokarumawak@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.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