Member since
08-19-2019
3
Posts
0
Kudos Received
0
Solutions
08-21-2019
10:39 AM
@ankurkapoor_wor Hi, Even I am facing the same issue as @mqureshi. I am trying to fetch data from SQL server in Avro fomat through NiFi and load it to Redshift through copy command. But the generated Avro file is converting the date and timestamp datatypes to string because of which copy command is loading all NULL values in the target table. So I tried to follow your approach, In my case I'm using ExecuteSQLRecord processor to fetch the data from SQL server and writing it to json format and then trying to convert it to Avro format using ConvertJsonToAvro processor but then I am unable to parse Record Schema. Could you please help me also to resolve this issue. Thanks in advance! Anusha
... View more
08-20-2019
07:39 AM
This is my DDL : CREATE TABLE dev.test_table ( date DATE, weekbegin DATETIME );
... View more
08-19-2019
10:47 PM
Hi All,
I am trying to generate Avro file from SQL Server using ExecuteSQL processor. Generated Avro file is converting date, datetime, varchar datatypes to string datatype.Sample : {"name":"Date","type":["null","string"]},{"name":"WeekBegin","type":["null","string"]}. Could anyone please suggest some solution to this.
The executeSQL processor configuration is as follow:
... View more
- Tags:
- NiFi
Labels:
- Labels:
-
Apache NiFi