About Adyant001

Adyant001 · ‎08-16-2024

HI Shiva239. The solution seems working for me but the child table(role) has an autoincrement PK column. SO how to insert value in autoincrement column Role Table: Id(pk auto increamne) Role_id(fk) Role_name 1 1 admin

Adyant001 · ‎08-13-2024

[ { "name": "sugam", "age": 30, "id": 1, "role": { "role": "Admin" } } ] I wanted to put name ,age, and id to user table then get the id from user table and put it in role table with role as admin Desired out put should be as below user table: Name age ID(pk) sugam 30 1 Role Table: Id(pk) Role_id(fk) Role_name 1 1 admin @mburgess @SAMSAL

Adyant001 · ‎08-13-2024

@mburgess -- I am reading from Oracle table, not sure about the incoming flowfile

Adyant001 · ‎08-13-2024

I am trying use LookupRecord LookupRecord from Oracle table and i am using Avro reader/writer in LookupRecord . BUt i am receiving below error Any suggestion @mburgess 2024-08-13 18:09:09,214 ERROR [Timer-Driven Process Thread-4] o.a.n.processors.standard.LookupRecord LookupRecord[id=3a641d1a-1b3c-1a47-2c18-b3541562e3ea] Could not determine schema to use for enriched FlowFiles org.apache.avro.InvalidAvroMagicException: Not an Avro data file.

Adyant001 · ‎08-13-2024

I need to inject data read from elastic in Json format to two different tables having parent child relationship. i.e User table Name, Age, Role David,35,1 Tay,23,2 John,27,2 Role table: 1,admin 2,user My requirement is to insert in user table first get the Role ID and then include that id in next insert to dump data in Role table How can i achieve this thing Apache Nifi?@mburgess

Adyant001 · ‎08-11-2024

Need to save Json data to multiple child tables. How should i do?

Adyant001 · ‎08-01-2024

@mburgess --I am using JsonQueryElasticSearch to fetch data from elastic .I am using query to fetch only one record using a particular event_id the processor reads the same data and duplicate records are stored in Oracle DB

Adyant001 · ‎07-29-2024

@joshua_adeleke --How to check the sql queries generated. i am also facing same issue

Online	Offline
Last Visited	‎08-16-2024 08:35 AM

Member Since	‎07-25-2024 11:28 PM
Last Visited	‎08-16-2024 08:35 AM
Posts	8
Kudos received	6

Cloudera Community

Re: insert in one table get the ID and then includ...

Re: insert in one table get the ID and then includ...

Re: LookupRecord LookupRecord throwing Could not ...

LookupRecord LookupRecord throwing Could not dete...

insert in one table get the ID and then include th...

How to save single Json data to multiple Oracle ta...

JsonQueryElasticSearch reads same data from elasti...

Re: PutSQL error: java.sql.SQLException: Missing I...