IoT Working with IoT data is a many layered process, not unlike a parfait. Scratch that, an Onion. In fact, an Onion Omega2, which is a great device that I just got yesterday does IoT really easily. This is so much easier to setup that RPI or other platforms. It also has a ton of pluggable modules that stack on top of this small chip. It's pretty small powered, but it's under $10. The device is extremely well documented at their site. Needed to run real tools, I added a USB stick and used that for storage and for extra SWAP space. opkg update opkg install kmod-usb-storage-extras e2fsprogs kmod-fs-ext4 umount /tmp/mounts/USB-A1 mkfs.ext4 /dev/sda1 mkdir /mnt/sda1 mount /dev/sda1 /mnt/sda1 mount /dev/sda1 /mnt/ ; tar -C /overlay -cvf - . | tar -C /mnt/ -xf - ; umount /mnt/ opkg update opkg install block-mount opkg update opkg install swap-utils block-mount dd if=/dev/zero of=/tmp/mounts/USB-A1/swap.page bs=1M count=256 mkswap /tmp/mounts/USB-A1/swap.page swapon /tmp/mounts/USB-A1/swap.page free block detect > /etc/config/fstab Adding GPS ls /dev/ttyACM* cat /dev/ttyACM0 opkg update opkg install ogps ubus list /etc/init.d/rpcd restart ubus call gps info Using the GPS Expander, this is the JSON data returned from the utility: {"age":0,"latitude":"40.2807","longitude":"-74.6418","elevation":"38.4","course":"","speed":"N"} I then added Python and Paho MQTT Python Client for sending messages to my Cloud MQTT broker. opkg install python https://docs.onion.io/omega2-docs/installing-and-using-python.html#onion-python-modules opkg install python-pip pip install --upgrade setuptools pip install paho-mqtt crontab -e /etc/init.d/cron restart */1 * * * * /opt/demo/run.sh Once the data was sent a MQTT broker, it was easy to ingest with Apache NiFi. I ingest MQTT messages from the broker Extra Fields from the JSON File Format some parameters for SQL build my SQL string then upsert into Phoenix/HBase. This is the beautiful Web Console that comes prerunning on the tiny Onion Omega2 device. Report from the Table in Apache Zeppelin Reference https://docs.onion.io/omega2-docs/first-time-setup.html https://docs.onion.io/omega2-docs/expansion-dock.html https://docs.onion.io/omega2-docs/connecting-to-the-omega-terminal.html#connecting-to-the-omega-terminal-ssh https://docs.onion.io/omega2-docs/gps-expansion.html https://docs.onion.io/omega2-docs/using-gps-expansion.html#using-gps-expansion https://github.com/OnionIoT/onion-gpio-sysfs/tree/master/python/examples https://github.com/OnionIoT/Onion-Sensor-Server https://lede-project.org/docs/guide-quick-start/start https://docs.onion.io/omega2-docs/boot-from-external-storage.html https://wiki.onion.io/Tutorials/Extending-RAM-with-a-swap-file https://docs.onion.io/omega2-docs/extending-omega-memory.html ... View more

