Member since
02-27-2020
16
Posts
3
Kudos Received
3
Solutions
My Accepted Solutions
Title | Views | Posted |
---|---|---|
2486 | 04-05-2020 11:16 PM | |
2580 | 03-30-2020 03:32 AM | |
1286 | 03-25-2020 06:48 PM |
04-05-2020
11:16 PM
1 Kudo
Finally fixed the issue by myself. have changed all the columns to Uppercase and made the Translate Field Names to false.. That works for me.
... View more
04-05-2020
10:16 PM
Anybody has answer for this- I get this issue on PutDatabaseRecord as well. When I check java code of PutDatabaseRecord. I could see below replace with - underscore.
... View more
03-30-2020
07:51 PM
Thanks Steven
... View more
03-30-2020
03:32 AM
1 Kudo
I resolved the issue(${sql.args.1.value:toDate("yyyy-MM-dd"):toNumber()}).. But I dont understand why we need toNumber() here. Any body have answer to this ?
... View more
03-29-2020
09:50 PM
I am facing an issue - in PutSQL
I am sending a date value from XML-JSON->oracle table.
EvaluateJSOn ->RouteAttributes->AttributeJson->ConvertJsontoSQL -> UpdateAttrubites->PutSQL is my flow.
But it is failing always with
... View more
Labels:
- Labels:
-
Apache NiFi
03-25-2020
06:48 PM
Thanks @stevenmatison . worked perfectly..
... View more
03-22-2020
09:08 PM
1 Kudo
Eg: Update table table_name emp_name=? where empid=?
But My column name is emp_id
... View more
Labels:
- Labels:
-
Apache NiFi
03-22-2020
04:52 PM
My file:
"ws:Operation": "ADD", "ws:Supervisor_Name": { "ws:PriorValue": "", "content": "Dr. Leah Thaler"
In above example i need to send the content:Dr. Leah Thaler to insert
My file:
"ws:Operation": "MODIFY", "ws:Supervisor_Name": { "ws:PriorValue": "", "content": "Dr. Leah Thal"
In above example i need to send the content:Dr. Leah Thaler to update.
Database is Oracle - the flow: Getfile-> EvaluateJSONPath -> send the data to two tables using AttributesToJSON for flatten JSON -> ConvertJSONSQL to Putsql.
Note: I dont want to write AVRO schema. So we build this flow
... View more
Labels:
- Labels:
-
Apache NiFi