I could write JQ for direct json values, but for dynamic json nested object I couldn't achieve with JQ. Can you please share your suggestion? major goal is to move complex nested json values into SQL after using transformation with expression language. If I get the intermediate result into CSV, it is wasy to use transformation, create insert query and move to SQL.
Regards, Prabhu Mahendran On Tue, Aug 7, 2018 at 6:26 PM dan young <danoyo...@gmail.com> wrote: > You could look at using ExecuteStreamCommand + JQ. We use this pattern a > lot... > > Regards > > Dano > > On Tue, Aug 7, 2018, 5:09 AM Mahendra prabhu <prabhuu161...@gmail.com> > wrote: > >> Expected behaivor is similiar to this task created - >> https://issues.apache.org/jira/browse/NIFI-4398 I couldnt achieve this >> using ConvertRecord. Can you guide to proceed further to handle nested json >> elements ? >> >> Thanks in advance >> >> On Tue, Aug 7, 2018 at 4:31 PM Mahendra prabhu <prabhuu161...@gmail.com> >> wrote: >> >>> Hi Pierre, >>> >>> I need to move nested json data into SQL table after using expression >>> language. So I thought to use this processor, and do transformation for the >>> resultant CSV and move to SQL. >>> >>> Regards, >>> Prabhu Mahendran >>> >>> On Tue, Aug 7, 2018 at 3:59 PM Pierre Villard < >>> pierre.villard...@gmail.com> wrote: >>> >>>> Hi, >>>> >>>> I believe it can be closed because it's doable with ConvertRecord >>>> processor (which is the recommended approach). >>>> Does it answer your requirement ? >>>> >>>> Thanks, >>>> Pierre >>>> >>>> 2018-08-07 11:43 GMT+02:00 Mahendra prabhu <prabhuu161...@gmail.com>: >>>> >>>>> Hi Folks, >>>>> >>>>> Is there is plan to include this feature or dropped - >>>>> https://issues.apache.org/jira/browse/NIFI-1583 ? >>>>> >>>>> Is this PR closed because of licensing or incomplete rebase of code ? >>>>> >>>>> >>>>> Regards, >>>>> Prabhu Mahendran >>>>> >>>> >>>>
