nifi-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From <philippe.gib...@orange.com>
Subject tranform a variable JSON list of properties with JoltTransformJSON
Date Mon, 13 Feb 2017 12:15:13 GMT
Hello ,
My flow input csv files with a variable  # of fields ( value1, value2 , valueN) and  I  infer
the types  with InferAvro schema ( please see below) :
{
  "type": "record", "name": "pgcsvavro",  "doc": "Schema generated by Kite",
  "fields": [      { "name": "Value1", "type": "long", "doc": "Type inferred from '113'" },
.........
       { "name": "ValueN", "type": "long", "doc": "Type inferred from '238'" },
  ]
}
I would like to transform  this JSON ( from the InferAvro Processor) with  the JoltTransformJSON
processor  to
Output another JSON   like this :
{
  "aggs": {
    "AggValue1": {
      "avg": {
        "field": "Value1"
      }   },
.......................
    "AggValueN": {
      "avg": {
        "field": "ValueN"
      }   }  } }

My question  :
Is it possible to transform a variable JSON list of properties with the JoltTransformJSON
processor ?
Best regards
Phil



_________________________________________________________________________________________________________________________

Ce message et ses pieces jointes peuvent contenir des informations confidentielles ou privilegiees
et ne doivent donc
pas etre diffuses, exploites ou copies sans autorisation. Si vous avez recu ce message par
erreur, veuillez le signaler
a l'expediteur et le detruire ainsi que les pieces jointes. Les messages electroniques etant
susceptibles d'alteration,
Orange decline toute responsabilite si ce message a ete altere, deforme ou falsifie. Merci.

This message and its attachments may contain confidential or privileged information that may
be protected by law;
they should not be distributed, used or copied without authorisation.
If you have received this email in error, please notify the sender and delete this message
and its attachments.
As emails may be altered, Orange is not liable for messages that have been modified, changed
or falsified.
Thank you.


Mime
View raw message