There are two great additions you can make to your current Hive. The first is HPL/SQL that brings stored procedure programming to the Hadoop world. The second is Hive Mall which brings advanced functions and machine learning to your Hive queries. HPL/SQL HPL/SQL is included in Hive 2.0 and will be included in Hive 2.1 on HDP 2.6. You can manually download and install it now. It is Hybrid Procedural SQL on Hadoop. For developers coming from Oracle and SQL Server, these procedures will feel very familiar and will allow you to port a lot of your existing PL/SQL and TSQL code over to Hive. This gives you another interface to Hive and Hadoop, it will be included in future Hadoop and be tied into the very fast Hive LLAP 2.1. HPL/SQL https://community.hortonworks.com/content/idea/43847/hplsql-make-sql-on-hadoop-more-dynamic.html http://www.hplsql.org/connections http://www.hplsql.org/cli http://www.hplsql.org/download http://www.hplsql.org/start To Run A Stored Procedure cd hplsql-0.3.17 ./hplsql -f proc.pl HP/SQL Stored Procedure Example create procedure fn_test1 (VarOne char(25)) BEGIN SET plhql execute immediate 'set hive.exec.dynamic.partition.mode=nonstrict'; execute immediate 'set hive.exec.dynamic.partition=true'; execute immediate 'SET hive.execution.engine=tez'; print VarOne; set VarOne = Upper(VarOne); if (VarOne not in ('STUFF', 'STUFF2')) BEGIN print 'Bad Data'; RETURN -1; END print 'Good Data'; END; print call fn_test1('STUFF'); ./hplsql -f proc.pl Call 17/03/09 20:04:03 INFO jdbc.Utils: Supplied authorities: localhost:10000 17/03/09 20:04:03 INFO jdbc.Utils: Resolved authority: localhost:10000 Open connection: jdbc:hive2://localhost:10000 (266 ms) Starting SQL statementSQL statement executed successfully (2 ms) Starting SQL statementSQL statement executed successfully (2 ms) Starting SQL statementSQL statement executed successfully (1 ms) *STUFF* Good Data Apache HiveMall HiveMall was developed by developers from Treasure Data, NTT and Hortonworks. https://community.hortonworks.com/articles/67983/apache-hive-with-apache-hivemall.html https://www.slideshare.net/HadoopSummit/hivemall-scalable-machine-learning-library-for-apache-hivesparkpig http://hivemall.incubator.apache.org/userguide/getting_started/permanent-functions.html http://hivemall.incubator.apache.org/userguide/getting_started/installation.html http://github.com/myui/hivemall http://hivemall.incubator.apache.org set hivevar:hivemall_jar=hdfs:///apps/hivemall/hivemall-with-dependencies.jar; source /opt/demo/define-all-as-permanent.hive; HiveMall is a scalable machine learning library built as a collection of Hive UDFs that you can run through Hive, Spark and Pig. It brings very cool processing to your Hive queries, Zeppelin, Pig and Spark code. You will be able to combine Hive Mall machine learning with stored procedures on in-memory fast LLAP Hive. This is revolutionary. You can run this via near real-time Apache NiFi streams. ... View more

Use Case I want to hide text messages inside images. When the images arrive somewhere else, I want to extract those messages. It let's you hide text in images, binaries in images and images in images. I was interesting in hiding text messages in images. After seeing https://en.wikipedia.org/wiki/Turn:_Washington's_Spies I thought secret messages were cool. So using the library, I take an image and text and hide the text in there. The library produces a new image (PNG) that has the message in it. I have a second script that extracts the text. The images look the same to my eyes. A future test would be to run a deep learning library or image analysis tool on the images to see if they spot the bits. They should be able to. A future NiFi tool would be to spot hidden images. It's a fun exercise to use NiFi and it seems possible that encoding messages in images were passing through Niagra Files back in the NSA days. Step 1: Hide Text (ExecuteStreamCommand) Step 2: Fetch File Step 3: UnHide Text (ExecuteStreamCommand) The left image is the original image and the right PNG is the output image with text. The size on disk has increased at a noticeable level. The python source code is in github and referenced below: hide.sh wget $1 -O img.jpg python hidetext.py img.jpg "$2" hidetext.py import cv from LSBSteg import LSBSteg import sys imagename=sys.argv[1] textstring=sys.argv[2] carrier = cv.LoadImage(imagename) steg = LSBSteg(carrier) steg.hideText(textstring) steg.saveImage(imagename + ".png") #Image that contain datas unhide.sh python unhidetext.py $1 unhidetext.py import cv from LSBSteg import LSBSteg import sysimagename=sys.argv[1] im = cv.LoadImage(imagename)steg = LSBSteg(im) print steg.unhideText() For installation, you need to download LSB-Steganography script. OpenCV pip install cv Reference: https://en.wikipedia.org/wiki/Steganography https://github.com/tspannhw/spy https://github.com/RobinDavid/LSB-Steganography ... View more

