Member since
09-11-2015
60
Posts
72
Kudos Received
17
Solutions
My Accepted Solutions
Title | Views | Posted |
---|---|---|
1796 | 04-11-2017 06:18 PM | |
1442 | 02-21-2017 03:04 PM | |
2070 | 12-28-2016 10:21 PM | |
4557 | 11-30-2016 04:17 AM | |
6753 | 11-08-2016 02:42 PM |
07-08-2016
05:52 PM
3 Kudos
The ConvertJSONToSQL processor[1] merely converts a JSON object into a SQL query that can be executed. After it is converted, you haven't sent the command anywhere yet. You need another processor after that in order to actually send the command to be executed by a system. The PutSQL processor[2] (as suggested by @Jobin George) executes the SQL UPDATE or INSERT command that is in the contents of the incoming FlowFile.
[1] https://nifi.apache.org/docs/nifi-docs/components/org.apache.nifi.processors.standard.ConvertJSONToSQL/index.html [2] https://nifi.apache.org/docs/nifi-docs/components/org.apache.nifi.processors.standard.PutSQL/index.html
... View more
06-14-2016
01:13 PM
The question is regarding splitting the attributes of the FlowFile. ReplaceText and ReplaceTextWithMapping both work on the content of the FlowFile, not the attributes.
... View more
06-06-2016
09:54 PM
2 Kudos
You want to use the ReplaceText processor [1] on each of the messages after they are consumed from Kafka. Set the "Replacement Strategy" to "Append" and the dynamic property to use Expression Language[2] to set the timestamp (ie. "${now()}"). Then merge the messages before sending the HDFS like normal.
[1] https://nifi.apache.org/docs/nifi-docs/components/org.apache.nifi.processors.standard.ReplaceText/index.html
[2] https://nifi.apache.org/docs/nifi-docs/html/expression-language-guide.html
... View more
05-13-2016
06:47 PM
2 Kudos
Currently Fractional (aka. "Decimal") numbers are not supported in Expression Language. The "Number" field is backed by java Longs which are only whole numbers. There is currently work being done to add it and relatively recently there was a discussion thread about it[1]. The exact time when it will be included is yet to be determined though.
Edit: Actually I shouldn't make the assumption "fractional == decimal". There are currently no plans to support decimals expressed as fractions, ie. "1/4". There are plans to support decimals expressed using decimal points, ie "0.25". If decimals expressed as fractions is what you need, could you share the use-case?
[1] http://apache-nifi-developer-list.39713.n7.nabble.com/Discuss-Expression-Language-Options-to-Add-Decimal-Support-td9432.html
... View more
04-29-2016
02:16 PM
@shannon luo The FlowFile routed to 'Response' will have the body of the 'Get' response in the content of the FlowFile. You should be able to download the content or view the bytes using provenance. Depending on what the type is of the content you may also be able to view it properly in the viewer.
... View more
04-28-2016
09:43 PM
@shannon luo For your first question, the relationships for InvokeHttp are a bit confusing right now but the original flowfile (that came into the processor) will be routed to the "Original" relationship when the status indicates a success. The "Response" relationship, assuming you have the default configuration, will have the server's actual response. This was done so the user has the capability to use both the original flowfile and the server's response later in the flow.
... View more
04-26-2016
07:42 PM
3 Kudos
The GetHttp processor does not allow incoming connections. If you would like to dynamically change the URL in response to the attributes of FlowFiles I'd suggest using the InvokeHttp[1] processor instead of GetHttp.
[1] https://nifi.apache.org/docs/nifi-docs/components/org.apache.nifi.processors.standard.InvokeHTTP/index.html
... View more
04-12-2016
02:06 PM
5 Kudos
In addition to the UnpackContent processor suggested by @Chris Gambino, the CompressContent[1] processor has a "decompress" option which works on these compression formats:
use mime.type attribute gzip bzip2 xz-lzma2 lzma snappy snappy framed [1]https://nifi.apache.org/docs/nifi-docs/components/org.apache.nifi.processors.standard.CompressContent/index.html
... View more
03-31-2016
08:17 PM
Hey Jeremy, just a heads up I just added your template and mapping file to the HWX NiFi Template repo @Artem Ervits mentioned (https://github.com/hortonworks-gallery/nifi-templates)
... View more
03-02-2016
03:51 PM
1 Kudo
Hello,
The GetEmail processor is slated to be in the 0.6.0 release and the ticket is here[1]. If you'd like to help shape the direction of the processor please feel free to comment on the ticket.
[1] https://issues.apache.org/jira/browse/NIFI-1148
... View more