nifi-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Pierre Villard <pierre.villard...@gmail.com>
Subject Re: Title: Feature needed - ConvertJSONToCSV processor
Date Thu, 09 Aug 2018 08:40:01 GMT
Wondering how you're going to manage insertion of data in a SQL database if
you don't know anything about the schema of your data?

2018-08-09 6:46 GMT+02:00 Mahendra prabhu <prabhuu161994@gmail.com>:

> 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 <danoyoung@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 <prabhuu161994@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 <prabhuu161994@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.fr@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 <prabhuu161994@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
>>>>>>
>>>>>
>>>>>

Mime
View raw message