nifi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From tzhu <>
Subject Ingest data into SQL database using NiFi
Date Fri, 22 Sep 2017 20:10:18 GMT
Hi everyone,

I'm quite new to this. I want to extract some data from one table, do some
modification, and put it back to another table in SQL server by NiFi. I have
no problem using ExecuteSQL. Then I use ConvertAvroToJSON and
ConvertJSONToSQL to put the data back to database. I would have the
following error message from ConvertJSONToSQL:


I tried to do the SQL query and it works fine. The following is my SQL

insert into [TEST].[db_datawriter].[Test1]
SELECT TOP (1000) [DATE_INSERT] as [Date]
  ,[G_INSTITUTION_ID] as [Institution]

Does anyone know how I should fix this or any other method I should try? Any
advice is appreciated.



Sent from:

View raw message