Did you get a solution to this . I am also getting a communication error . My Nifi Instance and Mysql are on the same linux server .  ... View more

You cannot share states between processor, each processor has it's own state. ... View more

Is this (now) considered a NiFi "anti-pattern"? Do you have any idea how to do this using NiFi Record serialization services? I'm under the impression that creating thousands of content files is not the best practice by today's standards, but I'm not sure how to use InvokeHTTP on a full set of records without splitting it into many flowfiles. Any ideas? ... View more

For example I want to transform the zabbix payload from v4.0 to v4.4:   Zabbix Json Payload v4.0 (INPUT)   { "hosts": [ "Host B", "Zabbix Server" ], "groups": [ "Group X", "Group Y", "Group Z", "Zabbix servers" ], "tags": [ { "tag": "availability", "value": "" }, { "tag": "data center", "value": "Riga" } ], "name": "Either Zabbix agent is unreachable", "clock": 1519304285, "ns": 123456789, "eventid": 42, "value": 1 }     the JOLT transform:   [ { "operation": "shift", "spec": { "hosts": { "*": [ "hosts.[&].host", "hosts.[&].name" ] }, "*": "&" } } ]    The result ( Zabbix v4.4)   { "hosts" : [ { "host" : "Host B", "name" : "Host B" }, { "host" : "Zabbix Server", "name" : "Zabbix Server" } ], "groups" : [ "Group X", "Group Y", "Group Z", "Zabbix servers" ], "tags" : [ { "tag" : "availability", "value" : "" }, { "tag" : "data center", "value" : "Riga" } ], "name" : "Either Zabbix agent is unreachable", "clock" : 1519304285, "ns" : 123456789, "eventid" : 42, "value" : 1 }   ... View more

Hmmm DDL to JSON is not a bad idea. ... View more

Hello mburgess, I am able to extract attributes from using GetFile>SplitXml> EvaluateXQuery processor. Now, can you please tell me how can I store these dynamic attributes to the PostgreSQL database using PutSQL processor ?   Is this the correct expression I am putting in PutSQL? INSERT INTO alstom_radioscopy_amsterdam_blue."xml_log"(block_id,kp_begin,kp_end) VALUES (${block_id.text()},${kp_begin.text()},${kp_end.text()}); ... View more

Hi @Kart,    As this is a thread which was marked 'Solved' over three years ago, you would have a better chance of receiving a resolution by posting a new question. This will also present you with the opportunity to include details specific to your environment that could aid other members in providing a more relevant answer to your question.     ... View more

@asfou    NiFi does not contain any processors that support Hive version 2.x.  The latest versions of Apache NiFi offer Hive 1.x and Hive 3.x client based processor components.  To support Hive 2.x version, you may need to build your own custom processors built using the Hive 2.x client. Matt ... View more

Hi All,   I am facing issue still after adding below both hive-site.xml and core-site.xml.   <property> <name>hadoop.security.authentication</name> <value>kerberos</value> </property>   I am facing below error   org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver of class 'org.apache.hive.jdbc.HiveDriver' for connect URL jdbc:hive2://ux329tas101.ux.hostname.net:10000/default;principal=<principal name>;ssl=true   Could you please help me regarding this.   Regards, Swadesh Mondal ... View more

For small XML files, you could use ExtractText to get the entire content into an attribute, then UpdateRecord with an XMLReader, adding a property for your new field (let's say "/content") and whatever writer you wish. You will have to specify the output schema for the writer, to include all the fields parsed by the XMLReader in addition to a CLOB/BLOB/String "content" field. If you want to exclude fields from the XML then just exclude them from the output schema. Then you can use a similar Reader (AvroReader if you use an AvroRecordSetWriter, e.g.) in PutDatabaseRecord.   If this doesn't work for your use case, you may need to use SplitXml and work on individual records. This will degrade the performance of PutDatabaseRecord unless you merge the records back together later (using MergeRecord for example). ... View more