1. Host a Web Page (index.html) via HTTP GET with 200 OK Status 2. Receive POST from that page via AJAX with browser data 3. Extract Content and Attributes 4. Build a JSON file of HTTP data 5. Store it To accept location in a phone or modern browser you must be running SSL. So I added that for this HTTP Request. Use openssl to create your 2048 RSA X509, PKCS12, JKS Keystore, Import Trust Store and import in browser Your web page can be any web page, just POST back via AJAX or Form Submit. <html> <head> <title>NiFi Browser Data Acquisition</title> <body> <script> // Usage window.onload = function() { navigator.getBattery().then(function(battery) { console.log(battery.level); battery.addEventListener('levelchange', function() { console.log(this.level); }); }); }; ////////////// print these var latitude = ""; var longitude = ""; var ips = ""; var batteryInfo = ""; var screenInfo = screen.width +","+ screen.height + "," + screen.availWidth +","+ screen.availHeight + "," + screen.colorDepth + "," + screen.pixelDepth; var pluginsInfo = ""; var coresInfo = ""; ///////////// ////// Set Plugins for (var i = 0; i < 12; i++) { if ( typeof window.navigator.plugins[i] !== 'undefined' ) { pluginsInfo += window.navigator.plugins[i].name + ', '; } } ////// Set Cores if ( window.navigator.hardwareConcurrency > 0 ) { coresInfo = window.navigator.hardwareConcurrency + " cores"; } ///////////// /// send the information to the server function loadDoc() { var xhttp = new XMLHttpRequest(); xhttp.onreadystatechange = function() { if (this.readyState == 4 && this.status == 200) { document.getElementById("demo").innerHTML = 'Sent.'; } }; // /send xhttp.open("POST", "/send", true); xhttp.setRequestHeader("Content-type", "application/json"); xhttp.send('{"plugins":"' + pluginsInfo + '", "screen":"' + screenInfo + '", "cores":"' + coresInfo + '", "battery":"' + batteryInfo + '", "ip":"' + ips + '", "lat":"' + latitude + '", "lng":"' + longitude + '"}') } //////////// function geoFindMe() { var output = document.getElementById("out"); if (!navigator.geolocation){ output.innerHTML = "<p>Geolocation is not supported by your browser</p>"; return; } function success(position) { latitude = position.coords.latitude; longitude = position.coords.longitude; output.innerHTML = '<p>Latitude is ' + latitude + '° <br>Longitude is ' + longitude + '°</p>'; var img = new Image(); img.src="https://maps.googleapis.com/maps/api/staticmap?center=" + latitude + "," + longitude + "&zoom=13&size=300x300&sensor=false"; output.appendChild(img); } function error() { output.innerHTML = "Unable to retrieve your location"; } output.innerHTML = "<p>Locating…</p>"; navigator.geolocation.getCurrentPosition(success, error); } //get the IP addresses associated with an account function getIPs(callback){ var ip_dups = {}; //compatibility for firefox and chrome var RTCPeerConnection = window.RTCPeerConnection || window.mozRTCPeerConnection || window.webkitRTCPeerConnection; var useWebKit = !!window.webkitRTCPeerConnection; //bypass naive webrtc blocking using an iframe if(!RTCPeerConnection){ //NOTE: you need to have an iframe in the page right above the script tag // //<iframe id="iframe" sandbox="allow-same-origin" style="display: none"></iframe> //<script>...getIPs called in here... // var win = iframe.contentWindow; RTCPeerConnection = win.RTCPeerConnection || win.mozRTCPeerConnection || win.webkitRTCPeerConnection; useWebKit = !!win.webkitRTCPeerConnection; } //minimal requirements for data connection var mediaConstraints = { optional: [{RtpDataChannels: true}] }; var servers = {iceServers: [{urls: "stun:stun.services.mozilla.com"}]}; //construct a new RTCPeerConnection var pc = new RTCPeerConnection(servers, mediaConstraints); function handleCandidate(candidate){ //match just the IP address var ip_regex = /([0-9]{1,3}(\.[0-9]{1,3}){3}|[a-f0-9]{1,4}(:[a-f0-9]{1,4}){7})/ var ip_addr = ip_regex.exec(candidate)[1]; //remove duplicates if(ip_dups[ip_addr] === undefined) callback(ip_addr); ip_dups[ip_addr] = true; } //listen for candidate events pc.onicecandidate = function(ice){ //skip non-candidate events if(ice.candidate) handleCandidate(ice.candidate.candidate); }; //create a bogus data channel pc.createDataChannel(""); //create an offer sdp pc.createOffer(function(result){ //trigger the stun server request pc.setLocalDescription(result, function(){}, function(){}); }, function(){}); //wait for a while to let everything done setTimeout(function(){ //read candidate info from local description var lines = pc.localDescription.sdp.split('\n'); lines.forEach(function(line){ if(line.indexOf('a=candidate:') === 0) handleCandidate(line); }); }, 1000); } window.addEventListener("load", function (ev) { "use strict"; var log = document.getElementById("log"); // https://dvcs.w3.org/hg/dap/raw-file/tip/sensor-api/Overview.html window.addEventListener("devicetemperature", function (ev) { log.textContent += "devicetemperature " + ev.value + "\n"; }, false); window.addEventListener("devicepressure", function (ev) { log.textContent += "devicepressure " + ev.value + "\n"; }, false); window.addEventListener("devicelight", function (ev) { log.textContent += "devicelight " + ev.value + "\n"; // toy tric log.style.color = "rgb(" + (255 - 2*ev.value) + ",0,0)"; log.style.backgroundColor = "rgb(0,0," + (2*ev.value) + ")"; }, false); window.addEventListener("deviceproximity", function (ev) { log.textContent += "deviceproximity " + ev.value + "\n"; // toy tric if (ev.value < 3) navigator.vibrate([300, 100, 100]); }, false); window.addEventListener("devicenoise", function (ev) { log.textContent += "devicenoise " + ev.value + "\n"; }, false); window.addEventListener("devicehumidity", function (ev) { log.textContent += "devicehumidity " + ev.value + "\n"; }, false); //https://wiki.mozilla.org/Magnetic_Field_Events window.addEventListener("devicemagneticfield", function (ev) { log.textContent += "devicemagneticfield " + [ev.x, ev.y, ev.x]+ "\n"; }, false); // https://dvcs.w3.org/hg/dap/raw-file/default/pressure/Overview.html window.addEventListener("atmpressure", function (ev) { log.textContent += "atmpressure " + ev.value + "\n"; }, false); // https://dvcs.w3.org/hg/dap/raw-file/tip/humidity/Overview.html window.addEventListener("humidity", function (ev) { log.textContent += "humidity " + ev.value + "\n"; }, false); // https://dvcs.w3.org/hg/dap/raw-file/tip/temperature/Overview.html window.addEventListener("temperature", function (ev) { log.textContent += "temperature " + [ev.f, ev.c, ev.k, ev.value] + "\n"; }, false); // https://dvcs.w3.org/hg/dap/raw-file/tip/battery/Overview.html try { if (typeof navigator.getBattery === "function") { navigator.getBattery().then(function (battery) { log.textContent += "battery.level " + battery.level + "\n"; log.textContent += "battery.charging " + battery.charging + "\n"; batteryInfo = "battery.level=" + battery.level + "," + "battery.charging=" + battery.charging; log.textContent += "battery.chargeTime " + battery.chargeTime + "\n"; log.textContent += "battery.dischargeTime " + battery.dischargeTime + "\n"; battery.addEventListener("levelcharge", function (ev) { log.textContent += "change battery.level " + battery.level + "\n"; }, false); }).catch(function (err) { log.textContent += err.toString() + "\n"; }); } else { log.textContent += ""; } } catch (ex) { log.textContent += ex.toString() + "\n"; } }, false); </script> <p> <br> DEMO: Send Data to HDF / Apache NiFi via HandleHTTPRequest <br> <p><button onclick="geoFindMe()">Show my location</button></p> <div id="out"></div> <div id="demo"></div> <pre id="log"></pre> <button type="button" onclick="loadDoc()">Send data to Apache NiFi SSL Server</button> <iframe id="iframe" sandbox="allow-same-origin" style="display: none"></iframe> <script> getIPs(function(ip){ips = ip;}); </script> </body> </html> index.html : A web page to grab user information. mobile-ingest-v3.xml : Apache NiFi 1.1.x template. Note: Different browsers, devices, phones, tables and versions will send different values. Users should get a location request pop-up. JSON Result File { "http.request.uri" : "/send", "http.context.identifier" : "a4f9ae25-5f49-463e-97eb-c8a6bf3be8a7", "http.remote.host" : "192.xxx.1.xxx", "http.headers.Host" : "192.xxx.1.xxx:9178", "http.local.name" : "192.xxx.1.xxx", "http.headers.DNT" : "1", "plugins" : "Widevine Content Decryption Module, Shockwave Flash, Chrome PDF Viewer, Native Client, Chrome PDF Viewer, ", "latitude" : "40.2681799", "http.headers.Accept" : "*/*", "battery" : "battery.level=1,battery.charging=true", "uuid" : "a2f299ae-6ef6-480d-a359-1362d25abe76", "http.request.url" : "https://192.168.1.151:9178/send", "http.server.name" : "192.168.1.151", "http.character.encoding" : "UTF-8", "path" : "./", "cores" : "8 cores", "http.remote.addr" : "192.168.1.151", "http.headers.User-Agent" : "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_3) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/56.0.2924.87 Safari/537.36", "http.method" : "POST", "http.headers.Connection" : "keep-alive", "longitude" : "-74.5291745", "http.server.port" : "9178", "ip" : "192.168.1.151", "mime.type" : "application/json", "http.locale" : "en_US", "http.headers.Accept-Encoding" : "gzip, deflate, br", "http.headers.Origin" : "https://192.168.1.151:9178", "http.servlet.path" : "", "http.local.addr" : "192.168.1.151", "filename" : "1082639525534467", "http.headers.Referer" : "https://192.168.1.151:9178/", "http.headers.Accept-Language" : "en-US,en;q=0.8", "http.headers.Content-Length" : "253", "http.headers.Content-Type" : "application/json", "RouteOnAttribute.Route" : "isjsonpost" } References: https://github.com/tspannhw/webdataingest http://webkay.robinlinus.com/ https://github.com/RobinLinus/autofill-phishing https://github.com/RobinLinus/ubercookie https://github.com/RobinLinus/socialmedia-leak https://www.w3schools.com/jsref/prop_screen_availheight.asp https://community.hortonworks.com/articles/27033/https-endpoint-in-nifi-flow.html http://www.batchiq.com/nifi-configuring-ssl-auth.html https://community.hortonworks.com/articles/886/securing-nifi-step-by-step.html http://mobilehtml5.org/ https://gist.github.com/bellbind/c60d7008e86c34a76aa1 https://github.com/coremob/camera http://www.girliemac.com/presentation-slides/html5-mobile-approach/deviceAPIs.html?full#23 https://github.com/girliemac/sushi-compass/blob/master/js/app.js https://github.com/noipfraud/IPLock http://www.tomanthony.co.uk/blog/detect-visitor-social-networks/ https://appsec-labs.com/html5/#toggle-id-5 https://mobiforge.com/design-development/sense-and-sensor-bility-access-mobile-device-sensors-with-javascript https://www.html5rocks.com/en/tutorials/device/orientation/ http://qnimate.com/html5-proximity-api/ ... View more