1973
Posts
1225
Kudos Received
124
Solutions
My Accepted Solutions
Title | Views | Posted |
---|---|---|
843 | 04-03-2024 06:39 AM | |
1619 | 01-12-2024 08:19 AM | |
801 | 12-07-2023 01:49 PM | |
1387 | 08-02-2023 07:30 AM | |
2004 | 03-29-2023 01:22 PM |
08-16-2016
01:38 PM
Thanks, I'll test it when it is released. That was fast!
... View more
07-06-2017
07:34 AM
I have the same problem Which version of EXCEL are you using ? I think that HortonWorks ODBC driver is not supported in EXCEL 2010. The HortonWorks tutorial references EXCEL version 2016
... View more
08-15-2016
12:47 AM
1 Kudo
Okay, this is my bad. Make sure you set text/html. And the content must be a full HTML file. You cannot include attributes or attach the file for HTML to work. <html><head><title>Test</title></head><body>Message From Twitter
<br>
<b>Test</b><br>
<br>
FileName: ${filename}<br>
<img src="https://pbs.twimg.com/media/Cp2_ftRWYAASiDz.jpg">
</body>
</html>
... View more
08-11-2016
01:02 PM
2 Kudos
With Apache NiFi 1.0 you can now act as a simple SMTP server (though it is recommended to sit behind a real SMTP MTA and just get mail forwards). It makes for an easy way to ingest mail, headers and attachments. The first thing you will notice is the awesome new UI, which is much cleaner and a joy to use.' First add a processor, ListenSMTP, this will be your mail gateway/SMTP server. As you can see there's also processors for extracting attachments and headers from Email. You need to make sure you set Listening Port, SMTP hostname and Max. # of Connections. The entire flow for mail processing is pretty simple, but easy to follow. We listen for SMTP over TCP Port (I chose 2025, but with Root access you could run on 25). I send the original flow file right to HDFS. I extract the attachments and put them in a separate HDFS directory and finally pull out the email headers and also send them to an HDFS file. I have a little test flow in the bottom to read a file and send email to our ListenSMTP for testing. If you are running this on an HDP 2.4 sandbox, you will need to install Java 8 and set it as an alternative JDK. http://tecadmin.net/install-java-8-on-centos-rhel-and-fedora/ alternatives --config java Pick Java 8 I added
Java 8 as an alternative and specified Java_HOME in top of bin/nifi.sh so I
could run with Java 8 which is required now. To send a test SMTP message from the command line: telnet localhost 2025
Trying 127.0.0.1...
Connected to localhost.
Escape character is '^]'.
220 sandbox.hortonworks.com ESMTP Apache NiFi
ehlo sandbox
250-sandbox.hortonworks.com
250-8BITMIME
250-SIZE 67108864
250 Ok
MAIL
FROM: <tim@sparkdeveloper.com>
250 Ok
RCPT TO: <tspann@hortonworks.com>
250 Ok
DATA
354 End data with
<CR><LF>.<CR><LF>
hello
.
250 Ok
A better way to test SMTP is with SWAKS See: https://debian-administration.org/article/633/Testing_SMTP_servers_with_SWAKS From Mac: brew install swaks From Centos/RHEL: sudo yum -y install swaks Test Send Email: swaks --to tspann@hortonworks.com --server localhost:2025
Received: from hw13125.home (localhost [127.0.0.1])
by sandbox.hortonworks.com with SMTP (Apache NiFi) id IRPEF4WI
for tspann@hortonworks.com; Wed, 10 Aug 2016 17:19:12 -0400 (EDT)
Date: Wed, 10 Aug 2016 17:19:12 -0400To:
tspann@hortonworks.com
From: tspann@hw13125.home
Subject: test Wed,
10 Aug 2016 17:19:12 -0400
X-Mailer: swaks v20130209.0 jetmore.org/john/code/swaks/
MIME-Version: 1.0
Content-Type: multipart/mixed;
boundary="----=_MIME_BOUNDARY_000_98059"------=_MIME_BOUNDARY_000_98059
Content-Type: text/plain
This is a test mailing
------=_MIME_BOUNDARY_000_98059
Content-Type: application/octet-stream
Content-Disposition: attachment
Content-Transfer-Encoding:
BASE64
------=_MIME_BOUNDARY_000_98059--
It is very easy to configure send an email message to our server you need to put in a hostname and port. Once your down building your flow, make sure you create a template and save the XML off to version control. Creating a template has now moved to the Operate control. If you get lost on what you are working for you can use the search feature from the top right. Remember this is a beta product, not yet ready for production. Wait for HDF 2.0 for supported production usage.
... View more
Labels:
08-11-2016
12:56 AM
this was from Mac local to Sandbox.
... View more
09-02-2016
02:57 AM
In Apache NiFi 1.0.0 this is fixed
... View more
08-04-2016
01:24 PM
What jars are needed? Can you attach a NiFi template
... View more
06-09-2017
08:11 AM
@timothy span did substring function really worked with sql interpreter on Zeppelin? or did you some change to the interpreter? Thank you! ,
... View more
08-24-2017
10:28 AM
I came across the same problem but I could only find the notebook folder with note.json files under this directory /usr/hdp/current/zeppelin-server/notebook, but the note.json under my latest session folder wasn't empty
... View more
08-02-2016
12:08 AM
2 Kudos
Tips Read each processor
directions carefully, inputs and outputs vary greatly from attributes, JSON, JSONPath statements and other
entries. JSONPath supports a radically different syntax than NIFI Expression Language. Know your Expression
language, there are a lot of useful
functions like UUID() and nextint(). When you are doing a lot of streaming and testing data, you will find that logs grow huge on your Centos sandbox. I built up gigabytes of logs in
Hive, Hadoop and NiFi in just a few days of operations. Check your /var/log every few days and watch the Ambari screens for data usage. When your data gets too large, things can start failing or slowing down due to a lack of temporary space, swap space and space for logs. Delete Test Files
For Ever! hdfs dfs -rm -f -skipTrash /twitter/*.json Clean up junk files. cd /
du -hsx * | sort -rh | head -10 ) PutHiveQL requires
hiveql.args.1.value and hiveql.args.1.type for all fields. If you are using EvaluateJSONPath, you cannot
set your types there. Do those in an
UpdateAttribute processor after that.
Then you need to turn your code in SQL for Hive to execute.
... View more
Labels: